[MDEV-32028] InnoDB scrubbing doesn't write zero while freeing the extent - Jira

XML

Word

Printable

Details

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

Description

InnoDB fails to mark the page status as FREED during freeing of an extent of a segment.
This behaviour affects scrubbing and doesn't write all zeroes in file even though
pages are freed.

        fsp_free_extent(space, page, mtr);

        for (uint32_t i = 0; i < FSP_EXTENT_SIZE; i++) {

                if (!xdes_is_free(descr, i)) {

                        buf_page_free(space, first_page_in_extent + i, mtr,

                                      __FILE__, __LINE__);

Above fsp_free_extent() calls xdes_init() and reinitialize all bitmap of
the extent descriptor page. After that, we rely on bitmap of extent descriptor
page to call buf_page_free()

Attachments

Issue Links

blocks

MDEV-28699 Shrink temporary tablespaces without restart

Closed

relates to

MDEV-32163 Crash recovery fails after DROP TABLE in system tablespace

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Thirunarayanan Balathandayuthapani

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-08-28 12:01

Updated:: 2023-10-21 19:22

Resolved:: 2023-08-29 04:57

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

6.5h

Git Integration

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