Mysql service is not starting up , mysql is in error state , unable to login to dashaboard

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.

Some please help me how to fix it

Have you checked the logs in /var/log/mysql/error.log (or something similar)