diff options
| author | Pjotr Prins | 2025-03-04 10:12:25 +0100 |
|---|---|---|
| committer | Pjotr Prins | 2025-03-04 10:12:25 +0100 |
| commit | 9577323e37451faf1a400f35713ef3e1fc396164 (patch) | |
| tree | 7bb844c0c020ef6dd03122756f99cea7f82cfa0a /issues/systems/tux04-disk-issues.gmi | |
| parent | 68dff8c4c466b55807042a397a7db63ca3ac5420 (diff) | |
| download | gn-gemtext-9577323e37451faf1a400f35713ef3e1fc396164.tar.gz | |
tux04 erroring
Diffstat (limited to 'issues/systems/tux04-disk-issues.gmi')
| -rw-r--r-- | issues/systems/tux04-disk-issues.gmi | 26 |
1 files changed, 15 insertions, 11 deletions
diff --git a/issues/systems/tux04-disk-issues.gmi b/issues/systems/tux04-disk-issues.gmi index 3da6ba9..130c2b9 100644 --- a/issues/systems/tux04-disk-issues.gmi +++ b/issues/systems/tux04-disk-issues.gmi @@ -175,26 +175,30 @@ mysqldump -uwebqtlout db_webqtl SnpAll > SnpAll.sql Running the backup with rate limiting from: +``` Mar 02 17:09:59 tux04 sudo[548058]: pam_unix(sudo:session): session opened for user root(uid=0) by wrk(uid=1000) Mar 02 17:09:59 tux04 sudo[548058]: wrk : TTY=pts/3 ; PWD=/export3/local/home/wrk/iwrk/deploy/gn-deploy-servers/scripts/tux04 ; USER=roo> Mar 02 17:09:55 tux04 sudo[548058]: pam_unix(sudo:auth): authentication failure; logname=wrk uid=1000 euid=0 tty=/dev/pts/3 ruser=wrk rhost= > Mar 02 17:04:26 tux04 su[548006]: pam_unix(su:session): session opened for user ibackup(uid=1003) by wrk(uid=0) +``` Oh oh -Tux04 is showing errors on all disks. We have to bail out. I am copying the -potentially corrupted files to tux01 right now. We have backups, so nothing -serious I hope. I am only worried about the myisam files we have because they -have no strong internal validation: +Tux04 is showing errors on all disks. We have to bail out. I am copying the potentially corrupted files to tux01 right now. We have backups, so nothing serious I hope. I am only worried about the myisam files we have because they have no strong internal validation: + +``` +2025-03-04 8:32:45 502 [ERROR] db_webqtl.ProbeSetData: Record-count is not ok; is 5264578601 Should be: 5264580806 +2025-03-04 8:32:45 502 [Warning] db_webqtl.ProbeSetData: Found 28665 deleted space. Should be 0 +2025-03-04 8:32:45 502 [Warning] db_webqtl.ProbeSetData: Found 2205 deleted blocks Should be: 0 +2025-03-04 8:32:45 502 [ERROR] Got an error from thread_id=502, ./storage/myisam/ha_myisam.cc:1120 +2025-03-04 8:32:45 502 [ERROR] MariaDB thread id 502, OS thread handle 139625162532544, query id 837999 localhost webqtlout Checking table +CHECK TABLE ProbeSetData +2025-03-04 8:34:02 79695 [ERROR] mariadbd: Table './db_webqtl/ProbeSetData' is marked as crashed and should be repaired +``` -> 2025-03-04 8:32:45 502 [ERROR] db_webqtl.ProbeSetData: Record-count is not ok; is 5264578601 Should be: 5264580806 -> 2025-03-04 8:32:45 502 [Warning] db_webqtl.ProbeSetData: Found 28665 deleted space. Should be 0 -> 2025-03-04 8:32:45 502 [Warning] db_webqtl.ProbeSetData: Found 2205 deleted blocks Should be: 0 -> 2025-03-04 8:32:45 502 [ERROR] Got an error from thread_id=502, ./storage/myisam/ha_myisam.cc:1120 -> 2025-03-04 8:32:45 502 [ERROR] MariaDB thread id 502, OS thread handle 139625162532544, query id 837999 localhost webqtlout Checking table -> CHECK TABLE `ProbeSetData` -> 2025-03-04 8:34:02 79695 [ERROR] mariadbd: Table './db_webqtl/ProbeSetData' is marked as crashed and should be repaired +See also +=> https://dev.mysql.com/doc/refman/8.4/en/myisam-check.html Tux04 will require open heart 'disk controller' surgery and some severe testing before we move back. We'll also look at tux05-8 to see if they have similar problems. |