[MDEV-37659] CHECK TABLE…EXTENDED reports a bogus error on a column prefix index - Jira

XML

Word

Printable

Bug Category:
Can result in unexpected behaviour
Release Note Summary:
CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index.

Corruption found on release build while testing ~~MDEV-37619~~

->/Server_bin/MDEV-37619_RelWithDebInfo<- GIT_SHOW: HEAD -> MDEV-37619, origin/MDEV-37619 ffc5239ddd9c32031ad364111231f9ee26754e1f
# 2025-09-15T07:49:34 [74206] ERROR: Executor: The query ' CHECK TABLE t1 EXTENDED /* E_R Thread4 QNO 1051 CON_ID 38 */ ' passed but has a result set line 'test.t1 check Warning InnoDB: The B-tree of index MarvÃ£o_uidx1 is corrupted.'.
# 2025-09-15T07:49:34 [74206] ERROR: Executor: Full result of -> CHECK TABLE t1 EXTENDED /* E_R Thread4 QNO 1051 CON_ID 38 */ <-
# 2025-09-15T07:49:34 [74206] test.t1 check Warning InnoDB: The B-tree of index MarvÃ£o_uidx1 is corrupted.
# 2025-09-15T07:49:34 [74206] test.t1 check error Corrupt
# 2025-09-15T07:49:34 [74206] ERROR: Executor: Will exit with exit status STATUS_DATABASE_CORRUPTION(106).

RR trace is present on pluto:-
/data/results/1757919698/TBR-2332

causes

MDEV-37838 CHECK TABLE reports bogus corruption on a UNIQUE INDEX that includes NULL

is caused by

MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies

relates to

MDEV-37189 Assertion `mode == 16 || mode == 12' failed

MDEV-37753 lock_sec_rec_some_has_impl() unnecessarily fetches history and a freed BLOB

MDEV-37831 The B-tree of index FTS_DOC_ID_INDEX is corrupted

MDEV-37619 The forced use of THD accessor functions hurts InnoDB performance

(1 relates to)