<div dir="ltr"><br><div class="gmail_extra">Hi Clint, thanks for the response.<br></div><div class="gmail_extra"><div class="gmail_quote"><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
No, in researching the issue, I found that all of these columns should be<br>
varchar(64). I seem to have lost track of the patches though. We should<br>
definitely fix this in juno, since MySQL 5.6 is starting to arrive in<br>
the distros.<br></blockquote></div><br></div><div class="gmail_extra">It looks like I have bigger database issues in relation to heat<br><br></div><div class="gmail_extra">from /var/log/heat/heat-engine.log<br><br>2014-05-21 10:46:59.779 9518 TRACE heat.openstack.common.threadgroup OperationalError: (OperationalError) (1054, "Unknown column 'stack.stack_user_project_id' in 'field list'") 'SELECT stack.created_at AS stack_created_at, stack.deleted_at AS stack_deleted_at, <a href="http://stack.id">stack.id</a> AS stack_id, <a href="http://stack.name">stack.name</a> AS stack_name, stack.raw_template_id AS stack_raw_template_id, stack.username AS stack_username, stack.tenant AS stack_tenant, stack.action AS stack_action, stack.status AS stack_status, stack.status_reason AS stack_status_reason, 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 \nFROM stack \nWHERE stack.deleted_at IS NULL AND stack.owner_id IS NULL ORDER BY stack.created_at DESC, <a href="http://stack.id">stack.id</a> DESC' ()<br>
2014-05-21 10:46:59.779 9518 TRACE heat.openstack.common.threadgroup <br><br></div><div class="gmail_extra">Currently my stack <br></div><div class="gmail_extra"><br>mysql> describe stack ;<br>+------------------+--------------+------+-----+---------+-------+<br>
| Field            | Type         | Null | Key | Default | Extra |<br>+------------------+--------------+------+-----+---------+-------+<br>| id               | varchar(36)  | NO   | PRI | NULL    |       |<br>| created_at       | datetime     | YES  |     | NULL    |       |<br>
| updated_at       | datetime     | YES  |     | NULL    |       |<br>| name             | varchar(255) | YES  |     | NULL    |       |<br>| raw_template_id  | int(11)      | NO   | MUL | NULL    |       |<br>| user_creds_id    | int(11)      | NO   | MUL | NULL    |       |<br>
| username         | varchar(256) | YES  |     | NULL    |       |<br>| owner_id         | varchar(36)  | YES  |     | NULL    |       |<br>| status           | varchar(255) | YES  |     | NULL    |       |<br>| status_reason    | varchar(255) | YES  |     | NULL    |       |<br>
| parameters       | longtext     | YES  |     | NULL    |       |<br>| timeout          | int(11)      | YES  |     | NULL    |       |<br>| tenant           | varchar(256) | YES  |     | NULL    |       |<br>| disable_rollback | tinyint(1)   | NO   |     | NULL    |       |<br>
| action           | varchar(255) | YES  |     | NULL    |       |<br>| deleted_at       | datetime     | YES  |     | NULL    |       |<br>+------------------+--------------+------+-----+---------+-------+<br>16 rows in set (0.00 sec)<br>
<br></div><div class="gmail_extra">Does anyone have any suggestions as to how I get a working heat database?<br><br></div></div>