[Bug 1983470] [NEW] mysql-innodb-cluster: Juju-log No connection to the cluster primary RW node skipping DB creation.

[Mayank Gupta]

Public bug reported:

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 back to select RW mode on leader node then we are
facing issue.

Following is the Error:

root at 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.

** Affects: cloud-archive
     Importance: Undecided
         Status: New

** Description changed:

  Hi,
  
- We have deployed Charm Openstack-Ussuri on top of Ubumtu20.04. Now we
+ 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 cluster automatically.
+ 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 back  then  we are facing issue with leader selection have RW node.
-  
+  We  removed all 3 node in the cluster and  when we trying to add  back
+ into the cluster back to select RW mode on leader node then we are
+ facing issue.
+ 
  Following is the Error:
  
- root at juju-e45362-2-lxd-79:~# tail -f  /var/log/juju/unit-mysql-innodb-cluster-91.log 
+ root at 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.

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to Ubuntu Cloud Archive.
https://bugs.launchpad.net/bugs/1983470

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

Status in Ubuntu Cloud Archive:
  New

Bug description:
  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 back to select RW mode on leader node then we
  are facing issue.

  Following is the Error:

  root at 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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1983470/+subscriptions