Mysql service is not coming up, unable to login to open stack dashboard
heat-cluster/0* active idle 10.218.5.200 Unit is ready and clustered
keystone/0 active idle 0/lxd/5 10.218.5.197 5000/tcp Unit is ready
keystone-cluster/2 active idle 10.218.5.197 Unit is ready and clustered
keystone-ldap/2 active idle 10.218.5.197 Unit is ready
keystone/1 active idle 1/lxd/5 10.218.5.172 5000/tcp Unit is ready
keystone-cluster/1 active idle 10.218.5.172 Unit is ready and clustered
keystone-ldap/0 active idle 10.218.5.172 Unit is ready
keystone/2* error idle 2/lxd/5 10.218.5.234 5000/tcp hook failed: "leader-settings-changed"
keystone-cluster/0* active idle 10.218.5.234 Unit is ready and clustered
keystone-ldap/1* active idle 10.218.5.234 Unit is ready
mysql/0* blocked idle 0/lxd/6 10.218.5.196 3306/tcp Unit is not in sync
mysql-cluster/2 active idle 10.218.5.196 Unit is ready and clustered
mysql/1 blocked idle 1/lxd/6 10.218.5.105 3306/tcp Unit is not in sync
mysql-cluster/1* active idle 10.218.5.105 Unit is ready and clustered
mysql/2 error lost 2/lxd/6 10.218.5.186 3306/tcp hook failed: "leader-settings-changed"
mysql-cluster/0 unknown lost 10.218.5.186 agent lost, see 'juju show-status-log mysql-cluster/0'
neutron-api/0 active idle 0/lxd/7 10.218.5.164 9696/tcp Unit is ready
neutron-cluster/2 active idle 10.218.5.164 Unit is ready and clustered
ubuntu@juju-26b283-2-lxd-6:~$ sudo /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: failed (Result: exit-code) since Mon 2019-12-02 07:47:48 UTC; 30s ago
Docs: man:systemd-sysv-generator(8)
Process: 152352 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
Dec 02 07:47:09 juju-26b283-2-lxd-6 systemd[1]: Starting LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon...
Dec 02 07:47:09 juju-26b283-2-lxd-6 mysql[152352]: * Starting MySQL (Percona XtraDB Cluster) database server mysqld
Dec 02 07:47:48 juju-26b283-2-lxd-6 mysql[152352]: * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
Dec 02 07:47:48 juju-26b283-2-lxd-6 mysql[152352]: ...fail!
Dec 02 07:47:48 juju-26b283-2-lxd-6 systemd[1]: mysql.service: Control process exited, code=exited status=1
Dec 02 07:47:48 juju-26b283-2-lxd-6 systemd[1]: Failed to start LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.
Dec 02 07:47:48 juju-26b283-2-lxd-6 systemd[1]: mysql.service: Unit entered failed state.
Dec 02 07:47:48 juju-26b283-2-lxd-6 systemd[1]: mysql.service: Failed with result 'exit-code'.
Dec 02 07:47:57 juju-26b283-2-lxd-6 systemd[1]: Stopped LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.
Dec 02 07:48:08 juju-26b283-2-lxd-6 systemd[1]: Stopped LSB: Start and stop the mysql (Percona XtraDB Cluster) daemon.