group.of.nepali.translators team mailing list archive

[Eric Desrochers <eric.desrochers@xxxxxxxxxxxxx>]

** Also affects: percona-xtradb-cluster-5.6 (Ubuntu Artful)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.7 (Ubuntu Artful)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.6 (Ubuntu Bionic)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.7 (Ubuntu Bionic)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.6 (Ubuntu Cosmic)
   Importance: Medium
       Status: Triaged

** Also affects: percona-xtradb-cluster-5.7 (Ubuntu Cosmic)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.6 (Ubuntu Xenial)
   Importance: Undecided
       Status: New

** Also affects: percona-xtradb-cluster-5.7 (Ubuntu Xenial)
   Importance: Undecided
       Status: New

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

Title:
  Systemd issues with percona-xtradb-cluster-5.6 package

Status in percona-xtradb-cluster-5.6 package in Ubuntu:
  Invalid
Status in percona-xtradb-cluster-5.7 package in Ubuntu:
  New
Status in percona-xtradb-cluster-5.6 source package in Xenial:
  New
Status in percona-xtradb-cluster-5.7 source package in Xenial:
  Invalid
Status in percona-xtradb-cluster-5.6 source package in Artful:
  New
Status in percona-xtradb-cluster-5.7 source package in Artful:
  Invalid
Status in percona-xtradb-cluster-5.6 source package in Bionic:
  Invalid
Status in percona-xtradb-cluster-5.7 source package in Bionic:
  New
Status in percona-xtradb-cluster-5.6 source package in Cosmic:
  Invalid
Status in percona-xtradb-cluster-5.7 source package in Cosmic:
  New

Bug description:
  
  Seems like Systemd and Percona XtraDB Cluster don't like to play together in 16.04. There are multiple issues:

  1. There is no way to "bootstrap-pxc" using systemctl and when I use "/etc/init.d/mysql bootstrap-pxc", then even though mysql is running, systemd doesn't think it is.
  See https://www.percona.com/doc/percona-xtradb-cluster/5.6/manual/bootstrap.html for more info.

  Demonstration:
  root@sql1:~# ps ax | grep mysql
   1428 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe --wsrep-new-cluster
   1902 pts/0    Sl     0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/percona-xtradb-cluster --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep-new-cluster --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=de1c3153-1c83-11e6-94af-63e494c70dbe:6
   1997 pts/0    S+     0:00 grep --color=auto mysql

  root@sql1:~# /etc/init.d/mysql status
  ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon
     Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
     Active: inactive (dead)
       Docs: man:systemd-sysv-generator(8)

  root@sql1:~# systemctl status mysql
  ● mysql.service - LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon
     Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
     Active: inactive (dead)
       Docs: man:systemd-sysv-generator(8)
  root@sql1:~#

  2. There is no way to gracefully kill this mysql process:

  Demonstration:
  root@sql1:~# /etc/init.d/mysql stop
  [ ok ] Stopping mysql (via systemctl): mysql.service.

  root@sql1:~# systemctl stop mysql

  root@sql1:~# ps ax | grep mysql
   1428 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe --wsrep-new-cluster
   1902 pts/0    Sl     0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/percona-xtradb-cluster --plugin-dir=/usr/lib/mysql/plugin --user=mysql --wsrep-provider=/usr/lib/libgalera_smm.so --wsrep-new-cluster --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --wsrep_start_position=de1c3153-1c83-11e6-94af-63e494c70dbe:6
   2133 pts/0    S+     0:00 grep --color=auto mysql

  
  Environment: Ubuntu Server 16.04 LTS
  I installed XtraDB Cluster using "apt-get -yq install percona-xtradb-cluster-server"

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.6/+bug/1583000/+subscriptions