Issues
- Tablespaces(.ibd) renamed between schemas may not copiedPXB-3293Resolved issue: PXB-3293
- Assertion failure: fil0fil.cc:2545:err == DB_SUCCESS found during incremental backup with lock-ddl=REDUCEDPXB-3245Resolved issue: PXB-3245Satya Bodapati
- Assertion failure: os0file.cc:3416:!exists while taking backups with lock-ddl=REDUCEDPXB-3241Resolved issue: PXB-3241Satya Bodapati
- XtraBackup prepare using export option , mysqld got signal 11PXB-2843Resolved issue: PXB-2843
- MySQL8.0.28PXB-2720Resolved issue: PXB-2720
- Implement ASAN jobPXB-2328Resolved issue: PXB-2328Marcelo Altmann
- Validate Data Encryption FeaturesPXB-2172Resolved issue: PXB-2172mohit.joshi
- Test PXB 8.0.9 with released upstream MySQL 8.0.19PXB-2089Resolved issue: PXB-2089Manish Chawla
- Debian 10 Buster - GA Testing PXB 8.0PXB-1897Resolved issue: PXB-1897Manish Chawla
- Debian 10 Buster - GA Testing PXB 2.4PXB-1896Resolved issue: PXB-1896Manish Chawla
10 of 10
Tablespaces(.ibd) renamed between schemas may not copied
Won't Do
General
Escalation
General
Escalation
Description
Environment
None
Created May 13, 2024 at 3:27 AM
Updated June 6, 2024 at 10:00 AM
Resolved June 6, 2024 at 10:00 AM
Activity
Satya BodapatiJune 6, 2024 at 9:59 AM
With lock-ddl=OFF, it is the user's responsibility to avoid DDLs. This is why we recommend lock-ddl=ON and default is ON.
We have plans to reduce the total lock duration. Stay tuned!
PerconaSQLMay 13, 2024 at 6:28 AM
How to repeat:
Create 2 databases, and create tables in one database;
Begin backup, rename tables from this database to other, and rename tables back;
Prepare backup, and check if some .ibd files are not copied.
Xtrabackup version affected:
2.4.29
8.0.35
Problem:
If
--lock-ddlis disabled which is default,before load tablespace and open ibds operations from schema 1,
rename tables from schema 1 to schema 2, and rename tables back from schema 2 to schema 1 before load from schema 2,
backup are not inconsistent because some
.ibds are not copied.