functional.test_validation.StackValidationTest.test_stack_validate_provider_references_parent_resource

[Rabi Mishra]

It seems we're trying to delete a stack (as part of test teardown) which is IN_PROGRESS and it's raising the below error.

http://logs.openstack.org/85/232285/1/check/gate-heat-dsvm-functional-orig-mysql/b3fffdf/console.html#_2015-10-08_00_59_02_480

http://logs.openstack.org/85/232285/1/check/gate-heat-dsvm-functional-orig-mysql/b3fffdf/logs/screen-h-eng.txt.gz?#_2015-10-08_00_52_08_718

heat_integrationtests.functional.test_validation.StackValidationTest.test_stack_validate_provider_references_parent_resource
2015-10-08 00:59:02.462 | 2015-10-08 00:59:02.444 | ----------------------------------------------------------------------------------------------------------------------------
2015-10-08 00:59:02.462 | 2015-10-08 00:59:02.445 |
2015-10-08 00:59:02.462 | 2015-10-08 00:59:02.447 | Captured traceback:
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.448 | ~~~~~~~~~~~~~~~~~~~
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.450 | Traceback (most recent call last):
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.451 | File "heat_integrationtests/common/test.py", line 325, in _stack_delete
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.452 | self.client.stacks.delete(stack_identifier)
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.454 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/v1/stacks.py", line 162, in delete
2015-10-08 00:59:02.463 | 2015-10-08 00:59:02.455 | self._delete("/stacks/%s" % stack_id)
2015-10-08 00:59:02.464 | 2015-10-08 00:59:02.456 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/openstack/common/apiclient/base.py", line 224, in _delete
2015-10-08 00:59:02.464 | 2015-10-08 00:59:02.457 | return self.client.delete(url)
2015-10-08 00:59:02.464 | 2015-10-08 00:59:02.459 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/common/http.py", line 293, in delete
2015-10-08 00:59:02.465 | 2015-10-08 00:59:02.460 | return self.raw_request("DELETE", url, **kwargs)
2015-10-08 00:59:02.477 | 2015-10-08 00:59:02.462 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/common/http.py", line 274, in raw_request
2015-10-08 00:59:02.478 | 2015-10-08 00:59:02.463 | return self._http_request(url, method, **kwargs)
2015-10-08 00:59:02.478 | 2015-10-08 00:59:02.464 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/common/http.py", line 228, in _http_request
2015-10-08 00:59:02.478 | 2015-10-08 00:59:02.465 | resp = self._http_request(path, method, **kwargs)
2015-10-08 00:59:02.478 | 2015-10-08 00:59:02.467 | File "/opt/stack/new/heat/.tox/integration/local/lib/python2.7/site-packages/heatclient/common/http.py", line 221, in _http_request
2015-10-08 00:59:02.478 | 2015-10-08 00:59:02.469 | raise exc.from_response(resp)
2015-10-08 00:59:02.480 | 2015-10-08 00:59:02.470 | heatclient.exc.HTTPInternalServerError: ERROR: Failed to stop stack (StackValidationTest-1090076916) on other engine (14a8fbfe-14ff-4ee4-b4fe-3167bf3b03d8)

[Rabi Mishra (rabi)]

I'm seeing the following in the logs.

DB error This result object does not return rows. It has been closed automatically.
OperationalError: (2014, 'Command Out of Sync')

http://logs.openstack.org/61/236161/3/gate/gate-heat-dsvm-functional-orig-mysql/54a34fd/logs/screen-h-eng.txt.gz?#_2015-10-21_05_13_41_452

http://logs.openstack.org/45/234445/4/check/gate-heat-dsvm-functional-orig-mysql/79eb6da/logs/screen-h-eng.txt.gz#_2015-10-14_22_12_57_739

Looks like mysql connection gets to bad state somehow.