Failed to connect to MySQL

After power shortage my cloud build with openstack base #73 is not working properly mysql-innodb-cluster is not up and the vault is unable to start because of it.

Juju status is :slight_smile:Model Controller Cloud/Region Version SLA Timestamp
openstack juju-controller maas.pcty.geoint/default 2.8.8 unsupported 09:55:06-05:00

App Version Status Scale Charm Store Channel Rev OS Message
ceph-mon 15.2.7 active 3 ceph-mon charmstore 53 ubuntu Unit is ready and clustered
ceph-osd 15.2.11 active 4 ceph-osd charmstore 308 ubuntu Unit is ready (1 OSD)
ceph-radosgw 15.2.7 active 1 ceph-radosgw charmstore 294 ubuntu Unit is ready
cinder 17.0.1 active 1 cinder charmstore 308 ubuntu Unit is ready
cinder-ceph 17.0.1 active 1 cinder-ceph charmstore 260 ubuntu Unit is ready
cinder-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
dashboard-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
glance 21.0.0 active 1 glance charmstore 303 ubuntu Unit is ready
glance-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
keystone 18.0.0 active 1 keystone charmstore 321 ubuntu Application Ready
keystone-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
mysql-innodb-cluster 8.0.25 blocked 3 mysql-innodb-cluster charmstore 5 ubuntu MySQL InnoDB Cluster not healthy: None
neutron-api 17.0.0 active 1 neutron-api charmstore 292 ubuntu Unit is ready
neutron-api-plugin-ovn 17.0.0 active 1 neutron-api-plugin-ovn charmstore 4 ubuntu Unit is ready
neutron-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
nova-cloud-controller 22.0.1 active 1 nova-cloud-controller charmstore 352 ubuntu PO: Unit is ready
nova-compute 22.0.1 active 3 nova-compute charmstore 325 ubuntu Unit is ready
nova-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
ntp 3.5 active 3 ntp charmstore 44 ubuntu chrony: Ready
openstack-dashboard 18.6.1 active 1 openstack-dashboard charmstore 311 ubuntu Unit is ready
ovn-central 20.03.1 active 3 ovn-central charmstore 5 ubuntu Unit is ready (leader: ovnsb_db)
ovn-chassis 20.03.1 active 3 ovn-chassis charmstore 10 ubuntu Unit is ready
placement 4.0.0 active 1 placement charmstore 17 ubuntu Unit is ready
placement-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL
rabbitmq-server 3.8.2 active 1 rabbitmq-server charmstore 108 ubuntu Unit is ready
vault 1.5.4 error 1 vault charmstore 44 ubuntu hook failed: “start”
vault-mysql-router 8.0.25 blocked 1 mysql-router charmstore 6 ubuntu Failed to connect to MySQL

