queens heat db deadlock

Ignazio Cassano ignaziocassano at gmail.com
Thu Dec 13 15:06:51 UTC 2018


Hi All,
I installed queens on centos 7.
Heat seems to work fine with templates I wrote but when I create magnum
cluster
I often face with db deadlock in heat-engine log:

2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource Traceback (most
recent call last):
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/resource.py", line 918, in
_action_recorder
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     yield
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/resource.py", line 2035, in
delete
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     *action_args)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/scheduler.py", line 346, in
wrapper
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     step =
next(subtask)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/resource.py", line 977, in
action_handler_task
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     done =
check(handler_data)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/resources/stack_resource.py",
line 587, in check_delete_complete
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     return
self._check_status_complete(self.DELETE)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource   File
"/usr/lib/python2.7/site-packages/heat/engine/resources/stack_resource.py",
line 454, in _check_status_complete
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource     action=action)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource ResourceFailure:
resources[0]: (pymysql.err.InternalError) (1213, u'Deadlock found when
trying to get lock; try restarting transaction') (Background on this error
at: http://sqlalche.me/e/2j85)
2018-12-13 11:48:46.016 89597 ERROR heat.engine.resource
2018-12-13 11:48:46.030 89597 INFO heat.engine.stack
[req-9a43184f-77d8-4fad-ab9e-2b9826c10b70 - admin - default default] Stack
DELETE FAILED
(swarm-clustergp27-ebhsalhb4bop-swarm_primary_master-tzgkh3ncmymw):
Resource DELETE failed: resources[0]: (pymysql.err.InternalError) (1213,
u'Deadlock found when trying to get lock; try restarting transaction')
(Background on this error at: http://sqlalche.me/e/2j85)
2018-12-13 11:48:46.844 89595 INFO heat.engine.resource
[req-9a43184f-77d8-4fad-ab9e-2b9826c10b70 - admin - default default]
DELETE: ResourceGroup "swarm_primary_master"
[6984db3c-3ac1-4afc-901f-21b3e7f230a7] Stack
"swarm-clustergp27-ebhsalhb4bop" [b43256fa-52e2-4613-ac15-63fd9340a8be]


I read this issue was solved in heat version 10 but seems not.

Regards
Ignazio
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20181213/15933d9d/attachment.html>


More information about the openstack-discuss mailing list