Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
|
CREATE TABLE t (a YEAR PRIMARY KEY, KEY(a)) ENGINE=InnoDB; |
INSERT INTO t VALUES (2005),(2030); |
|
|
--let $shutdown_timeout=0
|
--source include/restart_mysqld.inc
|
|
|
# Cleanup
|
DROP TABLE t; |
|
10.5 fb70bb44 |
2022-09-16 23:50:59 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=47807,47807
|
2022-09-16 23:50:59 0 [Note] InnoDB: Starting final batch to recover 11 pages from redo log.
|
2022-09-16 23:50:59 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=4]
|
2022-09-16 23:50:59 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
|
2022-09-16 23:50:59 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1501] with error Data structure corruption
|
10.6+ produces a bit more output
|
10.6 fd0bdd31 |
2022-09-17 0:17:10 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=42790,42790
|
2022-09-17 0:17:10 0 [Note] InnoDB: Starting final batch to recover 7 pages from redo log.
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Not applying INSERT_HEAP_DYNAMIC due to corruption on [page id: space=5, page number=4]
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore corruption.
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=5, page number=4]; set innodb_force_recovery to ignore
|
2022-09-17 0:17:10 0 [Note] InnoDB: Set innodb_force_recovery=1 to ignore corrupted pages.
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
|
2022-09-17 0:17:10 0 [Note] InnoDB: Starting shutdown...
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=0, page number=9]; set innodb_force_recovery to ignore
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=1, page number=3]; set innodb_force_recovery to ignore
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Failed to read page 3 from file './mysql/innodb_table_stats.ibd': Page read from tablespace is corrupted.
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Failed to read page 9 from file './ibdata1': Page read from tablespace is corrupted.
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Unable to apply log to corrupted page [page id: space=2, page number=3]; set innodb_force_recovery to ignore
|
2022-09-17 0:17:10 0 [ERROR] InnoDB: Failed to read page 3 from file './mysql/innodb_index_stats.ibd': Page read from tablespace is corrupted.
|
2022-09-17 0:17:10 0 [ERROR] Plugin 'InnoDB' init function returned error.
|
Reproducible on 10.5-10.10, including older minor releases.
Not reproducible on 10.4.
Attachments
Issue Links
- is caused by
-
-
- Closed
-