compact backup: Interruption during --rebuild-indexes will make backup invalid
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=
...
130313 01:56:37 innobackupex: completed OK!
- I start rebuild indexes
> innobackupex --ibbackup=
....
Starting to expand compacted .ibd files.
130313 1:56:55 InnoDB: Warning: allocated tablespace 13, old maximum was 9
Expanding ./sbtest4t1M/
Expanding ./sbtest4t1M/
Expanding ./sbtest4t1M/
...
- I press Ctrl-C
Preparation of backup is interrupted
- I try to continue rebuild indexes but it failed
> innobackupex --ibbackup=
...
Starting to expand compacted .ibd files.
130313 1:57:06 InnoDB: Warning: allocated tablespace 13, old maximum was 9
Not expanding ./sbtest4t1M/
innobackupex: Error:
innobackupex: ibbackup failed at innobackupex line 366.
ls -l <datadir>
-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
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PXB-620