Updating of instance metadata occasionally leads to a Database deadlock
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Expired
|
Undecided
|
Unassigned |
Bug Description
During the tempest tests run I got the following error:
2013-11-13 10:09:18.814 ERROR nova.api.openstack [req-a3172f97-
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack Traceback (most recent call last):
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return req.get_
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack application, catch_exc_
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack app_iter = application(
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return resp(environ, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return self.app(env, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return resp(environ, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return resp(environ, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/lib/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack response = self.app(environ, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return resp(environ, start_response)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack resp = self.call_func(req, *args, **self.kwargs)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return self.func(req, *args, **kwargs)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack content_type, body, accept)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack action_result = self.dispatch(meth, request, action_args)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return method(req=request, **action_args)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack delete=False)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack delete)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return func(self, context, target, *args, **kwargs)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return function(self, context, instance, *args, **kwargs)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return f(self, context, instance, *args, **kw)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack _metadata, True)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack metadata, delete)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return f(*args, **kwargs)
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack return metadata
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack self.commit()
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack self._prepare_
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/usr/local/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack self.session.
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack _raise_
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack File "/opt/stack/
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack raise exception.
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack DBDeadlock: (OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') 'INSERT INTO instance_metadata (created_at, updated_at, deleted_at, deleted, `key`, value, instance_uuid) VALUES (%s, %s, %s, %s, %s, %s, %s)' (datetime.
2013-11-13 10:09:18.814 22804 TRACE nova.api.openstack
not a tempest bug