neutron

Lock wait timeout adding ipallocation

Bug #1334228 reported by Eugene Nikanorov
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
neutron
Expired
Medium
Unassigned

Bug Description

Traceback:

 TRACE neutron.api.v2.resource Traceback (most recent call last):
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 87, in resource
 TRACE neutron.api.v2.resource result = method(request=request, **args)
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 199, in _handle_action
 TRACE neutron.api.v2.resource return getattr(self._plugin, name)(*arg_list, **kwargs)
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/db/l3_db.py", line 476, in add_router_interface
 TRACE neutron.api.v2.resource context, router_id, interface_info['subnet_id'], device_owner)
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/db/l3_db.py", line 465, in _add_interface_by_subnet
 TRACE neutron.api.v2.resource 'name': ''}})
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/plugins/ml2/plugin.py", line 644, in create_port
 TRACE neutron.api.v2.resource result = super(Ml2Plugin, self).create_port(context, port)
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/db/db_base_plugin_v2.py", line 1464, in create_port
 TRACE neutron.api.v2.resource context.session.add(allocated)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 463, in __exit__
 TRACE neutron.api.v2.resource self.rollback()
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
 TRACE neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 460, in __exit__
 TRACE neutron.api.v2.resource self.commit()
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 370, in commit
 TRACE neutron.api.v2.resource self._prepare_impl()
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 350, in _prepare_impl
 TRACE neutron.api.v2.resource self.session.flush()
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/openstack/common/db/sqlalchemy/session.py", line 439, in _wrap
 TRACE neutron.api.v2.resource return f(self, *args, **kwargs)
 TRACE neutron.api.v2.resource File "/opt/stack/new/neutron/neutron/openstack/common/db/sqlalchemy/session.py", line 705, in flush
 TRACE neutron.api.v2.resource return super(Session, self).flush(*args, **kwargs)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1907, in flush
 TRACE neutron.api.v2.resource self._flush(objects)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2025, in _flush
 TRACE neutron.api.v2.resource transaction.rollback(_capture_exception=True)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 57, in __exit__
 TRACE neutron.api.v2.resource compat.reraise(exc_type, exc_value, exc_tb)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1989, in _flush
 TRACE neutron.api.v2.resource flush_context.execute()
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 371, in execute
 TRACE neutron.api.v2.resource rec.execute(self)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 524, in execute
 TRACE neutron.api.v2.resource uow
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
 TRACE neutron.api.v2.resource mapper, table, insert)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 568, in _emit_insert_statements
 TRACE neutron.api.v2.resource execute(statement, multiparams)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 727, in execute
 TRACE neutron.api.v2.resource return meth(self, multiparams, params)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
 TRACE neutron.api.v2.resource return connection._execute_clauseelement(self, multiparams, params)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 824, in _execute_clauseelement
 TRACE neutron.api.v2.resource compiled_sql, distilled_params
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 954, in _execute_context
 TRACE neutron.api.v2.resource context)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1116, in _handle_dbapi_exception
 TRACE neutron.api.v2.resource exc_info
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 189, in raise_from_cause
 TRACE neutron.api.v2.resource reraise(type(exception), exception, tb=exc_tb)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 947, in _execute_context
 TRACE neutron.api.v2.resource context)
 TRACE neutron.api.v2.resource File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 435, in do_execute
 TRACE neutron.api.v2.resource cursor.execute(statement, parameters)
 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2014-06-24 07:03:04.134 27768 TRACE neutron.api.v2.resource self.errorhandler(self, exc, value)
2014-06-24 07:03:04.134 27768 TRACE neutron.api.v2.resource File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2014-06-24 07:03:04.134 27768 TRACE neutron.api.v2.resource raise errorclass, errorvalue
2014-06-24 07:03:04.134 27768 TRACE neutron.api.v2.resource OperationalError: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') 'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%s, %s, %s, %s)' ('d7b2de07-dda5-4fc7-a37f-04bee4fd7c97', '10.100.0.1', '7a1242cf-aa63-4474-b1da-c757488df995', '7646373a-770c-4a60-a835-2ad636e5fb8e')

http://logs.openstack.org/09/102109/2/check/check-tempest-dsvm-neutron-full/40fa19b/logs/screen-q-svc.txt.gz?level=TRACE#_2014-06-24_07_03_04_134

Eugene Nikanorov (enikanorov)
Changed in neutron:
importance: High → Medium
Revision history for this message
Eugene Nikanorov (enikanorov) wrote :

Moving to inclomplete. This issue was not seen for more than a month and some fixes were made to prevent deadlocks caused by rpc calls within transaction.

Changed in neutron:
status: New → Incomplete
Revision history for this message
Launchpad Janitor (janitor) wrote :

[Expired for neutron because there has been no activity for 60 days.]

Changed in neutron:
status: Incomplete → Expired
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.