Page MenuHomePhabricator

MariaDB Replica SQL: s6 on db2158 is CRITICAL: CRITICAL slave_sql_state Slave_SQL_Running: No, Errno: 1034, Errmsg: Error Index for table recentchanges is corrupt: try to repair it on query. Default database: ruwiki.
Closed, ResolvedPublic

Description

PROBLEM - MariaDB Replica SQL: s6 #page on db2158 is CRITICAL: CRITICAL slave_sql_state Slave_SQL_Running: No, Errno: 1034, Errmsg: Error Index for table recentchanges is corrupt: try to repair it on query. Default database: ruwiki. [Query snipped]

Dec 10 17:11:03 db2158 mysqld[1411]: 2024-12-10 17:11:03 468460009 [ERROR] InnoDB: We detected index corruption in an InnoDB type table. You have to dump + drop + reimport the table or, in a case of widespread corruption, dump all InnoDB tables and recreate the whole tablespace. If the mariadbd server crashes after the startup or when you dump the tables. Please refer to https://mariadb.com/kb/en/library/innodb-recovery-modes/ for information about forcing recovery.

Event Timeline

Mentioned in SAL (#wikimedia-operations) [2024-12-10T17:24:25Z] <herron@cumin1002> dbctl commit (dc=all): 'depooling db2158 T381901', diff saved to https://phabricator.wikimedia.org/P71687 and previous config saved to /var/cache/conftool/dbconfig/20241210-172424-herron.json

Marostegui claimed this task.
Marostegui subscribed.

I fixed that and upgraded the host to 10.6.20. Doc updated.