From 5fd0df92b333b4d4bab75ac719badd451d9efc8e Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Sun, 25 Jul 2021 11:19:18 +0200
Subject: Issue added

---
 issues/database-not-responding.gmi | 13 +++++++++++++
 1 file changed, 13 insertions(+)
 create mode 100644 issues/database-not-responding.gmi

(limited to 'issues')

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.
-- 
cgit 1.4.1