OpenStack Snap

neutron-mysql errors on Cannot set LC_ALL to locale en_US.UTF-8

Bug #2071462 reported by Marian Gasparovic on 2024-06-28

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	OpenStack Snap	New	Undecided	Unassigned

Bug Description

During sunbeam deploy (openstack 2024.1/beta) neutron did not deploy

neutron-mysql-router/0 waiting executing 10.1.166.207
neutron-mysql-router/1* waiting idle 10.1.159.144
neutron-mysql-router/2 waiting executing 10.1.155.80
neutron-mysql/0* maintenance executing 10.1.166.204 Unable to get member state
neutron-mysql/1 waiting idle 10.1.155.79 waiting to get cluster primary from peers
neutron-mysql/2 maintenance idle 10.1.4.14 joining the cluster
neutron/0* waiting idle 10.1.166.209 (workload) Not all relations are ready
neutron/1 waiting idle 10.1.155.82 (workload) Leader not ready
neutron/2 waiting idle 10.1.4.17 (workload) Leader not ready

mysql values were overriden in manifest with
   mysql-k8s:
      config:
        profile-limit-memory: 3072
      config-map:
        keystone:
          profile-limit-memory: 3072
        nova:
          profile-limit-memory: 3072

mysql-k8s revision 153

neutron-mysql/0 shows

unit-neutron-mysql-0: 10:44:03 ERROR unit.neutron-mysql/0.juju-log Failed to get cluster status for cluster-a051c86bc7f54c2e9cb5787cf1998215
unit-neutron-mysql-0: 10:44:03 ERROR unit.neutron-mysql/0.juju-log Failed to get cluster endpoints
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-neutron-mysql-0/charm/src/mysql_k8s_helpers.py", line 772, in update_endpoints
    rw_endpoints, ro_endpoints, offline = self.get_cluster_endpoints(get_ips=False)
  File "/var/lib/juju/agents/unit-neutron-mysql-0/charm/lib/charms/tempo_k8s/v1/charm_tracing.py", line 544, in wrapped_function
    return callable(*args, **kwargs) # type: ignore
  File "/var/lib/juju/agents/unit-neutron-mysql-0/charm/lib/charms/mysql/v0/mysql.py", line 1946, in get_cluster_endpoints
    raise MySQLGetClusterEndpointsError("Failed to get endpoints from cluster status")
charms.mysql.v0.mysql.MySQLGetClusterEndpointsError: Failed to get endpoints from cluster status
unit-neutron-mysql-0: 10:44:03 INFO juju.worker.uniter.operation ran "update-status" hook (via hook dispatching script: dispatch)
unit-neutron-mysql-0: 10:44:45 ERROR unit.neutron-mysql/0.juju-log Failed to flush [<MySQLTextLogs.ERROR: 'ERROR LOGS'>, <MySQLTextLogs.GENERAL: 'GENERAL LOGS'>, <MySQLTextLogs.SLOW: 'SLOW LOGS'>] logs.
Traceback (most recent call last):
  File "/var/lib/juju/agents/unit-neutron-mysql-0/charm/src/mysql_k8s_helpers.py", line 602, in _run_mysqlsh_script
    stdout, _ = process.wait_output()
  File "/var/lib/juju/agents/unit-neutron-mysql-0/charm/venv/ops/pebble.py", line 1635, 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-06-28T10:44:05Z: Loading startup files...\nverbose: 2024-06-28T10:44:05Z: Loading plugins...\nverbose: 2024-06-28T10:44:05Z: Connecting to MySQL at: <email address hidden>\nTraceback (most recent call last):\n File "<string>", line 1, in <module>\nValueError: Shell.connect: X protocol error: MySQL server has gone away\nClassic protocol error: MySQL Error 2013 (HY000): Lost connection to MySQL server at \'waiting for initial communication packet\', system error: 110\n\n'