percona-xtrabackup wrong mysql socket path

[Janne Snabb]

[Impact]
Default socket path for MySQL switched from /var/run/mysqld/mysqld.sock to /tmp/mysqld.sock which is not the path that any of the MySQL family in Ubuntu actually listens on; workaround via configuration file but needs fixing.

[Test Case]
sudo apt install percona-xtrabackup mariadb-server
sudo mkdir -p /srv/backup
sudo xtrabackup --backup --target-dir=/srv/backup

Backup fails to connect to mysql with the error in the original bug report

[Regression Potential]
Limited; we missed this and two other compilation flag changes during the original update - the proposed updates re-sync the Ubuntu packaging with the upstream packaging in terms of compilation flags and value.

[Original Bug Report]
percona-xtrabackup was upgraded from 2.2.3-2.1build1.1 to 2.3.7-0ubuntu0.16.04.1.

It appears that MySQL default socket file path has changed in the new version.

After the update my backups started failing with the following:

170402 06:30:04 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
Failed to connect to MySQL server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).

Workaround:

Add the following in /root/.my.cnf or similar:

[client]
socket = /run/mysqld/mysqld.sock

Version details:

root@chmaa ~ # lsb_release -rd
Description: Ubuntu 16.04.2 LTS
Release: 16.04
root@chmaa ~ # apt-cache policy percona-xtrabackup
percona-xtrabackup:
  Installed: 2.3.7-0ubuntu0.16.04.1
  Candidate: 2.3.7-0ubuntu0.16.04.1
  Version table:
 *** 2.3.7-0ubuntu0.16.04.1 500
        500 http://de.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 Packages
        100 /var/lib/dpkg/status
     2.2.3-2.1build1 500
        500 http://de.archive.ubuntu.com/ubuntu xenial/universe amd64 Packages

[James Page (james-page)]

Hmm so this should be set correctly:

    cmake -DBUILD_CONFIG=xtrabackup_release -DCMAKE_INSTALL_PREFIX=/usr -DMYSQL_UNIX_ADDR=/var/run/mysqld/mysqld.sock \
      -DWITH_SSL=system -DINSTALL_MYSQLTESTDIR=/usr/share/percona-xtrabackup-test -DINSTALL_MANDIR=/usr/share/man .

Note use of MYSQL_UNIX_ADDR

[James Page (james-page)]

Comment in #1 was from upstream packaging - distro packaging lacks this.

Raising tasks for impacted releases.

[James Page (james-page)]

Testing packages will appear here:

  https://launchpad.net/~ci-train-ppa-service/+archive/ubuntu/2691

[James Page (james-page)]

Note that percona-xtrabackup does work with the default configuration files for percona-xtradb-cluster; switching test case to use mariadb-server which does exhibit this problem.

[James Page (james-page)]

Updated packages in the UNAPPROVED queue for xenial and yakkety, and going through proposed in zesty.

[Launchpad Janitor (janitor)]

This bug was fixed in the package percona-xtrabackup - 2.3.7-0ubuntu2

---------------
percona-xtrabackup (2.3.7-0ubuntu2) zesty; urgency=medium

  * Fix regression in default UNIX socket path for MySQL due to missing
    compilation flags (LP: #1678574).

 -- James Page <email address hidden> Tue, 04 Apr 2017 10:55:53 +0100

[Brian Murray (brian-murray)]

Hello Janne, or anyone else affected,

Accepted percona-xtrabackup into yakkety-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/percona-xtrabackup/2.3.7-0ubuntu0.16.10.2 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed.Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

[Brian Murray (brian-murray)]

Hello Janne, or anyone else affected,

Accepted percona-xtrabackup into xenial-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/percona-xtrabackup/2.3.7-0ubuntu0.16.04.2 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed.Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested, and change the tag from verification-needed to verification-done. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

[Janne Snabb (snabb)]

Thanks!

I verified that the bug is fixed in these versions:

ii percona-xtrabackup 2.3.7-0ubuntu0.16.10.2 amd64 Open source backup tool for InnoDB and XtraDB
ii percona-xtrabackup 2.3.7-0ubuntu0.16.04.2 amd64 Open source backup tool for InnoDB and XtraDB

[James Page (james-page)]

@snabb Thanks for the verification testing!

[Launchpad Janitor (janitor)]

This bug was fixed in the package percona-xtrabackup - 2.3.7-0ubuntu0.16.04.2

---------------
percona-xtrabackup (2.3.7-0ubuntu0.16.04.2) xenial; urgency=medium

  * Fix regression in default UNIX socket path for MySQL due to missing
    compilation flags (LP: #1678574).

 -- James Page <email address hidden> Tue, 04 Apr 2017 10:56:54 +0100

[Robie Basak (racb)]

The verification of the Stable Release Update for percona-xtrabackup has completed successfully and the package has now been released to -updates. Subsequently, the Ubuntu Stable Release Updates Team is being unsubscribed and will not receive messages about this bug report. In the event that you encounter a regression using the package from -updates please report a new bug using ubuntu-bug and tag the bug report regression-update so we can easily find any regressions.

[Launchpad Janitor (janitor)]

This bug was fixed in the package percona-xtrabackup - 2.3.7-0ubuntu0.16.10.2

---------------
percona-xtrabackup (2.3.7-0ubuntu0.16.10.2) yakkety; urgency=medium

  * Fix regression in default UNIX socket path for MySQL due to missing
    compilation flags (LP: #1678574).

 -- James Page <email address hidden> Tue, 04 Apr 2017 10:56:37 +0100