The following hosts errored weeks ago on some tables,
Mar 11 08:21:35 db2148 mysqld[3190]: 2021-03-11 8:21:35 9 [ERROR] InnoDB: Record in index `pl_namespace` of table `zhwiki`.`pagelinks` was not found on update: TUPLE (info_bits=0, 3 fields): {[4] (0x80000000),[12] (0xE799BDE6B2B3E6ACA1E9838E),[4] : #(0x003A2023)} at: COMPACT RECORD(info_bits=0, 3 fields): {[4] (0x80000000),[12] (0xE799BDE6B2B3E6ACA1E9838E),[4] 5D (0x0035440E)} Mar 11 08:26:04 db2148 mysqld[3190]: 2021-03-11 8:26:04 0 [ERROR] InnoDB: Unable to find a record to delete-mark Mar 11 08:26:04 db2148 mysqld[3190]: InnoDB: tuple DATA TUPLE: 2 fields; Mar 11 08:26:04 db2148 mysqld[3190]: 0: len 4; hex 000016bd; asc ;; Mar 11 08:26:04 db2148 mysqld[3190]: 1: len 4; hex 00502339; asc P#9;; Mar 11 08:26:04 db2148 mysqld[3190]: InnoDB: record PHYSICAL RECORD: n_fields 2; compact format; info bits 0 Mar 11 08:26:04 db2148 mysqld[3190]: 0: len 4; hex 000016bd; asc ;; Mar 11 08:26:04 db2148 mysqld[3190]: 1: len 4; hex 004f8ffc; asc O ;; Mar 11 08:26:04 db2148 mysqld[3190]: 2021-03-11 8:26:04 0 [ERROR] InnoDB: page [page id: space=7711, page number=60672] (631 records, index id 28998). Mar 11 08:26:04 db2148 mysqld[3190]: 2021-03-11 8:26:04 0 [ERROR] InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
Those usually mark tables that might have corrupted indexes.
Running: mysqlcheck $database should mark those tables as corrupted.
Let's check and rebuild the affected tables:
- db1134
- db1150:3315
- db1150:3314
- db1166
- db1168
- db1175
- db1146
- db2092
- db2145
- db2146
- db2116
- db2102 (core test)
- db2148
- db2108
- db2120
- db2150