** Changed in: neutron Status: Confirmed => Fix Released ** Changed in: neutron Assignee: (unassigned) => Salvatore Orlando (salvatore-orlando)
-- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1432065 Title: DBDeadlock: (OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') 'DELETE FROM ipallocationpools WHERE ipallocationpools.id Status in OpenStack Neutron (virtual network service): Fix Released Bug description: http://logs.openstack.org/78/163978/1/check/check-tempest-dsvm- neutron- full/792a4e4/logs/screen-q-svc.txt.gz?level=TRACE#_2015-03-13_16_07_36_406 2015-03-13 16:07:36.406 ERROR oslo_messaging.rpc.dispatcher [req-d42b66e6-5ee7-4e08-b59d-318aebfe92d7 None None] Exception during message handling: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched. 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher Traceback (most recent call last): 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 142, in _dispatch_and_reply 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher executor_callback)) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 186, in _dispatch 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher executor_callback) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/oslo_messaging/rpc/dispatcher.py", line 130, in _do_dispatch 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher result = func(ctxt, **new_args) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/plugins/ml2/rpc.py", line 118, in get_devices_details_list 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher for device in kwargs.pop('devices', []) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/plugins/ml2/rpc.py", line 95, in get_device_details 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher host) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 1255, in update_port_status 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher original_port['network_id']) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 642, in get_network 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher result = super(Ml2Plugin, self).get_network(context, id, None) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/db/db_base_plugin_v2.py", line 915, in get_network 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher network = self._get_network(context, id) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/db/db_base_plugin_v2.py", line 87, in _get_network 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher network = self._get_by_id(context, models_v2.Network, id) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/opt/stack/new/neutron/neutron/db/common_db_mixin.py", line 130, in _get_by_id 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher return query.filter(model.id == id).one() 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2398, in one 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher ret = list(self) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2440, in __iter__ 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher self.session._autoflush() 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1264, in _autoflush 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher self.flush() 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1985, in flush 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher self._flush(objects) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2103, in _flush 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher transaction.rollback(_capture_exception=True) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__ 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher compat.reraise(exc_type, exc_value, exc_tb) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2067, in _flush 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher flush_context.execute() 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher rec.execute(self) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher uow 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 60, in save_obj 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher mapper, table, update) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 536, in _emit_update_statements 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher (table.description, len(update), rows)) 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher StaleDataError: UPDATE statement on table 'ports' expected to update 1 row(s); 0 were matched. 2015-03-13 16:07:36.406 22946 TRACE oslo_messaging.rpc.dispatcher Looks like this just started spiking in the last 24 hours: http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiU3RhbGVEYXRhRXJyb3I6IFVQREFURSBzdGF0ZW1lbnQgb24gdGFibGUgJ3BvcnRzJyBleHBlY3RlZCB0byB1cGRhdGUgMSByb3cocyk7IDAgd2VyZSBtYXRjaGVkLlwiIEFORCB0YWdzOlwic2NyZWVuLXEtc3ZjLnR4dFwiIiwiZmllbGRzIjpbXSwib2Zmc2V0IjowLCJ0aW1lZnJhbWUiOiI2MDQ4MDAiLCJncmFwaG1vZGUiOiJjb3VudCIsInRpbWUiOnsidXNlcl9pbnRlcnZhbCI6MH0sInN0YW1wIjoxNDI2Mjg0NjA3MDUwfQ== To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1432065/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp