Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 11.3(EOL)
-
None
Description
undo_space_dblwr test case fails if the first page of undo
tablespace is not flushed before restart the server. While restarting
the server, InnoDB fails to detect the first page of undo
tablespace from doublewrite buffer.
Steps to repeat the scenario:
diff --git a/mysql-test/suite/innodb/t/undo_space_dblwr.test b/mysql-test/suite/innodb/t/undo_space_dblwr.test
|
index b6fd6738a1c..c93c45dd7f6 100644
|
--- a/mysql-test/suite/innodb/t/undo_space_dblwr.test
|
+++ b/mysql-test/suite/innodb/t/undo_space_dblwr.test
|
@@ -21,7 +21,7 @@ set global innodb_fil_make_page_dirty_debug = 1;
|
SET GLOBAL innodb_max_dirty_pages_pct_lwm=0.0;
|
SET GLOBAL innodb_max_dirty_pages_pct=0.0;
|
|
-sleep 1;
|
+#sleep 1;
|
--let CLEANUP_IF_CHECKPOINT=drop table t1;
|
--source ../include/no_checkpoint_end.inc
|
|
Error log file contains:
2024-01-31 14:40:46 0 [ERROR] InnoDB: Checksum mismatch in the first page of file .//undo001
|
2024-01-31 14:40:46 0 [ERROR] InnoDB: Unable to read first page of file .//undo001
|
2024-01-31 14:40:46 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1386] with error Data structure corruption
|
Attachments
Issue Links
- relates to
-
MDEV-31851 After crash recovery, Checksum mismatch + Failing assertion: !i || prev_id + 1 == space_id,
- Closed