Percona XtraBackup moved to https://jira.percona.com/projects/PXB

Partial backups do not work with partitioned tables

Bug #711166 reported by Valentine Gostev
40
This bug affects 7 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
High
Sergei Glushchenko
Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.1-pre-initial-release
1.6
Won't Fix
High
Sergei Glushchenko
2.0
Fix Released
High
Sergei Glushchenko
Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.0.5
2.1
Fix Released
High
Sergei Glushchenko
Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.1-pre-initial-release

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.

See original description

Related branches

lp:~sergei.glushchenko/percona-xtrabackup/bug711166_part-1.6
Alexey Kopytov (community): Needs Resubmitting
Diff: 194 lines (+163/-0)
4 files modified
innobackupex (+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
Diff: 756 lines (+482/-154)
9 files modified
innobackupex (+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)
lp:~sergei.glushchenko/percona-xtrabackup/xb20-partial
Alexey Kopytov (community): Approve
Laurynas Biveinis: Pending requested
Diff: 1000 lines (+586/-252)
9 files modified
innobackupex (+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)
lp:~sergei.glushchenko/percona-xtrabackup/bug711166_part-1.9
lp:~sergei.glushchenko/percona-xtrabackup/xb21-partial
Stewart Smith (community): Needs Fixing
Alexey Kopytov (community): Approve
Diff: 905 lines (+537/-201)
9 files modified
innobackupex (+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)
Valentine Gostev (longbow)
Changed in percona-xtrabackup:
milestone: none → 1.6
importance: Undecided → High
description: updated
Changed in percona-xtrabackup:
assignee: nobody → Valentine Gostev (core-longbow)
Valentine Gostev (longbow)
description: updated
Valentine Gostev (longbow)
Changed in percona-xtrabackup:
milestone: 1.6 → none
Revision history for this message
Valentine Gostev (longbow) wrote :

test cases are available in linked merge proposal.

Changed in percona-xtrabackup:
status: New → Triaged
assignee: Valentine Gostev (core-longbow) → Vadim Tkachenko (vadim-tk)
Revision history for this message
Stewart Smith (stewart) wrote :

Vadim, is this on your radar or should I reassign?

Revision history for this message
Vadim Tkachenko (vadim-tk) wrote :

Assigned to "me" means I need to find someone to fix it.
Please re-assign :)

Stewart Smith (stewart)
Changed in percona-xtrabackup:
assignee: Vadim Tkachenko (vadim-tk) → nobody
Alexey Kopytov (akopytov)
summary: - Implement full support for backups of partitioned tables
+ Partial backups do not work with partitioned tables
Alexey Kopytov (akopytov)
description: updated
Revision history for this message
Sergei Glushchenko (sergei.glushchenko) wrote :

--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.

Revision history for this message
Alexey Kopytov (akopytov) wrote :

It's a high priority bug, we should fix it in 1.6.

Revision history for this message
Virginia Banh (virginia-banh) wrote :

Hi Support Admin,

I would like to know if this bug has been fixed in Percona XtraBackup 2.0.5. Please advise.

Regards,
Virginia

Revision history for this message
Stewart Smith (stewart) wrote :

Yes, the fix has been included in the Percona XtraBackup 2.0.5 release

Revision history for this message
Virginia Banh (virginia-banh) wrote :

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

Revision history for this message
Alexey Kopytov (akopytov) wrote :

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.

Revision history for this message
Virginia Banh (virginia-banh) wrote :

Hi Alex,

Thanks for the update and helped me to create bug #1179388. I will try it again on version 5.6.

Regards,
Virginia

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-296

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.