Partial backups do not work with partitioned tables
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| | Percona XtraBackup |
High
|
Sergei Glushchenko | ||
| | 1.6 |
High
|
Sergei Glushchenko | ||
| | 2.0 |
High
|
Sergei Glushchenko | ||
| | 2.1 |
High
|
Sergei Glushchenko | ||
Bug Description
Partitioned tables are not correctly handled by the --databases and --tables-file options of innobackupex, and by the --tables option of xtrabackup. We should fix those options so that partitions are actually backed up when a partitioned table is passed as an argument to those options.
We should also make sure that partitions created with DATA DIRECTORY/INDEX DIRECTORY are backed up and restored correctly.
Related branches
- Alexey Kopytov (community): Resubmit on 2012-02-01
-
Diff: 194 lines (+163/-0)4 files modifiedinnobackupex (+2/-0)
test/t/bug711166-innodb.sh (+77/-0)
test/t/bug711166-myisam.sh (+79/-0)
xtrabackup.c (+5/-0)
- Alexey Kopytov (community): Needs Fixing on 2012-02-17
-
Diff: 756 lines (+482/-154)9 files modifiedinnobackupex (+27/-11)
test/inc/ib_part.sh (+76/-0)
test/t/ib_part_databases.sh (+42/-0)
test/t/ib_part_include.sh (+51/-0)
test/t/ib_part_include_stream.sh (+42/-0)
test/t/ib_part_tf_innodb.sh (+49/-0)
test/t/ib_part_tf_innodb_stream.sh (+43/-0)
test/t/ib_part_tf_myisam.sh (+42/-0)
xtrabackup.c (+110/-143)
- Stewart Smith (community): Needs Fixing on 2013-01-02
- Alexey Kopytov (community): Approve on 2012-12-20
-
Diff: 905 lines (+537/-201)9 files modifiedinnobackupex (+23/-6)
src/xtrabackup.c (+172/-195)
test/inc/ib_part.sh (+92/-0)
test/t/ib_part_databases.sh (+39/-0)
test/t/ib_part_include.sh (+47/-0)
test/t/ib_part_include_stream.sh (+39/-0)
test/t/ib_part_tf_innodb.sh (+46/-0)
test/t/ib_part_tf_innodb_stream.sh (+40/-0)
test/t/ib_part_tf_myisam.sh (+39/-0)
- Alexey Kopytov (community): Approve on 2012-12-20
- Laurynas Biveinis: Pending requested 2012-12-07
-
Diff: 1000 lines (+586/-252)9 files modifiedinnobackupex (+25/-10)
src/xtrabackup.c (+219/-242)
test/inc/ib_part.sh (+92/-0)
test/t/ib_part_databases.sh (+39/-0)
test/t/ib_part_include.sh (+47/-0)
test/t/ib_part_include_stream.sh (+39/-0)
test/t/ib_part_tf_innodb.sh (+46/-0)
test/t/ib_part_tf_innodb_stream.sh (+40/-0)
test/t/ib_part_tf_myisam.sh (+39/-0)
| Changed in percona-xtrabackup: | |
| milestone: | none → 1.6 |
| importance: | Undecided → High |
| description: | updated |
| Changed in percona-xtrabackup: | |
| assignee: | nobody → Valentine Gostev (core-longbow) |
| description: | updated |
| Changed in percona-xtrabackup: | |
| milestone: | 1.6 → none |
| Valentine Gostev (longbow) wrote : | #1 |
| Changed in percona-xtrabackup: | |
| status: | New → Triaged |
| assignee: | Valentine Gostev (core-longbow) → Vadim Tkachenko (vadim-tk) |
| Stewart Smith (stewart) wrote : | #2 |
Vadim, is this on your radar or should I reassign?
| Vadim Tkachenko (vadim-tk) wrote : | #3 |
Assigned to "me" means I need to find someone to fix it.
Please re-assign :)
| Changed in percona-xtrabackup: | |
| assignee: | Vadim Tkachenko (vadim-tk) → nobody |
| summary: |
- Implement full support for backups of partitioned tables + Partial backups do not work with partitioned tables |
| description: | updated |
--tables-file and --tables options of xtrabackup make sense not only when backup taken, but also when analyze InnoDB data files with stats mode. This mode should also be checked and fixed.
| Alexey Kopytov (akopytov) wrote : | #5 |
It's a high priority bug, we should fix it in 1.6.
| Virginia Banh (virginia-banh) wrote : | #6 |
Hi Support Admin,
I would like to know if this bug has been fixed in Percona XtraBackup 2.0.5. Please advise.
Regards,
Virginia
| Stewart Smith (stewart) wrote : | #7 |
Yes, the fix has been included in the Percona XtraBackup 2.0.5 release
| Virginia Banh (virginia-banh) wrote : | #8 |
Hi Stewart,
I am able to create a backup and prepare a partition table on Xtrabackup 2.0.7-552.rhel6, and I am encountering issue to restore the partition table. It only works for individual partition table but not the entire table.
Please advise.
Regards,
Virginia
| Alexey Kopytov (akopytov) wrote : | #9 |
Virginia,
With server versions up to 5.5 it is only possible to import partitions as independent tables, simply because there is no server support for importing partitions of existing partitioned tables.
Though with MySQL / Percona Server 5.6 it is possible via ALTER TABLE ... EXCHANGE PARTITION. I have created bug #1179388 to document this procedure it in the XtraBackup manual.
| Virginia Banh (virginia-banh) wrote : | #10 |
Hi Alex,
Thanks for the update and helped me to create bug #1179388. I will try it again on version 5.6.
Regards,
Virginia
test cases are available in linked merge proposal.