diff options
Diffstat (limited to 'issues')
| -rw-r--r-- | issues/database-not-responding.gmi | 43 | ||||
| -rw-r--r-- | issues/systems/octopus.gmi | 11 |
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 |