yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1465407] Re: StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched.

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Doug Hellmann <doug@xxxxxxxxxxxxxxxx>
Date: Wed, 29 Jul 2015 18:58:12 -0000
Reply-to: Bug 1465407 <1465407@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: neutron
       Status: Fix Committed => Fix Released

** Changed in: neutron
    Milestone: None => liberty-2

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

Title:
  StaleDataError: UPDATE statement on table 'ports' expected to update 1
  row(s); 0 were matched.

Status in neutron:
  Fix Released

Bug description:
  Looks like bug 1405379 is back:

  http://logs.openstack.org/94/189594/4/gate/gate-tempest-dsvm-neutron-
  full/657d5f4/logs/screen-q-svc.txt.gz?level=TRACE#_2015-06-15_11_05_37_846

  2015-06-15 11:05:37.846 ERROR oslo_messaging.rpc.dispatcher [req-50d50b84-6aa5-4588-a6bc-1ef346a7b8cd None None] Exception during message handling: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched.
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher Traceback (most recent call last):
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     executor_callback))
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     executor_callback)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 130, in _do_dispatch
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     result = func(ctxt, **new_args)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/opt/stack/new/neutron/neutron/plugins/ml2/rpc.py", line 135, in get_devices_details_list
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     for device in kwargs.pop('devices', [])
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/opt/stack/new/neutron/neutron/plugins/ml2/rpc.py", line 107, in get_device_details
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     port_context.network.current)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 1407, in update_port_status
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     port.port_binding.host)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/opt/stack/new/neutron/neutron/plugins/ml2/db.py", line 171, in get_binding_levels
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     order_by(models.PortBindingLevel.level).
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2398, in all
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     return list(self)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2514, in __iter__
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     self.session._autoflush()
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1282, in _autoflush
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     self.flush()
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2004, in flush
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     self._flush(objects)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2122, in _flush
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     transaction.rollback(_capture_exception=True)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     compat.reraise(exc_type, exc_value, exc_tb)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2086, in _flush
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     flush_context.execute()
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     rec.execute(self)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     uow
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 170, in save_obj
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     mapper, table, update)
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 692, in _emit_update_statements
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher     (table.description, len(records), rows))
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched.
  2015-06-15 11:05:37.846 21067 ERROR oslo_messaging.rpc.dispatcher 

  http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiU3RhbGVEYXRhRXJyb3I6IFVQREFURSBzdGF0ZW1lbnQgb24gdGFibGUgJ3BvcnRzJyBleHBlY3RlZCB0byB1cGRhdGUgMSByb3cocyk7IDAgd2VyZSBtYXRjaGVkLlwiIEFORCB0YWdzOlwic2NyZWVuLXEtc3ZjLnR4dFwiIEFORCBtb2R1bGU6XCJvc2xvX21lc3NhZ2luZy5ycGMuZGlzcGF0Y2hlclwiIiwiZmllbGRzIjpbXSwib2Zmc2V0IjowLCJ0aW1lZnJhbWUiOiI2MDQ4MDAiLCJncmFwaG1vZGUiOiJjb3VudCIsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxNDM0NDAyNjUxOTM1LCJtb2RlIjoiIiwiYW5hbHl6ZV9maWVsZCI6IiJ9

  1858 hits (many duplicate traces) in the last 48 hours, check and
  gate.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1465407/+subscriptions
References

[Bug 1465407] [NEW] StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched.
From: Matt Riedemann, 2015-06-15