Comment 3 for bug 2059774

I can offer the full debug log of the deployment at least. I'm following the tutorial and this sometimes happens (not always)
https://microstack.run/docs/multi-node-maas

unit-neutron-mysql-2: 12:56:03 DEBUG unit.neutron-mysql/2.juju-log Setting report_host to `neutron-mysql-2.neutron-mysql-endpoints.openstack.svc.cluster.local` on neutron-mysql-2.ne
utron-mysql-endpoints.openstack.svc.cluster.local
unit-neutron-mysql-2: 12:56:03 ERROR unit.neutron-mysql/2.juju-log Failed to set variable report_host to `neutron-mysql-2.neutron-mysql-endpoints.openstack.svc.cluster.local`
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-neutron-mysql-2/charm/src/mysql_k8s_helpers.py", line 666, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-neutron-mysql-2/charm/venv/ops/pebble.py", line 1540, 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-05-28T12:56:03Z: Loading startup files...\nverbose: 2024-05-28T12:56:03Z: Loading plugins..
.\nverbose: 2024-05-28T12:56:03Z: Connecting to MySQL at: <email address hidden>\nverbose: 2024-05-28T12:56:03Z: Shell.conn
ect: tid=61: CONNECTED: neutron-mysql-2.neutron-mysql-endpoints.openstack.svc.cluster.local\nverbose: 2024-05-28T12:56:03Z: Session.run_sql: tid=61: MySQL Error 1238: Variable \'rep
ort_host\' is a read only variable, SQL: SET GLOBAL report_host=`neutron-mysql-2.neutron-mysql-endpoints.openstack.svc.cluster.local`\nTraceback (most recent call last):\n File "<s
tring>", line 2, in <module>\nmysqlsh.DBError: MySQL Error (1238): Session.run_sql: Variable \'report_host\' is a read only variable\n'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-neutron-mysql-2/charm/lib/charms/mysql/v0/mysql.py", line 1096, in set_dynamic_variable
    self._run_mysqlsh_script("\n".join(set_var_command))
  File "/var/lib/juju/agents/unit-neutron-mysql-2/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-05-28T12:56:03Z: Loading startup files...
verbose: 2024-05-28T12:56:03Z: Loading plugins...
verbose: 2024-05-28T12:56:03Z: Connecting to MySQL at: <email address hidden>
verbose: 2024-05-28T12:56:03Z: Shell.connect: tid=61: CONNECTED: neutron-mysql-2.neutron-mysql-endpoints.openstack.svc.cluster.local
verbose: 2024-05-28T12:56:03Z: Session.run_sql: tid=61: MySQL Error 1238: Variable 'report_host' is a read only variable, SQL: SET GLOBAL report_host=`neutron-mysql-2.neutron-mysql-
endpoints.openstack.svc.cluster.local`
Traceback (most recent call last):
  File "<string>", line 2, in <module>
mysqlsh.DBError: MySQL Error (1238): Session.run_sql: Variable 'report_host' is a read only variable