[MDEV-18128] Simplify .ibd file creation - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.27, 10.3.18, 10.4.8
Component/s: Storage Engine - InnoDB
Labels:
- backup
- encryption

Description

When InnoDB creates an .ibd file, it first writes a dummy page 0 with no information about encryption. This may prevent Mariabackup 10.2.20 or 10.2.21 from copying encrypted data files that were craeted shortly before backup started.

Maybe we should create a 0-byte .ibd file first, and then let page flushing write the first pages? Alternatively, preallocate a zero-filled file and then let page flushing do its job.

A valid page 0 must be written to the created files before writing any other pages. Otherwise, crash recovery cannot work.

Attachments

Issue Links

is duplicated by

MDEV-19348 MariaBackup prepare fails with InnoDB: Database page corruption on disk or a failed file read

Closed

relates to

MDEV-18129 Backup fails for encrypted tables: mariabackup: Database page corruption detected at page 1

Closed

MDEV-18415 mariabackup.mdev-14447 test case fails with Table 'test.t' doesn't exist in engine

Closed

MDEV-12112 corruption in encrypted table may be overlooked

Closed

MDEV-14398 When innodb_encryption_rotate_key_age=0 is set, server won't encrypt tablespaces

Closed

MDEV-15671 innodb.recovery_shutdown failed in buildbot with Checksum mismatch in datafile

Closed

(1 relates to)

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Marko Mäkelä

Votes:: 1 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2019-01-03 14:18

Updated:: 2024-07-07 23:23

Resolved:: 2019-08-16 12:43

Time Tracking

Estimated:

Remaining:

3d 1.5h

Logged:

1d 6.5h

Git Integration

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