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

Bug #1509942 reported by Shahriyar Rzayev on 2015-10-26
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Status tracked in 2.4
2.3
Fix Released
High
Hrvoje Matijakovic
2.4
Fix Released
High
Hrvoje Matijakovic

Bug Description

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

Tags: doc Edit Tag help
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers