[MDEV-32151] innodb_immediate_scrub_data_uncompressed=ON may fail to scrub temporary tablespace pages Created: 2023-09-12  Updated: 2023-10-21  Resolved: 2023-09-18

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.1, 11.2
Fix Version/s: 10.6.16, 10.10.7, 10.11.6, 11.1.3, 11.2.2

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

Issue Links:
Blocks
blocks MDEV-28699 Shrink temporary tablespaces without ... Closed
Relates
relates to MDEV-8139 Fix scrubbing Closed

 Description   

When a page in the temporary tablespace is freed (for example, due to DROP TEMPORARY TABLE), mtr_t::free() fails to mark the page status as buf_page_t::FREED. Due to this, InnoDB may fail to scrub the freed page (if innodb_immediate_scrub_data_uncompressed=ON) when buf_flush_space() is being invoked on the temporary tablespace.



 Comments   
Comment by Marko Mäkelä [ 2023-09-12 ]

I do not think that this bug has much practical impact, because due to MDEV-12227 any writes to the temporary tablespace should be rather rare, and the impact of scrubbing might not be observable.

However, this bug blocks the feature MDEV-28699, which allows better "scrubbing" by shrinking the temporary tablespace.

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