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 protected]> 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 -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp

