xtrabackup: Error: --defaults-file must be specified first on the command line

[Shahriyar Rzayev]

After upgrading to xtrabackup to 2.3.2 version i got an error with my script -> https://github.com/ShahriyarR/MySQL-AutoXtraBackup/

[root@node1 ~]# /opt/Python-3.3.2/bin/autoxtrabackup --backup
Warning: Using a password on the command line interface can be insecure.
Server is Up and running+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+OK
/usr/bin/mysql exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-++-OK
/usr/bin/mysqladmin exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
MySQL configuration file exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+OK
Xtrabackup/Innobackupex exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-OK
Main backup directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Full Backup directory exists.+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+OK
Increment directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-OK
Archive folder directory exists+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Creating Test User (test_backup)+-+-+-+-+-+-+-+-+-++-+-+-+-+-OK
Creating Test Database (bck)+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-OK
Database Already exists
Check status: STATUS+-+-+-+-+-+-+-+-+-++-+-+-+-+-+-+-+-+-+-+-OK
################################################################
Your full backup is timeout : Taking new Full Backup!- - - - - #
################################################################
Flushing Binary Logs
FULL BACKUP FAILED!
xtrabackup: Error: --defaults-file must be specified first on the command line

It turns out that now specifying --defaults-file option first is mandatory...

[root@node1 ~]# xtrabackup --version
xtrabackup version 2.3.2 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 306a2e0)

[root@node1 ~]# innobackupex --user=root --password=12345 --defaults-file=/etc/my.cnf --port=3306 --socket=/var/lib/mysql/mysql.sock /home/MySQL-AutoXtraBackup/backup_dir/full/
xtrabackup: Error: --defaults-file must be specified first on the command line

But with 2.2.12 it will work:

[root@node1 ~]# xtrabackup --version
xtrabackup version 2.2.12 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 8726828)

innobackupex --user=root --password=12345 --defaults-file=/etc/my.cnf --port=3306 --socket=/var/lib/mysql/mysql.sock /home/MySQL-AutoXtraBackup/backup_dir/full/

151026 09:41:45 innobackupex: Connection to database server closed
151026 09:41:45 innobackupex: completed OK!

For me, it is critical because now i need to rewrite script (suddenly). Maybe for some other people it is critical too, to fix their scripts, it will take time to realize that, cron jobs did not work after 'yum update' or something similar.

Also documentation should indicate this change for eg, while taking backups:

https://www.percona.com/doc/percona-xtrabackup/2.3/xtrabackup_bin/creating_a_backup.html

[Sergei Glushchenko (sergei.glushchenko)]

Need to add a note here https://www.percona.com/doc/percona-xtrabackup/2.3/innobackupex/innobackupex_option_reference.html#cmdoption-innobackupex--defaults-file

similar to we see here

https://www.percona.com/doc/percona-xtrabackup/2.3/xtrabackup_bin/xbk_option_reference.html#cmdoption-xtrabackup--defaults-file

[Hrvoje Matijakovic (hrvojem)]

Fixed here: https://github.com/percona/percona-xtrabackup/commit/5c8224a0204dffdcf8692fa44f52ab261dfd1a1c

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-442