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

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5(EOL), 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

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

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.5d

Git Integration

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