Comment 0 for bug 1983470

Hi,

We have deployed Charm Openstack-Ussuri on top of Ubumtu20.04. Now we are facing the issue with mysql-innodb-cluster.

We have 3 nodes mysql inoodb cluster and it was working fine but suddenly RW tag removed from cluster automatically.

 We removed all 3 node in the cluster and when we trying to add back into the cluster back then we are facing issue with leader selection have RW node.

Following is the Error:

root@juju-e45362-2-lxd-79:~# tail -f /var/log/juju/unit-mysql-innodb-cluster-91.log
2022-08-03 11:37:53 WARNING juju-log No connection to the cluster primary RW node skipping DB creation.
2022-08-03 11:37:53 WARNING juju-log This instance is not yet clustered: cannot determine the cluster status.
2022-08-03 11:37:53 WARNING juju-log Cannot determine the cluster primary RW node for writes.
2022-08-03 11:37:53 WARNING juju-log No connection to the cluster primary RW node skipping DB creation.
2022-08-03 11:37:53 WARNING juju-log This instance is not yet clustered: cannot determine the cluster status.
2022-08-03 11:37:53 WARNING juju-log Cannot determine the cluster primary RW node for writes.
2022-08-03 11:37:53 WARNING juju-log No connection to the cluster primary RW node skipping DB creation.

Please let me know, if any other details are required to investigate the issue.