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

---
 README.gmi                         |  2 ++
 issues/database-not-responding.gmi | 13 +++++++++++++
 2 files changed, 15 insertions(+)
 create mode 100644 issues/database-not-responding.gmi

diff --git a/README.gmi b/README.gmi
index f2822e4..4bcb44d 100644
--- a/README.gmi
+++ b/README.gmi
@@ -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.
-- 
cgit v1.2.3