2022-08-03 12:05:55 |
Mayank Gupta |
bug |
|
|
added bug |
2022-08-03 12:10:20 |
Mayank Gupta |
description |
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. |
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@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. |
|
2022-08-04 07:10:51 |
Mayank Gupta |
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@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. |
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. |
|
2022-08-05 14:22:30 |
Mayank Gupta |
bug |
|
|
added subscriber Openstack Charm Testers |
2022-08-05 14:27:35 |
Mayank Gupta |
bug |
|
|
added subscriber OpenStack Charmers |
2022-08-11 06:10:02 |
Mayank Gupta |
affects |
cloud-archive |
barbican-charm-layers |
|
2022-08-11 08:42:49 |
Mayank Gupta |
affects |
barbican-charm-layers |
openstack-community |
|