[MDEV-32150] InnoDB reports corruption on 32-bit platforms with ibd files sizes > 4GB - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.22, 10.11.5, 11.2.1
Fix Version/s: 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2
Component/s: Storage Engine - InnoDB
Labels:
- regression
Environment:
Linux 32-bit, reproducible on Debian 12 armhf and x86 releases.

Description

Mariadb reports a space/page mismatch and index corruption on 32-bit platforms when loading large InnoDB files. This started in the 10.5 series and is reproducible on each version I have tested since that series.

I tracked the issue down to a 32-bit truncation when the file offset is calculated in storage/innobase/buf/buf0rea.cc.

Casting this to os_offset_t solves the issue (patch attached).

On 64-bit platforms this calculation would naturally occur in a 64-bit register so it is not reproducible there.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

fix-innodb-32-bit-offset-truncation.patch
2023-09-12 08:11
0.6 kB
Danny Wood

Issue Links

is caused by

MDEV-23855 InnoDB log checkpointing causes regression for write-heavy OLTP

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Danny Wood

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-09-12 08:15

Updated:: 2023-09-12 17:28

Resolved:: 2023-09-12 13:19

Git Integration

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