Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Encrypted partitioned tables are not restored

Description

Initialize and start PS8.0.29 server with encryption options

Run pstress with options:

Take full backup

Take 18 incremental backups, example command for first incremental backup

Prepare full backup

Prepare all incremental backups 

Stop mysql and move the data dir to another location

Restore full backup

Start mysql and check the data. The partitioned tables tt_8_p, tt_9_p, tt_10_p are not restored.

Logs attached as partitioned_tables.tar.gz
PXB compiled from https://github.com/altmannmarcelo/percona-xtrabackup/commits/PXB-2866-8.0
PXB version:

Environment

None

Attachments

1

Smart Checklist

Activity

Satya Bodapati October 27, 2022 at 8:48 AM

found this bug once again after the fix. So we are keeping this open. But reproducibility is low

Satya Bodapati October 25, 2022 at 10:42 AM

This issue is caused by improper parsing of redo log records of 8.0.29 server.

The catchup phase should find the encryption information, without that, we do not load tablesapce and the encrypted tablesapce is not copied (as delta).

Prepare will delete the .ibd if there is no .delta file

 

Fixed in the latest version of branch

Details

Assignee

Reporter

Regression Issue

Yes

Found by Automation

Yes

Time tracking

5h logged

Affects versions

Priority

Smart Checklist

Created October 14, 2022 at 1:04 PM
Updated March 6, 2024 at 6:18 PM