StaleDataError: DELETE statement on table 'standardattributes' expected to delete 2 row(s); 1 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.

Bug #1916889 reported by LIU Yulong
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
neutron
Medium
LIU Yulong

Bug Description

Delete port failed with final DB error:

Feb 25 19:24:34 devstack neutron-server[15279]: DEBUG neutron.api.rpc.handlers.l3_rpc [None req-a6ccb04c-401f-4e23-bc16-e7fc9cfc9ae6 None None] New status for floating IP f681d60c-edf9-41e9-b8b3-70c7cf3d8d42: ERROR {{(pid=15361) update_floatingip_statuses /opt/stack/neutron/neutron/api/rpc/handlers/l3_rpc.py:298}}
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api [req-8bf1060f-eea9-42f0-9d3a-e16aed5d927b req-b9e29b5a-9b7a-4838-9df0-80edc3fec7f4 admin admin] DB exceeded retry limit.: StaleDataError: DELETE statement on table 'standardattributes' expected to delete 2 row(s); 1 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api Traceback (most recent call last):
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 142, in wrapper
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 183, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api LOG.debug("Retry wrapper got retriable exception: %s", e)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 179, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api return f(*dup_args, **dup_kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1711, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api super(Ml2Plugin, self).delete_port(context, id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/api.py", line 125, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api return method(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1439, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self.ipam.delete_port(context, id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 451, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api port['fixed_ips'])
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 95, in _ipam_deallocate_ips
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api "external system for %s", addresses)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 71, in _ipam_deallocate_ips
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api ipam_subnet = ipam_driver.get_subnet(ip['subnet_id'])
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/driver.py", line 337, in get_subnet
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api return NeutronDbSubnet.load(subnet_id, self._context)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/driver.py", line 94, in load
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api ctx, neutron_subnet_id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/db_api.py", line 30, in load_by_neutron_subnet_id
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api context, neutron_subnet_id=neutron_subnet_id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/objects/base.py", line 644, in get_objects
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs))
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/objects/db/api.py", line 53, in get_objects
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api **(_pager.to_kwargs(context, obj_cls) if _pager else {}))
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/opt/stack/neutron/neutron/db/_model_query.py", line 297, in get_collection
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api for c in query
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2924, in __iter__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self.session._autoflush()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1434, in _autoflush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self.flush()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api self._flush(objects)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api transaction.rollback(_capture_exception=True)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api compat.reraise(exc_type, exc_value, exc_tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api flush_context.execute()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api rec.execute(self)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 593, in execute
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api uow
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 265, in delete_obj
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api cached_connections, mapper, table, delete)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1074, in _emit_delete_statements
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api (table.description, expected, rows_matched)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api StaleDataError: DELETE statement on table 'standardattributes' expected to delete 2 row(s); 1 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR oslo_db.api
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation [req-8bf1060f-eea9-42f0-9d3a-e16aed5d927b req-b9e29b5a-9b7a-4838-9df0-80edc3fec7f4 admin admin] DELETE failed.: StaleDataError: DELETE statement on table 'standardattributes' expected to delete 2 row(s); 1 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last):
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/pecan/core.py", line 683, in __call__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.invoke_controller(controller, args, kwargs, state)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/pecan/core.py", line 574, in invoke_controller
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation result = controller(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 140, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 136, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 154, in wrapper
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 142, in wrapper
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 183, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 179, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/utils.py", line 76, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/utils.py", line 115, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/pecan_wsgi/controllers/resource.py", line 81, in delete
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return self.plugin_deleter(*deleter_args)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/common/utils.py", line 632, in inner
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(self, context, *args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/api.py", line 125, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 140, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation setattr(e, '_RETRY_EXCEEDED', True)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 136, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 154, in wrapper
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation ectxt.value = e.inner_exc
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 142, in wrapper
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 183, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation LOG.debug("Retry wrapper got retriable exception: %s", e)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/neutron_lib/db/api.py", line 179, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return f(*dup_args, **dup_kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1711, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation super(Ml2Plugin, self).delete_port(context, id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/api.py", line 125, in wrapped
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return method(*args, **kwargs)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/db_base_plugin_v2.py", line 1439, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.ipam.delete_port(context, id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 451, in delete_port
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation port['fixed_ips'])
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 95, in _ipam_deallocate_ips
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation "external system for %s", addresses)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.force_reraise()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation six.reraise(self.type_, self.value, self.tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/ipam_pluggable_backend.py", line 71, in _ipam_deallocate_ips
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation ipam_subnet = ipam_driver.get_subnet(ip['subnet_id'])
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/driver.py", line 337, in get_subnet
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation return NeutronDbSubnet.load(subnet_id, self._context)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/driver.py", line 94, in load
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation ctx, neutron_subnet_id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/ipam/drivers/neutrondb_ipam/db_api.py", line 30, in load_by_neutron_subnet_id
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation context, neutron_subnet_id=neutron_subnet_id)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/objects/base.py", line 644, in get_objects
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation cls, context, _pager=_pager, **cls.modify_fields_to_db(kwargs))
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/objects/db/api.py", line 53, in get_objects
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation **(_pager.to_kwargs(context, obj_cls) if _pager else {}))
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/opt/stack/neutron/neutron/db/_model_query.py", line 297, in get_collection
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation for c in query
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2924, in __iter__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.session._autoflush()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 1434, in _autoflush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self.flush()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2254, in flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation self._flush(objects)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2380, in _flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation transaction.rollback(_capture_exception=True)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation compat.reraise(exc_type, exc_value, exc_tb)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/session.py", line 2344, in _flush
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation flush_context.execute()
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation rec.execute(self)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 593, in execute
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation uow
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 265, in delete_obj
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation cached_connections, mapper, table, delete)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/persistence.py", line 1074, in _emit_delete_statements
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation (table.description, expected, rows_matched)
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation StaleDataError: DELETE statement on table 'standardattributes' expected to delete 2 row(s); 1 were matched. Please set confirm_deleted_rows=False within the mapper configuration to prevent this warning.
Feb 25 19:24:34 devstack neutron-server[15279]: ERROR neutron.pecan_wsgi.hooks.translation
Feb 25 19:24:34 devstack neutron-server[15279]: DEBUG neutron.pecan_wsgi.hooks.notifier [req-8bf1060f-eea9-42f0-9d3a-e16aed5d927b req-b9e29b5a-9b7a-4838-9df0-80edc3fec7f4 admin admin] No notification will be sent due to unsuccessful status code: 500 {{(pid=15360) after /opt/stack/neutron/neutron/pecan_wsgi/hooks/notifier.py:79}}
Feb 25 19:24:34 devstack neutron-server[15279]: INFO neutron.wsgi [req-8bf1060f-eea9-42f0-9d3a-e16aed5d927b req-b9e29b5a-9b7a-4838-9df0-80edc3fec7f4 admin admin] 172.16.20.12 "DELETE /v2.0/ports/008bbc48-efd1-4312-82b6-32b34c3fea9b HTTP/1.1" status: 500 len: 368 time: 85.1259811

