Applying incremental backup using xtrabackup 2.0.3 fails when innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend is set in [mysqld]
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Critical
|
Sergei Glushchenko | ||
2.0 |
Fix Released
|
Critical
|
Sergei Glushchenko | ||
2.1 |
Fix Released
|
Critical
|
Sergei Glushchenko |
Bug Description
If in your [mysqld] section of my.cnf, this is set:
innodb_
innobackupex cannot apply incremental backup:
innobackupex --apply-log --redo-only --incremental-
00
121005 21:31:47 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-
xtrabackup_55 version 2.0.3 for Percona Server 5.5.16 Linux (x86_64) (revision id: 470)
incremental backup from 416883306 is enabled.
xtrabackup: cd to /backups/
xtrabackup: This target seems to be already prepared.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
121005 21:31:47 InnoDB: Using Linux native AIO
InnoDB: Error: data file ./ibdata1 is of a different size
InnoDB: 128000 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 2000 pages!
xtrabackup: Could not open or create data files.
xtrabackup: If you tried to add new data files, and it failed here,
xtrabackup: you should now edit innodb_
xtrabackup: to what it was, and remove the new ibdata files InnoDB created
xtrabackup: in this failed attempt. InnoDB only wrote those files full of
xtrabackup: zeros, but did not yet use them in any way. But be careful: do not
xtrabackup: remove old data files which contain your precious data!
xtrabackup: error: xb_data_
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/
Workaround:
Install xtrabackup-2.0.1 to apply incremental backup
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 214 lines (+141/-37)2 files modifiedsrc/xtrabackup.c (+44/-37)
test/t/bug1062684.sh (+97/-0)
- Alexey Kopytov (community): Approve
-
Diff: 235 lines (+147/-37)4 files modifiedsrc/innodb_int.c (+39/-0)
src/innodb_int.h (+7/-0)
src/xtrabackup.c (+4/-37)
test/t/bug1062684.sh (+97/-0)
This is a regression in 2.0.2 from the fix for bug #932623.
Verified with the following changes to ib_incremental.sh:
--- t/ib_incremental.sh 2012-08-20 13:07:20.000000000 +0400
+++ t/bug1062684.sh 2012-10-09 16:46:43.000000000 +0400
@@ -1,8 +1,11 @@
. inc/common.sh
-start_server --innodb_ file_per_ table file_per_ table --innodb- data-file- path="ibdata1: 10M;ibdata2: 5M:autoextend" --innodb_ log_file_ size=1048576
+start_server --innodb_
load_dbase_schema incremental_sample
+echo "innodb- data-file- path=ibdata1: 10M;ibdata2: 5M:autoextend" >>$topdir/my.cnf log_file_ size=1048576" >> $topdir/my.cnf
+echo "innodb_
+
# Adding initial rows
vlog "Adding initial rows to database..."
numrow=100