Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
Description
MySQL 5.7.41 includes the following InnoDB changes:
Not applicable to MariaDB Server
Bug #33822493 : pb2 weekly-5.7 test failures due to InnoDB: Assertion failure
This race condition was fixed in MDEV-12024 in February 2017.
Applicable to MariaDB Server
Bug#34400586 Backport MySQL contribution id: 31497 to 5.7
The commit message appears to refer to this change in MySQL 8.0.
This aims to prevent a last-minute dirtying of the buffer pool due to a change buffer merge. In MariaDB Server 10.5, not only was the buf_flush_page_cleaner() thread refactored, but also MDEV-19514 should prevent any change buffer merge from occurring at this point.
I believe that the Oracle internal bug report was similar to MDEV-20481, which turns out to have been fixed by MDEV-24448 and MDEV-24449.
All that said, something like this fix should be applicable to MariaDB 10.3 and 10.4, to prevent a very rare condition where read-ahead of a secondary index leaf page had been submitted during or right before shutdown. As always (see MDEV-30009), it is very hard to reproduce any bugs in the change buffer.
Attachments
Issue Links
- blocks
-
MDEV-31087 Merge new release of InnoDB 5.7.42 to 10.3
- Closed
- is blocked by
-
MDEV-29766 Merge new release of InnoDB 5.7.40 to 10.3
- Closed
- relates to
-
MDEV-12024 InnoDB startup fails to wait for recv_writer_thread to finish
- Closed
-
MDEV-24449 Corruption of system tablespace or last recovered page
- Closed