mysql-innodb-cluster: Juju-log No connection to the cluster primary RW node skipping DB creation.

Hi,

We have deployed Charm Openstack-Ussuri on top of Ubuntu20.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 the leader node automatically.

We removed all 3 node in the cluster and when we trying to add back into the cluster, RW tag on leader node is not getting selected.

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.