Systemd issues with percona-xtradb-cluster-5.6 package
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
percona-xtradb-cluster-5.6 (Ubuntu) |
Invalid
|
Medium
|
Unassigned | ||
Xenial |
Confirmed
|
Undecided
|
Unassigned | ||
Artful |
Won't Fix
|
Undecided
|
Unassigned | ||
Bionic |
Invalid
|
Undecided
|
Unassigned | ||
Cosmic |
Invalid
|
Medium
|
Unassigned | ||
percona-xtradb-cluster-5.7 (Ubuntu) |
Confirmed
|
Undecided
|
Unassigned | ||
Xenial |
Invalid
|
Undecided
|
Unassigned | ||
Artful |
Invalid
|
Undecided
|
Unassigned | ||
Bionic |
Confirmed
|
Undecided
|
Unassigned | ||
Cosmic |
Won't Fix
|
Undecided
|
Unassigned |
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:/
Demonstration:
root@sql1:~# ps ax | grep mysql
1428 pts/0 S 0:00 /bin/sh /usr/bin/
1902 pts/0 Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=
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-
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-
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/
1902 pts/0 Sl 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=
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-
Changed in percona-xtradb-cluster-5.6 (Ubuntu): | |
importance: | Undecided → Medium |
status: | Confirmed → Triaged |
information type: | Public → Public Security |
Changed in percona-xtradb-cluster-5.7 (Ubuntu Xenial): | |
status: | New → Invalid |
Changed in percona-xtradb-cluster-5.7 (Ubuntu Artful): | |
status: | New → Invalid |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Bionic): | |
status: | New → Invalid |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Cosmic): | |
status: | Triaged → Invalid |
tags: | added: sts |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Artful): | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster-5.6 (Ubuntu Xenial): | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster-5.7 (Ubuntu Bionic): | |
status: | New → Confirmed |
Changed in percona-xtradb-cluster-5.7 (Ubuntu): | |
status: | New → Confirmed |
Status changed to 'Confirmed' because the bug affects multiple users.