yahoo-eng-team team mailing list archive

Thread
Date
[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.

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: OpenStack Infra <1916889@xxxxxxxxxxxxxxxxxx>
Date: Wed, 21 Apr 2021 10:36:16 -0000
Reply-to: Bug 1916889 <1916889@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
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 <i@xxxxxxxxxxxx>
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

-- 
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:
  Fix Released

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
References

[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.
From: LIU Yulong, 2021-02-25