unit-heat-mysql-router-0: 10:30:58 INFO juju.worker.uniter.operation ran "update-status" hook (via hook dispatching script: dispatch)
unit-nova-mysql-0: 10:31:06 ERROR unit.nova-mysql/0.juju-log Failed to flush ERROR LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:05Z: Loading startup files...\nverbose: 2024-03-06T10:31:05Z: Loading plugins...\nverbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:05Z: Loading startup files...
verbose: 2024-03-06T10:31:05Z: Loading plugins...
verbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-horizon-mysql-0: 10:31:06 ERROR unit.horizon-mysql/0.juju-log Failed to flush ERROR LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:05Z: Loading startup files...\nverbose: 2024-03-06T10:31:05Z: Loading plugins...\nverbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:05Z: Loading startup files...
verbose: 2024-03-06T10:31:05Z: Loading plugins...
verbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-cinder-mysql-0: 10:31:07 ERROR unit.cinder-mysql/0.juju-log Failed to flush ERROR LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:06Z: Loading startup files...\nverbose: 2024-03-06T10:31:06Z: Loading plugins...\nverbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:06Z: Loading startup files...
verbose: 2024-03-06T10:31:06Z: Loading plugins...
verbose: 2024-03-06T10:31:06Z: Connecting to MySQL at: serverconfig@cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-nova-mysql-0: 10:31:07 ERROR unit.nova-mysql/0.juju-log Failed to flush GENERAL LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:07Z: Loading startup files...\nverbose: 2024-03-06T10:31:07Z: Loading plugins...\nverbose: 2024-03-06T10:31:07Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:07Z: Loading startup files...
verbose: 2024-03-06T10:31:07Z: Loading plugins...
verbose: 2024-03-06T10:31:07Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-horizon-mysql-0: 10:31:07 ERROR unit.horizon-mysql/0.juju-log Failed to flush GENERAL LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:07Z: Loading startup files...\nverbose: 2024-03-06T10:31:07Z: Loading plugins...\nverbose: 2024-03-06T10:31:07Z: Connecting to MySQL at: serverconfig@horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-horizon-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:07Z: Loading startup files...
verbose: 2024-03-06T10:31:07Z: Loading plugins...
verbose: 2024-03-06T10:31:07Z: Connecting to MySQL at: serverconfig@horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'horizon-mysql-0.horizon-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-nova-mysql-0: 10:31:09 ERROR unit.nova-mysql/0.juju-log Failed to flush SLOW LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:08Z: Loading startup files...\nverbose: 2024-03-06T10:31:08Z: Loading plugins...\nverbose: 2024-03-06T10:31:08Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-nova-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:08Z: Loading startup files...
verbose: 2024-03-06T10:31:08Z: Loading plugins...
verbose: 2024-03-06T10:31:08Z: Connecting to MySQL at: serverconfig@nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'nova-mysql-0.nova-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-cinder-mysql-0: 10:31:09 ERROR unit.cinder-mysql/0.juju-log Failed to flush GENERAL LOGS logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/venv/ops/pebble.py", line 1441, in wait_output
    raise ExecError[AnyStr](self._command, exit_code, out_value, err_value)
ops.pebble.ExecError: non-zero exit code 1 executing ['/usr/bin/mysqlsh', '--no-wizard', '--python', '--verbose=1', '-f', '/tmp/script.py', ';', 'rm', '/tmp/script.py'], stdout='', stderr='Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory\nverbose: 2024-03-06T10:31:08Z: Loading startup files...\nverbose: 2024-03-06T10:31:08Z: Loading plugins...\nverbose: 2024-03-06T10:31:08Z: Connecting to MySQL at: serverconfig@cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local\nTraceback (most recent call last):\n  File "<string>", line 1, in <module>\nmysqlsh.DBError: MySQL Error (2003): Shell.connect: Can\'t connect to MySQL server on \'cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local:3306\' (111)\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 2585, in flush_mysql_logs
    self._run_mysqlsh_script("\n".join(flush_logs_commands))
  File "/var/lib/juju/agents/unit-cinder-mysql-0/charm/src/mysql_k8s_helpers.py", line 669, in _run_mysqlsh_script
    raise MySQLClientError(e.stderr)
charms.mysql.v0.mysql.MySQLClientError: Cannot set LC_ALL to locale en_US.UTF-8: No such file or directory
verbose: 2024-03-06T10:31:08Z: Loading startup files...
verbose: 2024-03-06T10:31:08Z: Loading plugins...
verbose: 2024-03-06T10:31:08Z: Connecting to MySQL at: serverconfig@cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local
Traceback (most recent call last):
  File "<string>", line 1, in <module>
mysqlsh.DBError: MySQL Error (2003): Shell.connect: Can't connect to MySQL server on 'cinder-mysql-0.cinder-mysql-endpoints.openstack.svc.cluster.local:3306' (111)

unit-keystone-mysql-0: 10:31:14 INFO unit.keystone-mysql/0.juju-log Unit workload member-state is online with member-role primary