xtrabackup ignores defaults-file in apply-log-only prepare mode
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Low
|
Alexey Kopytov | ||
2.0 |
Fix Released
|
Low
|
Alexey Kopytov |
Bug Description
When running a command like the following it seems the contents of the backup-my.cnf is ignored with regards to some innodb params, specifically the central tablespace files and their sizes.
eg.
root@mslvlxbp01
# This MySQL options file was generated by innobackupex-1.5.1.
# The MySQL server
[mysqld]
datadir=
innodb_
innodb_
innodb_
innodb_
innodb_
root@mslvlxbp01
xtrabackup_51 Ver undefined Rev undefined for 5.1.56 pc-solaris2.11 (i386)
xtrabackup: cd to ./
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=20582907904, start_lsn=(1927 3164130075)
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: The InnoDB memory heap is disabled
Note in the above that innodb_
Now giving these parameters directly to xtrabackup binary on the cmd line you can see it regurgitates them correctly:
root@mslvlxbp01
xtrabackup_51 Ver undefined Rev undefined for 5.1.56 pc-solaris2.11 (i386)
xtrabackup: cd to ./
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=20582907904, start_lsn=(1927 3164130075)
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: The InnoDB memory heap is disabled
This can be a fairly big issue, because not giving xtrabackup the correct innodb_
Related branches
- Stewart Smith (community): Approve
-
Diff: 212 lines (+98/-17)5 files modifiedtest/inc/common.sh (+20/-3)
test/run.sh (+44/-9)
test/t/xb_defaults_file.sh (+25/-0)
test/t/xb_stats.sh (+2/-5)
xtrabackup.c (+7/-0)
Changed in percona-xtrabackup: | |
status: | New → Triaged |
importance: | Undecided → High |
Changed in percona-xtrabackup: | |
status: | Triaged → Fix Committed |
Changed in percona-xtrabackup: | |
importance: | High → Low |
Changed in percona-xtrabackup: | |
milestone: | none → 1.7.0beta1 |
It's a documented limitation of --defaults-file: http:// dev.mysql. com/doc/ refman/ 5.5/en/ option- files.html# option- file-options
"
Most MySQL programs that support option files handle the following options. They affect option-file handling, so they must be given on the command line and not in an option file. To work properly, each of these options must immediately follow the command name
"
So --defaults-file must be the first option on the command line in order to work correctly.