[MDEV-39647] Deleted Virtual secondary records might never get purged and cause table bloating - Jira

XML

Word

Printable

Details

Type: Bug
Status: In Progress (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6(EOL)
Fix Version/s: 10.11, 11.4, 11.8
Component/s: Storage Engine - InnoDB
Labels:
None

Bug Category:
Related to performance
Sprint:
Q4/2026 Server Maintenance

Description

The purging of virtual secondary index record might get skipped, and can cause table bloating.
Along with CHECK TABLE ... EXTENDED giving us warning.

Attachments

Issue Links

relates to

MDEV-22718 trx_purge_truncate_history(): head.trx_no() >= purge_sys.low_limit_no()

Stalled

MDEV-37445 index corruption with virtual columns

Closed

Activity

People

Assignee:: Mohammad Tafzeel Shams

Reporter:: Mohammad Tafzeel Shams

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2026-05-18 08:34

Updated:: 4 days ago 13:53

Time Tracking

Estimated:

5d

Remaining:

3d 3h

Logged:

1d 5h

Git Integration

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