yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1916889] [NEW] 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.

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: LIU Yulong <1916889@xxxxxxxxxxxxxxxxxx>
Date: Thu, 25 Feb 2021 12:12:10 -0000
Reply-to: Bug 1916889 <1916889@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

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

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1916889

Title:
  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.

Status in neutron:
  New

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1916889/+subscriptions
Follow ups

[Bug 1916889] Re: 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.
From: OpenStack Infra, 2021-04-21