** 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
--
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
