Deadlock found when trying to get lock

[Rabi Mishra]

Noticed at:

http://logs.openstack.org/28/469328/1/check/gate-heat-dsvm-functional-orig-mysql-lbaasv2-ubuntu-xenial/84c9a77/console.html#_2017-05-31_05_54_22_407042

traceback:

2017-05-31 05:54:22.381351 | 2017-05-31 05:54:22.380 | heat_integrationtests.functional.test_resource_group.ResourceGroupUpdatePolicyTest.test_resource_group_update_replace
2017-05-31 05:54:22.383052 | 2017-05-31 05:54:22.382 | ---------------------------------------------------------------------------------------------------------------------
2017-05-31 05:54:22.384848 | 2017-05-31 05:54:22.384 |
2017-05-31 05:54:22.386491 | 2017-05-31 05:54:22.386 | Captured traceback:
2017-05-31 05:54:22.387937 | 2017-05-31 05:54:22.387 | ~~~~~~~~~~~~~~~~~~~
2017-05-31 05:54:22.389487 | 2017-05-31 05:54:22.389 | Traceback (most recent call last):
2017-05-31 05:54:22.391200 | 2017-05-31 05:54:22.390 | File "/opt/stack/new/heat/heat_integrationtests/functional/test_resource_group.py", line 580, in test_resource_group_update_replace
2017-05-31 05:54:22.392771 | 2017-05-31 05:54:22.392 | deleted=10)
2017-05-31 05:54:22.394418 | 2017-05-31 05:54:22.394 | File "/opt/stack/new/heat/heat_integrationtests/functional/test_resource_group.py", line 528, in update_resource_group
2017-05-31 05:54:22.396052 | 2017-05-31 05:54:22.395 | self.update_stack(stack_identifier, update_template)
2017-05-31 05:54:22.397609 | 2017-05-31 05:54:22.397 | File "/opt/stack/new/heat/heat_integrationtests/common/test.py", line 426, in update_stack
2017-05-31 05:54:22.399149 | 2017-05-31 05:54:22.398 | self._wait_for_stack_status(**kwargs)
2017-05-31 05:54:22.400823 | 2017-05-31 05:54:22.400 | File "/opt/stack/new/heat/heat_integrationtests/common/test.py", line 357, in _wait_for_stack_status
2017-05-31 05:54:22.402304 | 2017-05-31 05:54:22.402 | fail_regexp):
2017-05-31 05:54:22.403789 | 2017-05-31 05:54:22.403 | File "/opt/stack/new/heat/heat_integrationtests/common/test.py", line 316, in _verify_status
2017-05-31 05:54:22.405277 | 2017-05-31 05:54:22.404 | stack_status_reason=stack.stack_status_reason)
2017-05-31 05:54:22.407042 | 2017-05-31 05:54:22.406 | heat_integrationtests.common.exceptions.StackBuildErrorException: Stack ResourceGroupUpdatePolicyTest-1181777200/cc67c349-1951-423a-9b7f-138c421d0551 is in UPDATE_FAILED status due to 'resources.random_group: (pymysql.err.InternalError) (1213, u'Deadlock found when trying to get lock; try restarting transaction') [SQL: u'DELETE FROM resource WHERE resource.id = %(id)s'] [parameters: {'id': 822}]'

[Thomas Herve (therve)]

Seen again here: http://logs.openstack.org/64/521064/3/check/heat-functional-convg-mysql-lbaasv2/f96c950/job-output.txt.gz

[Zane Bitter (zaneb)]

A similar fix to bug 1732969 would probably do the trick.