Incremental backup fail with innodb_undo_tablespaces > 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Sergei Glushchenko | ||
2.1 |
Fix Released
|
High
|
Sergei Glushchenko | ||
2.2 |
Fix Released
|
High
|
Sergei Glushchenko | ||
2.3 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Package list:
percona-
Percona-
Percona-
Percona-
percona-
perl-DBD-
Incremental backups with innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
140829 19:06:06 innobackupex: Starting ibbackup with command: xtrabackup --defaults-
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
incremental backup from 366196955 is enabled.
xtrabackup: cd to /root/backup/full
xtrabackup: This target seems to be already prepared.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
InnoDB: Unable to open undo tablespace './undo001'.
xtrabackup: error: xb_data_
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/
I'm attaching the full log of the backup and the incremental process. After remove this option (innodb_
Regards,
Martin
@MartinArrietaC
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 46 lines (+30/-1)2 files modifiedinnobackupex.pl (+1/-1)
test/t/bug1363234.sh (+29/-0)
- Alexey Kopytov (community): Approve
-
Diff: 46 lines (+30/-1)2 files modifiedstorage/innobase/xtrabackup/innobackupex.pl (+1/-1)
storage/innobase/xtrabackup/test/t/bug1363234.sh (+29/-0)
- Alexey Kopytov (community): Approve
-
Diff: 46 lines (+30/-1)2 files modifiedstorage/innobase/xtrabackup/innobackupex.pl (+1/-1)
storage/innobase/xtrabackup/test/t/bug1363234.sh (+29/-0)
Verified with Xtrabackup 2.2.3 on PS 5.6.20
140902 15:10:16 innobackupex: Starting ibbackup with command: xtrabackup --defaults- file="/ home/nilnandan/ backup/ 2014-09- 02_15-02- 37/backup- my.cnf" --defaults- group=" mysqld" --prepare --target- dir=/home/ nilnandan/ backup/ 2014-09- 02_15-02- 37 --incremental- dir=/home/ nilnandan/ backup/ 2014-09- 02_15-02- 37/incremental/ 2014-09- 02_15-09- 54 --tmpdir=/tmp
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: ) /backup/ 2014-09- 02_15-02- 37 data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = /home/nilnandan /backup/ 2014-09- 02_15-02- 37/incremental/ 2014-09- 02_15-09- 54 log_files_ in_group = 1 log_file_ size = 2097152 files_init( ) failed with error code 11 innobackupex line 2610. Dell-XPS: ~#
incremental backup from 1482746 is enabled.
xtrabackup: cd to /home/nilnandan
xtrabackup: This target seems to be already prepared.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1782305)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
InnoDB: Unable to open undo tablespace './undo001'.
xtrabackup: error: xb_data_
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/
root@nilnandan-