[bionic] mysql is not up sometimes in AIO setup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Percona Cluster Charm |
Triaged
|
Medium
|
Unassigned |
Bug Description
ubuntu 18.04, All-In-One setup
2021-02-18 01:53:49 DEBUG juju-log shared-db:37: Opening db connection for root@None
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:49 WARNING shared-
2021-02-18 01:53:50 ERROR juju.worker.
/var/log/syslog
Feb 18 01:19:42 juju-7f4505-0-lxd-3 mysql[11797]: * Stopping MySQL (Percona XtraDB Cluster) mysqld
Feb 18 01:19:57 juju-7f4505-0-lxd-3 /etc/init.
Feb 18 01:19:57 juju-7f4505-0-lxd-3 /etc/init.
Feb 18 01:19:57 juju-7f4505-0-lxd-3 mysql[11797]: ...done.
Feb 18 01:19:57 juju-7f4505-0-lxd-3 systemd[1]: Stopped Percona XtraDB Cluster daemon.
Feb 18 01:19:57 juju-7f4505-0-lxd-3 systemd[1]: system-mysql.slice: Failed to reset devices.list: Operation not permitted
Feb 18 01:19:57 juju-7f4505-0-lxd-3 systemd[1]: Created slice system-mysql.slice.
Feb 18 01:19:57 juju-7f4505-0-lxd-3 systemd[1]: Starting Percona XtraDB Cluster daemon with config /etc/default/
Feb 18 01:20:00 juju-7f4505-0-lxd-3 mysql[11974]: WSREP: Recovered position 51893779-
Feb 18 01:20:01 juju-7f4505-0-lxd-3 systemd[1]: Failed to attach 11978 to compat systemd cgroup /<email address hidden>: Permission denied
Feb 18 01:20:01 juju-7f4505-0-lxd-3 mysql[11978]: * Starting MySQL (Percona XtraDB Cluster) database server mysqld
Feb 18 01:20:01 juju-7f4505-0-lxd-3 /etc/init.
Feb 18 01:20:05 juju-7f4505-0-lxd-3 mysql[11978]: ...done.
Feb 18 01:20:05 juju-7f4505-0-lxd-3 systemd[1]: Started Percona XtraDB Cluster daemon with config /etc/default/
Feb 18 01:24:17 juju-7f4505-0-lxd-3 mysql[16242]: * Stopping MySQL (Percona XtraDB Cluster) mysqld
Feb 18 01:24:17 juju-7f4505-0-lxd-3 /etc/init.
Feb 18 01:24:17 juju-7f4505-0-lxd-3 /etc/init.
Feb 18 01:24:17 juju-7f4505-0-lxd-3 mysql[16242]: ...done.
summary: |
- mysql is not up sometimes in AIO setup + [bionic] mysql is not up sometimes in AIO setup |
Setting to medium as AIO is a test target, and wouldn't be used in production. Still be good to resolve why it is happening.