| 2018-12-04 23:37:43 |
John George |
bug |
|
|
added bug |
| 2018-12-04 23:37:59 |
John George |
description |
Foundation cloud Builds are seeing many lost connections to the MySQL server from neutron-api.
The bundle and crashdump are attached.
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines [req-ea783de8-dbd5-4b41-972e-8d76c0a135fb - - - - -] Database connection was found disconnected; reconnecting: oslo_db.exception.DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: 'SELECT 1'] (Background on this error at: http://sqlalche.me/e/e3q8)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines context)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 508, in do_execute
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines cursor.execute(statement, parameters)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 165, in execute
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines result = self._query(query)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 321, in _query
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines conn.query(q)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 860, in query
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1061, in _read_query_result
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines result.read()
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1349, in read
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines first_packet = self.connection._read_packet()
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 991, in _read_packet
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines packet_header = self._read_bytes(4)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1037, in _read_bytes
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') |
Foundation cloud builds are seeing many lost connections to the MySQL server from neutron-api.
The bundle and crashdump are attached.
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines [req-ea783de8-dbd5-4b41-972e-8d76c0a135fb - - - - -] Database connection was found disconnected; reconnecting: oslo_db.exception.DBConnectionError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query') [SQL: 'SELECT 1'] (Background on this error at: http://sqlalche.me/e/e3q8)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines Traceback (most recent call last):
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines context)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 508, in do_execute
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines cursor.execute(statement, parameters)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 165, in execute
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines result = self._query(query)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 321, in _query
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines conn.query(q)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 860, in query
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1061, in _read_query_result
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines result.read()
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1349, in read
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines first_packet = self.connection._read_packet()
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 991, in _read_packet
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines packet_header = self._read_bytes(4)
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1037, in _read_bytes
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines CR.CR_SERVER_LOST, "Lost connection to MySQL server during query")
2018-12-04 00:21:16.595 182093 ERROR oslo_db.sqlalchemy.engines pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query') |
|
| 2018-12-04 23:40:23 |
John George |
attachment added |
|
425288fd-dc94-439a-80a9-896c9b955a99_bundle.yaml https://bugs.launchpad.net/charm-neutron-api/+bug/1806784/+attachment/5219162/+files/425288fd-dc94-439a-80a9-896c9b955a99_bundle.yaml |
|
| 2018-12-06 09:21:57 |
James Page |
charm-neutron-api: status |
New |
Triaged |
|
| 2018-12-06 09:21:59 |
James Page |
charm-neutron-api: importance |
Undecided |
High |
|
| 2018-12-06 09:22:14 |
James Page |
bug task added |
|
charm-designate |
|
| 2018-12-06 09:22:24 |
James Page |
bug task added |
|
charm-aodh |
|
| 2018-12-06 09:22:29 |
James Page |
charm-designate: status |
New |
Triaged |
|
| 2018-12-06 09:22:31 |
James Page |
charm-aodh: status |
New |
Triaged |
|
| 2018-12-06 09:22:33 |
James Page |
charm-designate: importance |
Undecided |
High |
|
| 2018-12-06 09:22:34 |
James Page |
charm-aodh: importance |
Undecided |
High |
|
| 2018-12-06 09:23:29 |
James Page |
charm-aodh: importance |
High |
Medium |
|
| 2018-12-06 09:23:31 |
James Page |
charm-designate: importance |
High |
Medium |
|
| 2018-12-06 09:23:32 |
James Page |
charm-neutron-api: importance |
High |
Medium |
|
| 2018-12-06 09:40:24 |
Dmitrii Shcherbakov |
bug |
|
|
added subscriber Dmitrii Shcherbakov |
| 2019-02-25 12:16:56 |
Giuseppe Petralia |
bug |
|
|
added subscriber Giuseppe Petralia |
| 2019-05-16 15:21:18 |
Felipe Reyes |
bug |
|
|
added subscriber Felipe Reyes |
| 2020-05-14 21:06:12 |
Gabriel Ramirez |
charm-neutron-api: assignee |
|
Gabriel Ramirez (gabriel1109) |
|
| 2020-05-14 21:06:16 |
Gabriel Ramirez |
charm-designate: assignee |
|
Gabriel Ramirez (gabriel1109) |
|
| 2020-05-14 21:06:19 |
Gabriel Ramirez |
charm-aodh: assignee |
|
Gabriel Ramirez (gabriel1109) |
|
| 2020-05-19 22:26:06 |
Gabriel Ramirez |
bug task added |
|
charm-nova-cloud-controller |
|
| 2020-05-19 22:26:28 |
Gabriel Ramirez |
bug task added |
|
charm-percona-cluster |
|
| 2020-05-19 22:26:41 |
Gabriel Ramirez |
charm-percona-cluster: assignee |
|
Gabriel Ramirez (gabriel1109) |
|
| 2020-05-19 22:26:46 |
Gabriel Ramirez |
charm-nova-cloud-controller: assignee |
|
Gabriel Ramirez (gabriel1109) |
|
| 2020-05-19 22:26:50 |
Gabriel Ramirez |
charm-neutron-api: assignee |
Gabriel Ramirez (gabriel1109) |
|
|
| 2020-05-19 22:26:52 |
Gabriel Ramirez |
charm-designate: assignee |
Gabriel Ramirez (gabriel1109) |
|
|
| 2020-05-19 22:26:54 |
Gabriel Ramirez |
charm-aodh: assignee |
Gabriel Ramirez (gabriel1109) |
|
|
| 2020-05-19 22:47:10 |
OpenStack Infra |
charm-percona-cluster: status |
New |
In Progress |
|
| 2021-02-23 17:10:20 |
Alex Kavanagh |
charm-nova-cloud-controller: status |
New |
Triaged |
|
