summaryrefslogtreecommitdiff
path: root/issues
diff options
context:
space:
mode:
Diffstat (limited to 'issues')
-rw-r--r--issues/database-not-responding.gmi43
-rw-r--r--issues/systems/octopus.gmi11
2 files changed, 54 insertions, 0 deletions
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