NSXv CI is failing with stale DB resources

Bug #1732657 reported by Gary Kotton on 2017-11-16
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
vmware-nsx
Undecided
Unassigned

Bug Description

This is the trace from the runs:

Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin Traceback (most recent call last):
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v/plugin.py", line 3050, in create_router
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin context, lrouter['id'], gw_info)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v/plugin.py", line 3389, in _update_router_gw_info
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin force_update=force_update)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/opt/stack/vmware-nsx/vmware_nsx/plugins/nsx_v/drivers/shared_router_driver.py", line 702, in _up
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin context, router_id, info, router=router)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/opt/stack/neutron/neutron/db/l3_gwmode_db.py", line 62, in _update_router_gw_info
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin router.enable_snat = self._get_enable_snat(info)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 567, in __exit__
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin self.rollback()
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin compat.reraise(exc_type, exc_value, exc_tb)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 564, in __exit__
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin self.commit()
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 461, in commit
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin self._prepare_impl()
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 441, in _prepare_impl
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin self.session.flush()
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2192, in flush
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin self._flush(objects)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2312, in _flush
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin transaction.rollback(_capture_exception=True)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin compat.reraise(exc_type, exc_value, exc_tb)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2276, in _flush
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin flush_context.execute()
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 389, in execute
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin rec.execute(self)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 548, in execute
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin uow
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 177, in save_obj
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin mapper, table, update)
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 760, in _emit_update_
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin (table.description, len(records), rows))
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin StaleDataError: UPDATE statement on table 'standardattributes' expected to update 1 row(s); 0 were matche
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]: ERROR vmware_nsx.plugins.nsx_v.plugin
Nov 15 21:52:30 nsxv-ci1-devstack neutron-server[30699]:

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

Other bug subscribers