diff options
| -rw-r--r-- | README.gmi | 2 | ||||
| -rw-r--r-- | issues/database-not-responding.gmi | 13 |
2 files changed, 15 insertions, 0 deletions
@@ -11,3 +11,5 @@ We have decided to move our existing issue trackers and kanban board to one gemi => https://en.wikipedia.org/wiki/Gemini_(protocol) Gemini protocol Issues are simple gemini documents that grow downwards - dating of additions is managed through git. We'll add a proxy to display these documents. The kanban is managed through a directory and symbolic links. + +=> issues/README.gmi Issue tracker diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi new file mode 100644 index 0000000..c8e752b --- /dev/null +++ b/issues/database-not-responding.gmi @@ -0,0 +1,13 @@ +# Mariadb table locked + +Arthur reports: MariaDB is not responding Saturday, July 24 2021 at 10:48 pm. I tried to enter data to the table ProbeSetXRef.pValue and when normally takes few seconds, now is more than 10 minutes without completion/responding. + +Zach: before restarting the table can you check the status first? + +=> https://mariadb.com/kb/en/show-table-status/ + +some ideas here + +=> https://dba.stackexchange.com/questions/98725/mariadb-innodb-what-to-do-on-locks-in-status-log-but-no-locked-table-found + +we are still using MyISAM for these tables: a switch to InnoDB may help. |