Thanks David, I tried to run the action you suggested, but with no success:
ubuntu@przemeklal-bastion:~$ juju run-action mysql-innodb-cluster/0 reboot-cluster-from-complete-outage --wait
unit-mysql-innodb-cluster-0:
UnitId: mysql-innodb-cluster/0
id: "92"
message: Reboot cluster from complete outage failed.
results:
output: |+
Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
Restoring the default cluster from complete outage...
Traceback (most recent call last):
File "<string>", line 2, in <module>
SystemError: RuntimeError: Dba.reboot_cluster_from_complete_outage: The MySQL instance '10.5.0.7:3306' belongs to an InnoDB Cluster and is reachable. Please use <Cluster>.force_quorum_using_partition_of() to restore from the quorum loss.
traceback: |
Traceback (most recent call last):
File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/actions/reboot-cluster-from-complete-outage", line 164, in reboot_cluster_from_complete_outage
output = instance.reboot_cluster_from_complete_outage()
File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/lib/charm/openstack/mysql_innodb_cluster.py", line 798, in reboot_cluster_from_complete_outage
raise e
File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/lib/charm/openstack/mysql_innodb_cluster.py", line 786, in reboot_cluster_from_complete_outage
output = self.run_mysqlsh_script(_script).decode("UTF-8")
File "/var/lib/juju/agents/unit-mysql-innodb-cluster-0/charm/lib/charm/openstack/mysql_innodb_cluster.py", line 1541, in run_mysqlsh_script
return subprocess.check_output(cmd, stderr=subprocess.PIPE)
File "/usr/lib/python3.8/subprocess.py", line 411, in check_output
return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
File "/usr/lib/python3.8/subprocess.py", line 512, in run
raise CalledProcessError(retcode, process.args,
subprocess.CalledProcessError: Command '['/snap/bin/mysqlsh', '--no-wizard', '--python', '-f', '/root/snap/mysql-shell/common/tmpaxf532am.py']' returned non-zero exit status 1.
status: failed
timing:
completed: 2021-03-01 18:53:11 +0000 UTC
enqueued: 2021-03-01 18:53:08 +0000 UTC
started: 2021-03-01 18:53:10 +0000 UTC
I tried to run it a couple of times against all 3 units and I kept getting the same traceback as above.
Thanks David, I tried to run the action you suggested, but with no success:
ubuntu@ przemeklal- bastion: ~$ juju run-action mysql-innodb- cluster/ 0 reboot- cluster- from-complete- outage --wait innodb- cluster- 0: cluster/ 0
unit-mysql-
UnitId: mysql-innodb-
id: "92"
message: Reboot cluster from complete outage failed.
results:
output: |+
Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
Restoring the default cluster from complete outage...
Traceback (most recent call last): cluster_ from_complete_ outage: The MySQL instance '10.5.0.7:3306' belongs to an InnoDB Cluster and is reachable. Please use <Cluster> .force_ quorum_ using_partition _of() to restore from the quorum loss.
File "<string>", line 2, in <module>
SystemError: RuntimeError: Dba.reboot_
traceback: | juju/agents/ unit-mysql- innodb- cluster- 0/charm/ actions/ reboot- cluster- from-complete- outage" , line 164, in reboot_ cluster_ from_complete_ outage reboot_ cluster_ from_complete_ outage( ) juju/agents/ unit-mysql- innodb- cluster- 0/charm/ lib/charm/ openstack/ mysql_innodb_ cluster. py", line 798, in reboot_ cluster_ from_complete_ outage juju/agents/ unit-mysql- innodb- cluster- 0/charm/ lib/charm/ openstack/ mysql_innodb_ cluster. py", line 786, in reboot_ cluster_ from_complete_ outage mysqlsh_ script( _script) .decode( "UTF-8" ) juju/agents/ unit-mysql- innodb- cluster- 0/charm/ lib/charm/ openstack/ mysql_innodb_ cluster. py", line 1541, in run_mysqlsh_script check_output( cmd, stderr= subprocess. PIPE) python3. 8/subprocess. py", line 411, in check_output python3. 8/subprocess. py", line 512, in run ror(retcode, process.args, s.CalledProcess Error: Command '['/snap/ bin/mysqlsh' , '--no-wizard', '--python', '-f', '/root/ snap/mysql- shell/common/ tmpaxf532am. py']' returned non-zero exit status 1.
Traceback (most recent call last):
File "/var/lib/
output = instance.
File "/var/lib/
raise e
File "/var/lib/
output = self.run_
File "/var/lib/
return subprocess.
File "/usr/lib/
return run(*popenargs, stdout=PIPE, timeout=timeout, check=True,
File "/usr/lib/
raise CalledProcessEr
subproces
status: failed
timing:
completed: 2021-03-01 18:53:11 +0000 UTC
enqueued: 2021-03-01 18:53:08 +0000 UTC
started: 2021-03-01 18:53:10 +0000 UTC
I tried to run it a couple of times against all 3 units and I kept getting the same traceback as above.