defaults-file not being handled properly.

[James Dooley]

Upgrading to percona-xtrabackup.2.3.2-1.el5 my backups started reporting the following error:

21-Oct 01:28 bacula-fd JobId 1388: ClientRunBeforeJob: run command "innobackupex --defaults-file /root/.my.cnf --no-timestamp --no-version-check /backup/mysql"
21-Oct 01:28 bacula-fd JobId 1388: ClientRunBeforeJob: xtrabackup: Error: --defaults-file must be specified first on the command line

Downgrading to 2.2.12-1 fixes this issue.

[Sergei Glushchenko (sergei.glushchenko)]

Please check if "--defaults-file=/root/.my.cnf" syntax works for you

[Sergei Glushchenko (sergei.glushchenko)]

You might also have defaults-file specified in /root/.my.cnf or elsewhere.

[James Dooley (jdooley-9)]

Changing to defaults-file=/root/.my.cnf does work.

But it looks like it is requiring the defaults file to now have the datadir variable set.

Error: option 'datadir' has different values:
  '.' in defaults file
  '/var/lib/mysql/' in SHOW VARIABLES

After making these changes I was able to run a successful backup.

Side note, the new version forces secure_auth client side. This will cause issues with any lingering short passwords.

[Sergei Glushchenko (sergei.glushchenko)]

We will add a note that syntax described here: http://dev.mysql.com/doc/refman/5.6/en/command-line-options.html is enforced in new version. As for datadir, could you please fail separate bug report regarding it. And another one to support '--skip-secure-auth'.
Thanks!

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/238748
Committed: https://git.openstack.org/cgit/openstack/openstack-ansible/commit/?id=113597a7cf16c9ae791cc412b2e1a07188b28fd5
Submitter: Jenkins
Branch: master

commit 113597a7cf16c9ae791cc412b2e1a07188b28fd5
Author: Kevin Carter <email address hidden>
Date: Thu Oct 22 21:12:34 2015 -0500

    Pinned percona-xtrabackup to ensure stability

    This change makes it so that the xtrabackup plugin is pinned
    to a specific version via downloading the deb.

    This reinstates the galera affinity values for testing so that
    we're not skipping potentially broken code paths.

    Related-Bug: #1508411
    Related-Bug: #1508448
    Related-Bug: #1508450
    Change-Id: I288d6d9871eb9dfe0ecc547e50639078afdff79d
    Signed-off-by: Kevin Carter <email address hidden>

[Shahriyar Rzayev (rzayev-sehriyar)]

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