Revision history for this message
LIU Yulong (dragon889) wrote :
Changed in neutron:
status: New → In Progress
importance: Undecided → Medium
assignee: nobody → LIU Yulong (dragon889)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on neutron (master)

Change abandoned by "Slawek Kaplonski <email address hidden>" on branch: master
Review: https://review.opendev.org/c/openstack/neutron/+/777709
Reason: This review is > 4 weeks without comment, and failed Zuul jobs the last time it was checked. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a 'recheck' comment to get fresh test results.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron-lib (master)

Reviewed: https://review.opendev.org/c/openstack/neutron-lib/+/777581
Committed: https://opendev.org/openstack/neutron-lib/commit/0e2f7cb4d516fb5660ab017be4ff6c7fe254288e
Submitter: "Zuul (22348)"
Branch: master

commit 0e2f7cb4d516fb5660ab017be4ff6c7fe254288e
Author: LIU Yulong <email address hidden>
Date: Thu Feb 25 20:22:40 2021 +0800

    Set confirm_deleted_rows=False to StandardAttribute obj

    Do the work of the warning log suggests, since the how many
    rows to delete of standardattributes is not an issue to Neutron.
    The final goal is to delete them all.

    Change-Id: I8113881a2bd2278ce8c912562a172f90e073b686
    Closes-Bug: #1916889

Changed in neutron:
status: In Progress → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron-lib 2.11.0

This issue was fixed in the openstack/neutron-lib 2.11.0 release.

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix merged to neutron (master)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/777709
Committed: https://opendev.org/openstack/neutron/commit/444ef49bea913cd7fec664f56ad460e8e3e68b66
Submitter: "Zuul (22348)"
Branch: master

commit 444ef49bea913cd7fec664f56ad460e8e3e68b66
Author: LIU Yulong <email address hidden>
Date: Fri Feb 26 10:00:49 2021 +0800

    Add test cases for concurrently Object delete

    Verify if concurrently delete neutron DB records will
    encounter the StaleDataError which suggest us to add
    "confirm_deleted_rows=False" to mapper configuration.

    Depends-On: https://review.opendev.org/c/openstack/neutron-lib/+/777581

    Change-Id: Ia8935d5dd87402bedfd7aa9df9dfcb0ce06f8e39
    Related-Bug: #1916889

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers