Octavia blocked with message Virtual network for access to Amphorae is down

Bug #1992181 reported by Bas de Bruijne
30
This bug affects 7 people
Affects Status Importance Assigned to Milestone
OpenStack Octavia Charm
New
Undecided
Unassigned

Bug Description

In testrun https://solutions.qa.canonical.com/testruns/testRun/b3ed6ee8-7535-498e-91f2-ec03cc8a672e, which is ussuri-focal ovs with octavia latest/stable, octavia stays blocked:

```
octavia/0 blocked idle 3/lxd/8 10.246.164.168 9876/tcp Virtual network for access to Amphorae is down
  filebeat/74 active idle 10.246.164.168 Filebeat ready.
  hacluster-octavia/0* active idle 10.246.164.168 Unit is ready and clustered
  landscape-client/74 maintenance idle 10.246.164.168 Need computer-title and juju-info to proceed
  logrotated/67 active idle 10.246.164.168 Unit is ready.
  neutron-openvswitch-octavia/0* active idle 10.246.164.168 Unit is ready
  nrpe/82 active idle 10.246.164.168 icmp,5666/tcp Ready
  octavia-mysql-router/0* active idle 10.246.164.168 Unit is ready
  prometheus-grok-exporter/74 active idle 10.246.164.168 9144/tcp Unit is ready
  public-policy-routing/47 active idle 10.246.164.168 Unit is ready
  telegraf/74 active idle 10.246.164.168 9103/tcp Monitoring octavia/0 (source version/commit 76901fd)
octavia/1 active idle 4/lxd/9 10.246.165.225 9876/tcp Unit is ready
  filebeat/76 active idle 10.246.165.225 Filebeat ready.
  hacluster-octavia/2 active idle 10.246.165.225 Unit is ready and clustered
  landscape-client/76 maintenance idle 10.246.165.225 Need computer-title and juju-info to proceed
  logrotated/69 active idle 10.246.165.225 Unit is ready.
  neutron-openvswitch-octavia/2 active idle 10.246.165.225 Unit is ready
  nrpe/84 active idle 10.246.165.225 icmp,5666/tcp Ready
  octavia-mysql-router/2 active idle 10.246.165.225 Unit is ready
  prometheus-grok-exporter/76 active idle 10.246.165.225 9144/tcp Unit is ready
  public-policy-routing/49 active idle 10.246.165.225 Unit is ready
  telegraf/76 active idle 10.246.165.225 9103/tcp Monitoring octavia/1 (source version/commit 76901fd)
octavia/2* active idle 5/lxd/9 10.246.164.236 9876/tcp Unit is ready
  filebeat/75 active idle 10.246.164.236 Filebeat ready.
  hacluster-octavia/1 active idle 10.246.164.236 Unit is ready and clustered
  landscape-client/75 maintenance idle 10.246.164.236 Need computer-title and juju-info to proceed
  logrotated/68 active idle 10.246.164.236 Unit is ready.
  neutron-openvswitch-octavia/1 active idle 10.246.164.236 Unit is ready
  nrpe/83 active idle 10.246.164.236 icmp,5666/tcp Ready
  octavia-mysql-router/1 active idle 10.246.164.236 Unit is ready
  prometheus-grok-exporter/75 active idle 10.246.164.236 9144/tcp Unit is ready
  public-policy-routing/48 active idle 10.246.164.236 Unit is ready
  telegraf/75 active idle 10.246.164.236 9103/tcp Monitoring octavia/2 (source version/commit 76901fd)
```

In the logs we see that octavia can't find when the amphora was created:
```
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 WARNING oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped.: pymysql.err.InternalError: (1054, "Unknown column 'amphora.created_at' in 'field list'")
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters result.read()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (1054, "Unknown column 'amphora.created_at' in 'field list'")
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.665 117269 ERROR oslo_db.sqlalchemy.exc_filters
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 WARNING oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped.: pymysql.err.InternalError: (1054, "Unknown column 'amphora.created_at' in 'field list'")
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters self.dialect.do_execute(
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters cursor.execute(statement, parameters)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters result = self._query(query)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters conn.query(q)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters self._affected_rows = self._read_query_result(unbuffered=unbuffered)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters result.read()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters first_packet = self.connection._read_packet()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 684, in _read_packet
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters packet.check_error()
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/protocol.py", line 220, in check_error
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters err.raise_mysql_exception(self._data)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters File "/usr/lib/python3/dist-packages/pymysql/err.py", line 109, in raise_mysql_exception
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters raise errorclass(errno, errval)
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters pymysql.err.InternalError: (1054, "Unknown column 'amphora.created_at' in 'field list'")
octavia/octavia-housekeeping.log:2022-10-07 07:38:07.671 117269 ERROR oslo_db.sqlalchemy.exc_filters
```

Later there are more general SQL errors:
```
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines self.dialect.do_execute(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines cursor.execute(statement, parameters)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines result = self._query(query)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines conn.query(q)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines self._affected_rows = self._read_query_result(unbuffered=unbuffered)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines result.read()
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines first_packet = self.connection._read_packet()
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 657, in _read_packet
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines packet_header = self._read_bytes(4)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 706, in _read_bytes
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines raise err.OperationalError(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines The above exception was the direct cause of the following exception:
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/oslo_db/sqlalchemy/engines.py", line 73, in _connect_ping_listener
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines connection.scalar(select([1]))
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in scalar
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines return self.execute(object_, *multiparams, **params).scalar()
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 982, in execute
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines return meth(self, multiparams, params)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines return connection._execute_clauseelement(self, multiparams, params)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1095, in _execute_clauseelement
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines ret = self._execute_context(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines self._handle_dbapi_exception(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1474, in _handle_dbapi_exception
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines util.raise_from_cause(newraise, exc_info)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines reraise(type(exception), exception, tb=exc_tb, cause=cause)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 152, in reraise
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines raise value.with_traceback(tb)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1245, in _execute_context
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines self.dialect.do_execute(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 581, in do_execute
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines cursor.execute(statement, parameters)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines result = self._query(query)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines conn.query(q)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines self._affected_rows = self._read_query_result(unbuffered=unbuffered)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines result.read()
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1075, in read
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines first_packet = self.connection._read_packet()
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 657, in _read_packet
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines packet_header = self._read_bytes(4)
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 706, in _read_bytes
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines raise err.OperationalError(
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines oslo_db.exception.DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines [SQL: SELECT 1]
octavia/octavia-housekeeping.log:2022-10-07 08:00:14.863 118465 ERROR oslo_db.sqlalchemy.engines (Background on this error at: http://sqlalche.me/e/e3q8)
```

The MySQL-router is not complaining about connection errors, and the octavia leader is not showing these errors.

Crashdumps and configs can be found here:
https://oil-jenkins.canonical.com/artifacts/b3ed6ee8-7535-498e-91f2-ec03cc8a672e/index.html

Tags: cdo-qa
tags: added: cdo-qa
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.