Partial backups do not work with partitioned tables

Reported by Valentine Gostev on 2011-02-01
40
This bug affects 7 people
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.

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 :

test cases are available in linked merge proposal.

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

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

Vadim Tkachenko (vadim-tk) wrote :

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

Stewart Smith (stewart) on 2011-05-20
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 :

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

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

Stewart Smith (stewart) wrote :

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

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

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.

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

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

Duplicates of this bug

Other bug subscribers