git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Openstack] MySQL server has gone away


I have deployed openstack-ansible and somehow i am frequently seeing
following error, I have no packet loss in network and max_packet size
is also 16MB in mysql does any one know about this issue?

nova-placement-api.log

==> ostack-infra-03-nova-api-container-543a1e2a/nova-placement-api.log <==
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines [req-bfc9f182-7b91-4de5-8b99-f353fda4487f
8ec61b0530b94a699c4dcf164115f365 328fc75d4f944a64ad1b8699c02350ca -
default default] Database connection was found disconnected;
reconnecting: DBConnectionError: (pymysql.err.OperationalError) (2006,
"MySQL server has gone away (error(104, 'Connection reset by peer'))")
[SQL: u'SELECT 1'] (Background on this error at:
http://sqlalche.me/e/e3q8)
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines Traceback (most recent call last):
Aug 17 00:18:48 ostack-infra-03-nova-api-container-543a1e2a
nova-placement-api: 2018-08-17 00:18:41.497 14880 ERROR
oslo_db.sqlalchemy.engines   File
"/openstack/venvs/nova-17.0.8/lib/python2.7/site-packages/oslo_db/sqlalchemy/engines.py",
line 73, in _connect_ping_listener