Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.11, 11.0(EOL)
-
None
Description
The test innodb.doublewrite_debug that was recently added in MDEV-32242 is occasionally failing on 10.6 and 10.11 like this:
10.6 98287bd2d6877969514469ebfbf27f9951b99657 |
innodb.doublewrite_debug '32k,innodb,strict_crc32' w28 [ fail ]
|
Test ended at 2023-12-19 16:08:33
|
|
CURRENT_TEST: innodb.doublewrite_debug
|
mysqltest: At line 131: query 'select f1, f2 from t1' failed: ER_UNKNOWN_STORAGE_ENGINE (1286): Unknown storage engine 'InnoDB'
|
|
The result from queries just before the failure was:
|
< snip >
|
# system tablespace is corrupted and 2nd page as corrupted.
|
set global innodb_log_checkpoint_now = 1;
|
begin;
|
insert into t1 values (6, repeat('%', 400));
|
# Make the first page dirty for system tablespace
|
set global innodb_saved_page_number_debug = 0;
|
set global innodb_fil_make_page_dirty_debug = 0;
|
# Make the second page dirty for system tablespace
|
set global innodb_saved_page_number_debug = 1;
|
set global innodb_fil_make_page_dirty_debug = 0;
|
set global innodb_buf_flush_list_now = 1;
|
# Corrupt the 1st page (page_no=0) and 2nd page of the system tablespace.
|
# restart
|
FOUND 2 /InnoDB: Restoring page \[page id: space=0, page number=0\] of datafile/ in mysqld.1.err
|
FOUND 1 /InnoDB: Recovered page \[page id: space=0, page number=1\]/ in mysqld.1.err
|
check table t1;
|
Table Op Msg_type Msg_text
|
test.t1 check Error Unknown storage engine 'InnoDB'
|
test.t1 check error Corrupt
|
select f1, f2 from t1;
|
Attachments
Issue Links
- relates to
-
MDEV-32242 innodb.doublewrite test case always gets skipped
- Closed