Public bug reported:

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

** Affects: percona-xtrabackup (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: regression-update

** Tags added: regression-update

-- 
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

Reply via email to