compact backup: Interruption during --rebuild-indexes will make backup invalid

Bug #1154495 reported by Alexey Stroganov
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Triaged
Medium
Unassigned
2.1
Triaged
Medium
Unassigned
2.2
Triaged
Medium
Unassigned
2.3
Triaged
Medium
Unassigned

Bug Description

- I create valid backup of sysbench database with --compact option
> innobackupex --ibbackup=./xtrabackup_55 --compact <...>
...
130313 01:56:37 innobackupex: completed OK!

- I start rebuild indexes
> innobackupex --ibbackup=./xtrabackup_55 --apply-log --rebuild-indexes <...>
....
Starting to expand compacted .ibd files.
130313 1:56:55 InnoDB: Warning: allocated tablespace 13, old maximum was 9
Expanding ./sbtest4t1M/sbtest4.ibd
Expanding ./sbtest4t1M/sbtest3.ibd
Expanding ./sbtest4t1M/sbtest1.ibd
...

- I press Ctrl-C
Preparation of backup is interrupted

- I try to continue rebuild indexes but it failed
> innobackupex --ibbackup=./xtrabackup_55 --apply-log --rebuild-indexes <...>
...
Starting to expand compacted .ibd files.
130313 1:57:06 InnoDB: Warning: allocated tablespace 13, old maximum was 9
Not expanding ./sbtest4t1M/sbtest4.ibd
innobackupex: Error:
innobackupex: ibbackup failed at innobackupex line 366.

ls -l <datadir>/sbtest4t1M/*
-rw-rw---- 1 root root 65 Mar 12 06:51 db.opt
-rw-rw---- 1 root root 8632 Mar 12 06:51 sbtest1.frm
-rw-r----- 1 root root 231571456 Mar 13 01:56 sbtest1.ibd
-rw-r----- 1 root root 184 Mar 13 01:56 sbtest1.ibd.pmap
-rw-r----- 1 root root 80740352 Mar 13 01:56 sbtest1.ibd.tmp
-rw-rw---- 1 root root 8632 Mar 12 06:52 sbtest2.frm
-rw-r----- 1 root root 231653376 Mar 13 01:56 sbtest2.ibd
-rw-r----- 1 root root 184 Mar 13 01:56 sbtest2.ibd.pmap
-rw-rw---- 1 root root 8632 Mar 12 06:52 sbtest3.frm
-rw-r----- 1 root root 255852544 Mar 13 01:56 sbtest3.ibd
-rw-rw---- 1 root root 8632 Mar 12 06:52 sbtest4.frm
-rw-r----- 1 root root 255852544 Mar 13 01:56 sbtest4.ibd

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

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

Other bug subscribers

Remote bug watches

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