Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.11, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Description
--source include/have_innodb.inc
|
|
CREATE TEMPORARY TABLE t (f INT, UNIQUE(f)) ENGINE=InnoDB; |
INSERT INTO t (f) VALUES (1),(2); |
CHECK TABLE t; |
|
# Cleanup
|
DROP TABLE t; |
10.6 c4ce012e |
CHECK TABLE t; |
Table Op Msg_type Msg_text |
test.t check Warning InnoDB: Invalid PAGE_MAX_TRX_ID=0 in index 'f' |
test.t check Warning InnoDB: Invalid PAGE_MAX_TRX_ID=0 in index 'f' |
test.t check Warning InnoDB: The B-tree of index f is corrupted. |
test.t check Warning InnoDB: Index 'f' contains 0 entries, should be 2. |
test.t check error Corrupt |
DROP TABLE t; |
bug.15453 'innodb' [ fail ] Found warnings/errors in server log file! |
Test ended at 2022-11-08 16:59:22 |
line
|
2022-11-08 16:59:21 4 [ERROR] InnoDB: Unable to flag corruption of `f` in table `mysqld.1`.`#sql-temptable-2a260c-4-f` in CHECK TABLE-check index |
The errors started showing up after
commit ab0190101b0587e0e03b2d75a967050b9a85fd1b
|
Author: Marko Mäkelä
|
Date: Fri Oct 21 10:02:54 2022 +0300
|
|
MDEV-24402: InnoDB CHECK TABLE ... EXTENDED
|
Attachments
Issue Links
- is caused by
-
MDEV-24402 CHECK TABLE may miss some cases of index inconsistencies
- Closed