** Description changed: - percona-xtrabackup was upgraded from 2.2.3-2.1build1.1 to - 2.3.7-0ubuntu0.16.04.1. + [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 + + [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 + 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
