[MDEV-32151] innodb_immediate_scrub_data_uncompressed=ON may fail to scrub temporary tablespace pages - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.1(EOL), 11.2(EOL)
Fix Version/s: 10.6.16, 10.10.7, 10.11.6, 11.1.3, 11.2.2
Component/s: Storage Engine - InnoDB
Labels:
None

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.

Attachments

Issue Links

blocks

MDEV-28699 Shrink temporary tablespaces without restart

Closed

relates to

MDEV-8139 Fix scrubbing

Closed

Activity

Marko Mäkelä added a comment - 2023-09-12 11:34

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.

Marko Mäkelä added a comment - 2023-09-12 11:34 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.

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Thirunarayanan Balathandayuthapani

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-09-12 11:18

Updated:: 2023-10-21 19:22

Resolved:: 2023-09-18 14:08

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server