<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 22/10/14 11:56, Ken Thomas wrote:<br>
</div>
<blockquote
cite="mid:1499152.409013.1413932198437.JavaMail.yahoo@jws100153.mail.ne1.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:16px">
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">Greetings
all,</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">I'm using
Heat from Icehouse and I'm hitting a problem that I'm hoping
y'all can shed some light on.</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">I have no
problems doing stack-create. I can watch the MySQL commands go
by and see it happily update the stack table so that it
eventually shows up as CREATE_COMPLETE. When I delete the
stack, everything seems to be working fine. I see the MySQL
update that sets the stack to DELETE IN PROGRESS as well as
the updates that sets my single resource to DELETE_COMPLETE...
but I never see the final update to the stack table to set it
to DELETE COMPLETE.</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">One very
odd thing that I found in the MySQL logs (snippet below), is a
query that includes that stack name but with an extra '*'
character append to it. My stack is named 'xyzzy8' but notice
the 'xzyzzy8*' in the constraint. That's not going to return
anything and I'm wondering if that is what's preventing the
final stack DELETE_COMPLTE update from happening? </div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">There are
no errors in the any of the heat logs.</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">Any
guidance would be greatly appreciated!<br class="" style="">
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">Ken</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr"><br>
</div>
<div class="" style="" id="yui_3_16_0_1_1413927637252_11380">SELECT
stack.status_reason AS stack_status_reason, stack.created_at
AS stack_created_at, stack.deleted_at AS stack_deleted_at,
stack.action AS stack_action, stack.status AS stack_status,
stack.id AS stack_id, stack.name AS stack_name,
stack.raw_template_id AS stack_raw_template_id, stack.username
AS stack_username, stack.tenant AS stack_tenant,
stack.parameters AS stack_parameters, stack.user_creds_id AS
stack_user_creds_id, stack.owner_id AS stack_owner_id,
stack.timeout AS stack_timeout, stack.disable_rollback AS
stack_disable_rollback, stack.stack_user_project_id AS
stack_stack_user_project_id, stack.updated_at AS
stack_updated_at</div>
<div class="" style="" id="yui_3_16_0_1_1413927637252_11381">FROM
stack</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr">
</div>
<div class="" style="" id="yui_3_16_0_1_1413927637252_11382">WHERE
stack.deleted_at IS NULL AND (stack.tenant =
'c6c488223aae4e97bf56dda8cef36b3b' OR
stack.stack_user_project_id =
'c6c488223aae4e97bf56dda8cef36b3b') AND stack.name = <b
id="yui_3_16_0_1_1413927637252_11405">'xyzzy8*</b>' AND
stack.owner_id = '9a3e56d7-0c10-4c1c-8c54-0e5580cee121'</div>
<div id="yui_3_16_0_1_1413927637252_11262" dir="ltr" class=""
style=""><br class="" style="">
</div>
</div>
<br>
</blockquote>
(This is a usage question, so replying to the openstack list)<br>
<br>
Seeing 'xzyzzy8*' is odd. I'm not aware of anything in the code
which would cause this. It would be more useful for you to scan your
heat-engine log for any errors occurring during the stack delete.<br>
</body>
</html>