From 9a0198e9b23a1995ca5e23be6c06039b580c7123 Mon Sep 17 00:00:00 2001
From: Pjotr Prins
Date: Wed, 22 Feb 2023 07:53:59 -0600
Subject: Update documentation

---
 issues/database-not-responding.gmi | 43 ++++++++++++++++++++++++++++++++++++++
 issues/systems/octopus.gmi         | 11 ++++++++++
 2 files changed, 54 insertions(+)

(limited to 'issues')

diff --git a/issues/database-not-responding.gmi b/issues/database-not-responding.gmi
index 8928d08..8cb5656 100644
--- a/issues/database-not-responding.gmi
+++ b/issues/database-not-responding.gmi
@@ -294,6 +294,49 @@ MariaDB [db_webqtl]> SHOW VARIABLES LIKE '%timeout%';
 
 If you set wait_timeout and interactive_timeout values they get reset after a while.
 
+# Recent crash
+
+```
+| Max_used_connections                          | 1030   |
+| Threads_connected                             | 1030   |
+
+show open tables where in_use > 1;
+
++-----------+----------------+--------+-------------+
+| Database  | Table          | In_use | Name_locked |
++-----------+----------------+--------+-------------+
+| db_webqtl | ProbeFreeze    |    182 |           0 |
+| db_webqtl | ProbeSet       |      3 |           0 |
+| db_webqtl | ProbeSetXRef   |      3 |           0 |
+| db_webqtl | PublishFreeze  |      7 |           0 |
+| db_webqtl | Species        |     94 |           0 |
+| db_webqtl | Tissue         |     94 |           0 |
+| db_webqtl | ProbeSetFreeze |      3 |           0 |
+| db_webqtl | InbredSet      |    108 |           0 |
+| db_webqtl | GenoFreeze     |      7 |           0 |
++-----------+----------------+--------+-------------+
+```
+
+```
+FLUSH NO_WRITE_TO_BINLOG TABLES
+
+Waiting for table flush SELECT confidentiality, AuthorisedUsers FROM ProbeSetFreeze WHERE Name = 'EL_BXDCDScWAT_0216' 0.000
+
+Waiting for table flush SELECT DISTINCT Tissue.Name FROM ProbeFreeze,ProbeSetFreeze, InbredSet, Tissue, Species WHERE Speci  0.000
+```
+
+Another one to check next time is
+
+```
+SHOW ENGINE INNODB STATUS
+```
+
+and
+
+```
+mariabackup --backup --kill-long-query-type=SELECT --kill-long-queries-timeout=120
+```
+
 # Monitor connections
 
 Use the general log as described in
diff --git a/issues/systems/octopus.gmi b/issues/systems/octopus.gmi
index 1420865..bc421eb 100644
--- a/issues/systems/octopus.gmi
+++ b/issues/systems/octopus.gmi
@@ -26,3 +26,14 @@ default via 172.23.16.1 dev ens1f0np0
 172.23.16.0/21 dev eno1 proto kernel scope link src 172.23.18.68
 172.23.16.0/21 dev eno2 proto kernel scope link src 172.23.17.134
 ```
+
+# Current topology
+
+```
+ip a
+ip route
+```
+
+- Octopus01 uses eno1 172.23.18.188/21 gateway 172.23.16.1 (eno1: Link is up at 1000 Mbps)
+- Octopus02 uses eno1 172.23.17.63/21  gateway 172.23.16.1 (eno1: Link is up at 1000 Mbps)
+                      172.23.x.x
-- 
cgit v1.2.3