← Back to team overview

group.of.nepali.translators team mailing list archive

[Bug 1678574] Re: percona-xtrabackup wrong mysql socket path

 

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 <james.page@xxxxxxxxxx>  Tue, 04 Apr 2017 10:56:54 +0100

** Changed in: percona-xtrabackup (Ubuntu Xenial)
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of नेपाली
भाषा समायोजकहरुको समूह, which is subscribed to Xenial.
Matching subscriptions: Ubuntu 16.04 Bugs
https://bugs.launchpad.net/bugs/1678574

Title:
  percona-xtrabackup wrong mysql socket path

Status in percona-xtrabackup package in Ubuntu:
  Fix Released
Status in percona-xtrabackup source package in Xenial:
  Fix Released
Status in percona-xtrabackup source package in Yakkety:
  Fix Released
Status in percona-xtrabackup source package in Zesty:
  Fix Released

Bug description:
  [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

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/percona-xtrabackup/+bug/1678574/+subscriptions