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

[Mayank Gupta]

** Description changed:

  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.
+ 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 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, RW tag  on leader node is not getting selected.

  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