After reboot all nodes I gets an error for mysql and mysql was not able to bring up in cluster. Logs says
2023-07-20T13:03:28.836Z [container-agent] File "/var/lib/juju/agents/unit-mysql-1/charm/lib/charms/mysql/v0/mysql.py", line 935, in get_cluster_status
2023-07-20T13:03:28.836Z [container-agent] output = self._run_mysqlsh_script("\n".join(status_commands), timeout=30)
2023-07-20T13:03:28.836Z [container-agent] File "/var/lib/juju/agents/unit-mysql-1/charm/src/mysql_k8s_helpers.py", line 693, in _run_mysqlsh_script
2023-07-20T13:03:28.836Z [container-agent] raise MySQLClientError(e.stderr)
2023-07-20T13:03:28.836Z [container-agent] charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Loading startup files...
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Loading plugins...
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Connecting to MySQL at: <email address hidden>
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Shell.connect: tid=13294: CONNECTED: mysql-1.mysql-endpoints
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Connecting to MySQL at: mysql://<email address hidden>:3306?connect-timeout=5000
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Dba.get_cluster: tid=13295: CONNECTED: mysql-1.mysql-endpoints:3306
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Connecting to MySQL at: mysql://<email address hidden>:3306?connect-timeout=5000
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Dba.get_cluster: tid=13296: CONNECTED: mysql-1.mysql-endpoints:3306
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Looking up metadata for member 13660737-2538-11ee-bb85-de054f9fdc4a
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: mysql://<email address hidden>:3306 is not a primary, will try to find one and reconnect
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Opening session to primary of InnoDB cluster at <email address hidden>:3306...
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Connecting to MySQL at: mysql://<email address hidden>:3306?connect-timeout=5000
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Dba.get_cluster: tid=104818: CONNECTED: mysql-0.mysql-endpoints.openstack.svc.cluster.local:3306
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Metadata and group sessions are now using the primary member
2023-07-20T13:03:28.836Z [container-agent] verbose: 2023-07-20T13:03:28Z: Connecting to MySQL at: mysql://<email address hidden>:3306?connect-timeout=5000
2023-07-20T13:03:28.836Z [container-agent] ESC[33mWARNING: ESC[0mError connecting to Cluster: MySQL Error 1040 (HY000): Too many connections
2023-07-20T13:03:28.836Z [container-agent] Traceback (most recent call last):
2023-07-20T13:03:28.836Z [container-agent] File "<string>", line 2, in <module>
2023-07-20T13:03:28.836Z [container-agent] mysqlsh.DBError: MySQL Error (1040): Dba.get_cluster: Too many connections
2023-07-20T13:03:28.836Z [container-agent]
2023-07-20T13:03:28.887Z [container-agent] 2023-07-20 13:03:28 INFO juju-log HTTP Request: GET https://10.152.183.1/api/v1/namespaces/openstack/pods/mysql-1 "HTTP/1.1 200 OK"
2023-07-20T13:03:28.912Z [container-agent] 2023-07-20 13:03:28 WARNING juju-log No relation: certificates
2023-07-20T13:03:29.205Z [container-agent] 2023-07-20 13:03:29 INFO juju.worker.uniter.operation runhook.go:186 ran "update-status" hook (via hook dispatching script: dispatch)
Hi, could you please tell us the snap revision ? (result of snap info openstack | grep installed)