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.
** Description changed: [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] - Install mysql-server and percona-xtrabackup - Attempt to perform a backup using the default settings - Backup fails to connect to mysql with the error in the original bug report + sudo apt install percona-xtrabackup percona-xtradb-cluster-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 ** Description changed: [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 percona-xtradb-cluster-server + 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1678574 Title: percona-xtrabackup wrong mysql socket path To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/percona-xtrabackup/+bug/1678574/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
