summaryrefslogtreecommitdiff
path: root/issues
diff options
context:
space:
mode:
authorPjotr Prins2023-02-15 09:53:43 -0600
committerPjotr Prins2023-02-15 09:55:45 -0600
commitea9b2f14836158def6c524152c77c542124f428a (patch)
treec45f2e216a0d8c4bbbc69511da0d331acec10fc5 /issues
parentc917dc541b60aab15d086612e420dd9fd9efb9cb (diff)
downloadgn-gemtext-ea9b2f14836158def6c524152c77c542124f428a.tar.gz
notes on db
Diffstat (limited to 'issues')
-rw-r--r--issues/database-not-responding.gmi18
1 files changed, 18 insertions, 0 deletions
diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi
index dec9b1e..e842a89 100644
--- a/issues/database-not-responding.gmi
+++ b/issues/database-not-responding.gmi
@@ -77,6 +77,24 @@ MariaDB [db_webqtl]> show open tables where in_use > 1;
11 rows in set (0.001 sec)
```
+```
+MariaDB [db_webqtl]> show open tables where in_use > 1;
++-----------+----------------+--------+-------------+
+| Database | Table | In_use | Name_locked |
++-----------+----------------+--------+-------------+
+| db_webqtl | ProbeFreeze | 191 | 0 |
+| db_webqtl | ProbeSet | 6 | 0 |
+| db_webqtl | ProbeSetXRef | 6 | 0 |
+| db_webqtl | PublishFreeze | 13 | 0 |
+| db_webqtl | Species | 106 | 0 |
+| db_webqtl | Tissue | 106 | 0 |
+| db_webqtl | ProbeSetFreeze | 6 | 0 |
+| db_webqtl | InbredSet | 132 | 0 |
+| db_webqtl | GenoFreeze | 13 | 0 |
++-----------+----------------+--------+-------------+
+9 rows in set (0.001 sec)
+```
+
In the error log we seeing a lot of
```