Lock wait timeout exceeded; try restarting transaction in Nova logs
Bug #1394264 reported by
Ilya Shakhat
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mirantis OpenStack |
Fix Released
|
High
|
Pavel Kholkin |
Bug Description
After Rally test execution Nova log contain a lot of "Lock wait timeout exceeded; try restarting transaction" error messages.
VERSION:
feature_groups:
- mirantis
production: "docker"
release: "6.0"
api: "1.0"
build_number: "110"
build_id: "2014-11-
astute_sha: "8e05026cf17aeb
fuellib_sha: "4c080377d5d1f4
ostf_sha: "82465a94eed4ef
nailgun_sha: "3e98ea8a042b43
fuelmain_sha: "137d944d4a658e
Changed in mos: | |
status: | New → Triaged |
importance: | Undecided → High |
assignee: | nobody → Pavel Kholkin (pkholkin) |
milestone: | none → 6.1 |
Changed in mos: | |
status: | Triaged → In Progress |
Changed in mos: | |
milestone: | 6.1 → 6.0 |
To post a comment you must log in.
Nova log: 19T03:06: 17.213468+ 00:00 debug: 192.168. 0.2:9696/ v2.0/quotas/ 6997646ffb644bb 69c9d1ac01836ac 68.json -X GET -H "X-Auth-Token: 631b39b5a31644c 4a78830a8aa neutronclient" 19T03:06: 17.269463+ 00:00 debug: RESP:200 CaseInsensitive Dict({' date': 'Wed, 19 Nov 2014 03:06:17 GMT', 'content-length': '134', ' request- id': 'req-b3e568e9- 6d19-40e1- be93-b81eae0927 4e'}) {"quota": {"subne group_rule" : 100, "security_group": 10, "router": 10, "port": 50}} 19T03:06: 17.290766+ 00:00 err: Caught error: (OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction') ' deleted_ at AS quota_usages_ deleted_ at, quota_usages. deleted AS quota_usages_ deleted, quota_usages. created_ at AS quota_ updated_ at AS quota_usages_ updated_ at, quota_usages.id AS quota_usages_id, quota_usages. project_ id AS quota_usages_ project_ id, quota_usages. user_id AS quota_usages_ user_id, quota_usages. resource AS quota_usages_ resource, quota_usages.in_use AS quota_usages_ in_use, quota_usages. reserved AS quota_usages_ reserved, quota_usages. until_refresh AS quota_usages_ until_refresh \nFROM quota_usages \nWHERE quota_usages. deleted = %s AND quota_usages. project_ id = %s FOR UPDATE' (0, '638d3d20992046 e0a963e33ebd61c 48d') python2. 7/dist- packages/ nova/api/ openstack/ __init_ _.py", line 124, in __call__ response( self.applicatio n) python2. 7/dist- packages/ webob/request. py", line 1320, in send info=False) python2. 7/dist- packages/ webob/request. py", line 1284, in call_application self.environ, start_response) python2. 7/dist- packages/ webob/dec. py", line 144, in __call__ python2. 7/dist- packages/ keystonemiddlew are/auth_ token.py" , line 748, in __call__ python2. 7/dist- packages/ keystonemiddlew are/auth_ token.py" , line 684, in _call_app response) python2. 7/dist- packages/ webob/dec. py", line 144, in __call__
2014-11-
REQ: curl -i http://
8ef53b" -H "User-Agent: python-
2014-11-
content-type': 'application/json; charset=UTF-8', 'x-openstack-
t": 10, "network": 10, "floatingip": 50, "security_
2014-11-
SELECT quota_usages.
usages_created_at, quota_usages.
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack Traceback (most recent call last):
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack return req.get_
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack application, catch_exc_
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack app_iter = application(
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack return resp(environ, start_response)
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack return self._call_app(env, start_response)
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack return self._app(env, _fake_start_
2014-11-19 03:06:17.273 20180 TRACE nova.api.openstack File "/usr/lib/
2014-11-19 03:06:17.273 20180 TRACE nova.api.o...