Unit Workload Agent Machine Public address Ports Message
ceph-mon/0 active idle 0/lxd/0 192.168.221.78 Unit is ready and clustered
ceph-mon/1 active idle 1/lxd/0 192.168.221.22 Unit is ready and clustered
ceph-mon/2* active idle 2/lxd/0 192.168.221.12 Unit is ready and clustered
ceph-osd/1 active idle 1 192.168.221.91 Unit is ready (1 OSD)
ceph-osd/2 active idle 2 192.168.221.77 Unit is ready (1 OSD)
ceph-osd/3 active idle 3 192.168.221.7 Unit is ready (2 OSD)
ceph-osd/5* active idle 6 192.168.221.24 Unit is ready (2 OSD)
ceph-radosgw/0* active idle 0/lxd/1 192.168.221.14 80/tcp Unit is ready
cinder/0* active idle 1/lxd/1 192.168.221.20 8776/tcp Unit is ready
cinder-ceph/0* active idle 192.168.221.20 Unit is ready
cinder-mysql-router/0* blocked idle 192.168.221.20 Failed to connect to MySQL
glance/0* active idle 2/lxd/1 192.168.221.25 9292/tcp Unit is ready
glance-mysql-router/0* blocked idle 192.168.221.25 Failed to connect to MySQL
keystone/0* active idle 0/lxd/2 192.168.221.15 5000/tcp Unit is ready
keystone-mysql-router/0* blocked idle 192.168.221.15 Failed to connect to MySQL
mysql-innodb-cluster/0* blocked executing 0/lxd/3 192.168.221.99 MySQL InnoDB Cluster not healthy: None
mysql-innodb-cluster/1 blocked idle 1/lxd/2 192.168.221.5 MySQL InnoDB Cluster not healthy: None
mysql-innodb-cluster/2 blocked idle 2/lxd/2 192.168.221.8 MySQL InnoDB Cluster not healthy: None
neutron-api/0* active idle 1/lxd/3 192.168.221.23 9696/tcp Unit is ready
neutron-api-plugin-ovn/0* active idle 192.168.221.23 Unit is ready
neutron-mysql-router/0* blocked idle 192.168.221.23 Failed to connect to MySQL
nova-cloud-controller/0* active idle 0/lxd/4 192.168.221.19 8774/tcp,8775/tcp PO: Unit is ready
nova-mysql-router/0* blocked idle 192.168.221.19 Failed to connect to MySQL
nova-compute/0* active idle 0 192.168.221.96 Unit is ready
ntp/0* active idle 192.168.221.96 123/udp chrony: Ready
ovn-chassis/0* active idle 192.168.221.96 Unit is ready
nova-compute/1 active idle 1 192.168.221.91 Unit is ready
ntp/1 active idle 192.168.221.91 123/udp chrony: Ready
ovn-chassis/1 active idle 192.168.221.91 Unit is ready
nova-compute/2 active idle 2 192.168.221.77 Unit is ready
ntp/2 active idle 192.168.221.77 123/udp chrony: Ready
ovn-chassis/2 active idle 192.168.221.77 Unit is ready
openstack-dashboard/0* active idle 1/lxd/4 192.168.221.21 80/tcp,443/tcp Unit is ready
dashboard-mysql-router/0* blocked idle 192.168.221.21 Failed to connect to MySQL
ovn-central/0* active idle 0/lxd/5 192.168.221.17 6641/tcp,6642/tcp Unit is ready (leader: ovnsb_db)
ovn-central/1 active idle 1/lxd/5 192.168.221.13 6641/tcp,6642/tcp Unit is ready (northd: active)
ovn-central/2 active idle 2/lxd/3 192.168.221.29 6641/tcp,6642/tcp Unit is ready (leader: ovnnb_db)
placement/0* active idle 2/lxd/4 192.168.221.26 8778/tcp Unit is ready
placement-mysql-router/0* blocked idle 192.168.221.26 Failed to connect to MySQL
rabbitmq-server/0* active idle 2/lxd/5 192.168.221.4 5672/tcp Unit is ready
vault/0* error idle 0/lxd/6 192.168.221.11 8200/tcp hook failed: “start”
vault-mysql-router/0* blocked idle 192.168.221.11 Failed to connect to MySQL

Machine State DNS Inst id Series AZ Message
0 started 192.168.221.96 PowerEdge-9R0DH13 focal default Deployed
0/lxd/0 started 192.168.221.78 juju-191a8d-0-lxd-0 focal default Container started
0/lxd/1 started 192.168.221.14 juju-191a8d-0-lxd-1 focal default Container started
0/lxd/2 started 192.168.221.15 juju-191a8d-0-lxd-2 focal default Container started
0/lxd/3 started 192.168.221.99 juju-191a8d-0-lxd-3 focal default Container started
0/lxd/4 started 192.168.221.19 juju-191a8d-0-lxd-4 focal default Container started
0/lxd/5 started 192.168.221.17 juju-191a8d-0-lxd-5 focal default Container started
0/lxd/6 started 192.168.221.11 juju-191a8d-0-lxd-6 focal default Container started
1 started 192.168.221.91 PowerEdge-9R0FH13 focal default Deployed
1/lxd/0 started 192.168.221.22 juju-191a8d-1-lxd-0 focal default Container started
1/lxd/1 started 192.168.221.20 juju-191a8d-1-lxd-1 focal default Container started
1/lxd/2 started 192.168.221.5 juju-191a8d-1-lxd-2 focal default Container started
1/lxd/3 started 192.168.221.23 juju-191a8d-1-lxd-3 focal default Container started
1/lxd/4 started 192.168.221.21 juju-191a8d-1-lxd-4 focal default Container started
1/lxd/5 started 192.168.221.13 juju-191a8d-1-lxd-5 focal default Container started
2 started 192.168.221.77 PowerEdge-9R0CH13 focal default Deployed
2/lxd/0 started 192.168.221.12 juju-191a8d-2-lxd-0 focal default Container started
2/lxd/1 started 192.168.221.25 juju-191a8d-2-lxd-1 focal default Container started
2/lxd/2 started 192.168.221.8 juju-191a8d-2-lxd-2 focal default Container started
2/lxd/3 started 192.168.221.29 juju-191a8d-2-lxd-3 focal default Container started
2/lxd/4 started 192.168.221.26 juju-191a8d-2-lxd-4 focal default Container started
2/lxd/5 started 192.168.221.4 juju-191a8d-2-lxd-5 focal default Container started
3 started 192.168.221.7 NX3240-4XF2613 focal default Deployed
6 started 192.168.221.24 N4610-MJ05EA87 focal default Deployed

Please see your other posting concerning Vault.