Hello everyone,
I would like to ask if anyone has experienced a similar issue. I am trying to deploy InnoDB on the same machine, and since InnoDB requires a minimum of three nodes, I deployed all of them on machine 0. Once all units were deployed, I noticed that none of the units had joined or formed the cluster.
I checked the logs from one of the units (as shown in the attached screenshot), and after further checking, I found that the cluster was not created at all.
Is there a way to trigger the bootstrap process for the cluster, or are there any other possible solutions? Any help would be greatly appreciated.
2025-09-16 04:41:00 WARNING unit.mysql/10.juju-log server.go:406 This instance is not yet clustered: cannot determine the cluster status. 2025-09-16 04:41:00 INFO unit.mysql/10.juju-log server.go:406 Adding instance, 172.25.10.11, to the cluster.
2025-09-16 04:41:01 ERROR unit.mysql/10.juju-log server.go:406 Failed adding instance 172.25.10.11 to cluster: Cannot set LC ALL to locale en_US.UTF-8: No such file or directory Traceback (most recent call last):
mysqlsh.Error: Shell Error (51300): Dba.get_cluster: This function is not available through a session to a standalone instance
File "<string>", line 2, in <module>
59712
2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/layer_openstack.py:82:check_really_is_update_status 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/layer_openstack.py:93: run_default_update_status 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/mysql-innodb-cluster/peers.py:69: joined: cluster 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/mysql-innodb-cluster/peers.py:75: changed: cluster 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/tls-certificates/requires.py:109: broken: certificates 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 coordinator. DelayedActionCoordinator Leader handling coordinator requests 2025-09-16 04:41:01 INFO unit.mysql/10.juju-log server.go:406 coordinator.DelayedActionCoordinator Publishing state
2025-09-16 04:41:01 INFO juju.worker.uniter.operation runhook.go:186 ran "update-status" hook (via explicit, bespoke hook script) 2025-09-16 04:41:50 INFO unit.mysql/10.juju-log server.go:406 Reactive main running for hook update-status 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 coordinator. DelayedActionCoordinator Loading state
2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 coordinator. DelayedActionCoordinator Leader handling coordinator requests 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Initializing Leadership Layer (is leader) 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Coordinator: Initializing coordinator layer
9029712
25-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Initializing Snap Layer
25-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/layer_openstack.py:64:default_update_status 025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/mysql_innodb_cluster_handlers.py:138: check_quorum 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/mysql_innodb_cluster_handlers.py: 208: add_instances_to_cluster 2025-09-16 04:41:51 WARNING unit.mysql/10.juju-log server.go:406 This instance is not yet clustered: cannot determine the cluster status. 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Adding instance, 172.25.10.13, to the cluster.
971
Οι
2025-09-16 04:41:51 ERROR unit.mysql/10.juju-log server.go:406 Failed adding instance 172.25.10.13 to cluster: Cannot set LC ALL to locale en_US.UTF-8: No such file or directory Traceback (most recent call last): File "<string>", line 2, in <module>
mysqlsh.Error: Shell Error (51300): Dba.get_cluster: This function is not available through a session to a standalone instance
2025-09-16 04:41:51 WARNING unit.mysql/10.juju-log server.go:406 This instance is not yet clustered: cannot determine the cluster status. 2025-09-16 04:41:51 INFO unit.mysql/10.juju-log server.go:406 Adding instance, 172.25.10.11, to the cluster.
2025-09-16 04:41:52 ERROR unit.mysql/10.juju-log server.go:406 Failed adding instance 172.25.10.11 to cluster: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory Traceback (most recent call last): File "<string>", line 2, in <module>
mysqlsh.Error: Shell Error (51300): Dba.get_cluster: This function is not available through a session to a standalone instance
00259713
2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/layer_openstack.py:82:check_really_is_update_status 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: reactive/layer_openstack.py:93: run_default_update_status 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/mysql-innodb-cluster/peers.py:69: joined: cluster 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/mysql-innodb-cluster/peers.py:75: changed: cluster 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 Invoking reactive handler: hooks/relations/tls-certificates/requires.py:109: broken: certificates 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 coordinator. DelayedActionCoordinator Leader handling coordinator requests 2025-09-16 04:41:52 INFO unit.mysql/10.juju-log server.go:406 coordinator. DelayedActionCoordinator Publishing state
2025-09-16 04:41:52 INFO juju.worker.uniter.operation runhook.go:186 ran "update-status" hook (via explicit, bespoke hook script)