[MDEV-32242] innodb.doublewrite test case always gets skipped Created: 2023-09-25  Updated: 2024-01-22  Resolved: 2023-12-07

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5, 10.6, 10.10, 10.11, 11.1, 11.2
Fix Version/s: 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Major
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-33098 The test innodb.doublewrite_debug occ... Closed
relates to MDEV-33295 innodb.doublewrite,64k,strict_crc32 o... Open
relates to MDEV-32968 InnoDB fails to restore tablespace fi... Closed

 Description   

Re-write the `innodb.doublewrite` test case. Because it is being skipped everytime
on debug build.

 
innodb.doublewrite '32k,innodb,strict_crc32' [ skipped ]  Extra checkpoint 1 after 56238 (0:12=56344,0:11=56285)
innodb.doublewrite '64k,innodb,strict_crc32' [ skipped ]  Extra checkpoint 1 after 55920 (0:10=56256,0:11=56299)
innodb.doublewrite '32k,innodb,strict_full_crc32' [ skipped ]  Extra checkpoint 1 after 54403 (0:10=56269,0:9=56226)
innodb.doublewrite '64k,innodb,strict_full_crc32' [ skipped ]  Extra checkpoint 1 after 55323 (0:10=56256,0:11=56299)
innodb.doublewrite '16k,innodb,strict_crc32' [ skipped ]  Extra checkpoint 1 after 55488 (0:10=56410,0:11=56453)
innodb.doublewrite '4k,innodb,strict_crc32' [ skipped ]  Extra checkpoint 1 after 74456 (0:12=74546,0:11=74503)
innodb.doublewrite '8k,innodb,strict_crc32' [ skipped ]  Extra checkpoint 1 after 62190 (0:14=62280,0:13=62237)
innodb.doublewrite '16k,innodb,strict_full_crc32' [ skipped ]  Extra checkpoint 1 after 56416 (0:12=56506,0:11=56463)
innodb.doublewrite '4k,innodb,strict_full_crc32' [ skipped ]  Extra checkpoint 1 after 74497 (0:14=74587,0:13=74544)
innodb.doublewrite '8k,innodb,strict_full_crc32' [ skipped ]  Extra checkpoint 1 after 60858 (0:12=62204,0:11=62161)

InnoDB should avoid usage of innodb_buf_flush_list_now variable. It triggers the
checkpoint very often and it leads to skip of this test case.



 Comments   
Comment by Thirunarayanan Balathandayuthapani [ 2023-11-14 ]

https://github.com/MariaDB/server/pull/2838

Comment by Marko Mäkelä [ 2023-11-14 ]

Thank you. It is great to have this test back. I asked for some clarification, because I do not understand what happens. It would be better to replace the sleep 1 with some wait_condition.inc, to make the test faster and more reliable.

Comment by Marko Mäkelä [ 2023-12-07 ]

I think that I found a way to execute the .ibd file specific part of the test in non-debug builds, by using FLUSH TABLES. But, my version of the test revealed some bugs in our recovery logic, which will have to be revised.

Generated at Thu Feb 08 10:29:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.