Getting continuous alerts in neutron log with following error messages

Solution In Progress - Updated -

Issue

  • Live migration for one or more VM failed.

  • We see the following errors in /var/log/containers/neutron/server.log:

2021-08-09 07:16:18.799 26 ERROR oslo_db.api     err.raise_mysql_exception(self._data)
2021-08-09 07:16:18.799 26 ERROR oslo_db.api   File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2021-08-09 07:16:18.799 26 ERROR oslo_db.api     raise errorclass(errno, errval)
2021-08-09 07:16:18.799 26 ERROR oslo_db.api oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, "Duplicate entry '488ed478-3d2b-4c1c-b4fc-752e187b7f14-overcloud-compute-0.localdomain' for key 'PRIMARY'")
2021-08-09 07:16:18.799 26 ERROR oslo_db.api [SQL: UPDATE ml2_port_bindings SET host=%(host)s, vif_type=%(vif_type)s, vif_details=%(vif_details)s WHERE ml2_port_bindings.port_id = %(ml2_port_bindings_port_id)s AND ml2_port_bindings.host = %(ml2_port_bindings_host)s]
2021-08-09 07:16:18.799 26 ERROR oslo_db.api [parameters: {'host': 'overcloud-compute-0.localdomain', 'vif_type': 'unbound', 'vif_details': '', 'ml2_port_bindings_port_id': '488ed478-3d2b-4c1c-b4fc-752e187b7f14', 'ml2_port_bindings_host': 'osrtpz71021.localdomain'}]
2021-08-09 07:16:18.799 26 ERROR oslo_db.api (Background on this error at: http://sqlalche.me/e/gkpj)
2021-08-09 07:16:18.799 26 ERROR oslo_db.api
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation [req-a2c0f30b-9338-4e40-bfe6-5cff242b1d8e 00bfc0eb5dda48438065580f74374c68 5b664c1e58eb4b019d03cc4949c0eb42 - default default] PUT failed.: oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, "Duplicate entry '488ed478-3d2b-4c1c-b4fc-752e187b7f14-osrtpz71022.localdomain' for key 'PRIMARY'")
(Background on this error at: http://sqlalche.me/e/gkpj)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last):
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     cursor, statement, parameters, context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     cursor.execute(statement, parameters)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 165, in execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     result = self._query(query)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     conn.query(q)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 860, in query
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1061, in _read_query_result
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     result.read()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1349, in read
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     first_packet = self.connection._read_packet()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1018, in _read_packet
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     packet.check_error()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 384, in check_error
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     err.raise_mysql_exception(self._data)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise errorclass(errno, errval)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation pymysql.err.IntegrityError: (1062, "Duplicate entry '488ed478-3d2b-4c1c-b4fc-752e187b7f14-overcloud-compute-0.localdomain' for key 'PRIMARY'")
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation The above exception was the direct cause of the following exception:
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last):
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pecan/core.py", line 683, in __call__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.invoke_controller(controller, args, kwargs, state)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pecan/core.py", line 574, in invoke_controller
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     result = controller(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 139, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 135, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_db/api.py", line 154, in wrapper
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_db/api.py", line 142, in wrapper
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 183, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 179, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/pecan_wsgi/controllers/utils.py", line 76, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/pecan_wsgi/controllers/resource.py", line 74, in put
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return {self.resource: self.plugin_updater(*updater_args)}
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/common/utils.py", line 687, in inner
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(self, context, *args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 233, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 139, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 135, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_db/api.py", line 154, in wrapper
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_db/api.py", line 142, in wrapper
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 183, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 179, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/plugin.py", line 1763, in update_port
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.mechanism_manager.update_port_precommit(mech_context)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/managers.py", line 731, in update_port_precommit
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise_db_retriable=True)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/managers.py", line 484, in _call_on_drivers
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     exc_info=e)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/six.py", line 675, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/managers.py", line 477, in _call_on_drivers
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     getattr(driver.obj, method_name)(context)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/drivers/mech_agent.py", line 66, in update_port_precommit
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self._insert_provisioning_block(context)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/drivers/mech_agent.py", line 81, in _insert_provisioning_block
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     if context.host_agents(self.agent_type):
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/plugins/ml2/driver_context.py", line 297, in host_agents
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     'host': [self._binding.host]})
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/api.py", line 233, in wrapped
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/db/agents_db.py", line 301, in get_agents
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     agents = agent_obj.Agent.get_objects(context, **filters)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/objects/base.py", line 640, in get_objects
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs))
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron/objects/db/api.py", line 52, in get_objects
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     **(_pager.to_kwargs(context, obj_cls) if _pager else {}))
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/neutron_lib/db/model_query.py", line 311, in get_collection
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     for c in query
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/query.py", line 3316, in __iter__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.session._autoflush()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 1576, in _autoflush
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self.flush()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2451, in flush
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self._flush(objects)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2589, in _flush
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     transaction.rollback(_capture_exception=True)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     compat.reraise(exc_type, exc_value, exc_tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 129, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/session.py", line 2549, in _flush
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     flush_context.execute()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     rec.execute(self)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/unitofwork.py", line 589, in execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     uow,
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 236, in save_obj
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     update,
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/orm/persistence.py", line 978, in _emit_update_statements
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     statement, multiparams
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 988, in execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return meth(self, multiparams, params)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     return connection._execute_clauseelement(self, multiparams, params)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     distilled_params,
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     e, statement, parameters, cursor, context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1464, in _handle_dbapi_exception
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     util.raise_from_cause(newraise, exc_info)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/util/compat.py", line 128, in reraise
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise value.with_traceback(tb)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     cursor, statement, parameters, context
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python3.6/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     cursor.execute(statement, parameters)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 165, in execute
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     result = self._query(query)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/cursors.py", line 321, in _query
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     conn.query(q)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 860, in query
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1061, in _read_query_result
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     result.read()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1349, in read
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     first_packet = self.connection._read_packet()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 1018, in _read_packet
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     packet.check_error()
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/connections.py", line 384, in check_error
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     err.raise_mysql_exception(self._data)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python3.6/site-packages/pymysql/err.py", line 107, in raise_mysql_exception
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation     raise errorclass(errno, errval)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation oslo_db.exception.DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, "Duplicate entry '488ed478-3d2b-4c1c-b4fc-752e187b7f14-overcloud-compute-0.localdomain' for key 'PRIMARY'")
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation [SQL: UPDATE ml2_port_bindings SET host=%(host)s, vif_type=%(vif_type)s, vif_details=%(vif_details)s WHERE ml2_port_bindings.port_id = %(ml2_port_bindings_port_id)s AND ml2_port_bindings.host = %(ml2_port_bindings_host)s]
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation [parameters: {'host': 'overcloud-compute-0.localdomain', 'vif_type': 'unbound', 'vif_details': '', 'ml2_port_bindings_port_id': '488ed478-3d2b-4c1c-b4fc-752e187b7f14', 'ml2_port_bindings_host': 'overcloud-compute-0.localdomain'}]
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation (Background on this error at: http://sqlalche.me/e/gkpj)
2021-08-09 07:16:18.802 26 ERROR neutron.pecan_wsgi.hooks.translation
ConnectionResetError: [Errno 104] Connection reset by peer

Environment

  • Red Hat OpenStack Platform 16.1 (RHOSP)

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content