[Openstack] HEAT and MySQL 5.6

Clint Dilks clintd at waikato.ac.nz
Wed May 21 00:22:55 UTC 2014


Hi Clint, thanks for the response.

No, in researching the issue, I found that all of these columns should be
> varchar(64). I seem to have lost track of the patches though. We should
> definitely fix this in juno, since MySQL 5.6 is starting to arrive in
> the distros.
>

It looks like I have bigger database issues in relation to heat

from /var/log/heat/heat-engine.log

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, 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.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,
stack.idDESC' ()
2014-05-21 10:46:59.779 9518 TRACE heat.openstack.common.threadgroup

Currently my stack

mysql> describe stack ;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id               | varchar(36)  | NO   | PRI | NULL    |       |
| created_at       | datetime     | YES  |     | NULL    |       |
| updated_at       | datetime     | YES  |     | NULL    |       |
| name             | varchar(255) | YES  |     | NULL    |       |
| raw_template_id  | int(11)      | NO   | MUL | NULL    |       |
| user_creds_id    | int(11)      | NO   | MUL | NULL    |       |
| username         | varchar(256) | YES  |     | NULL    |       |
| owner_id         | varchar(36)  | YES  |     | NULL    |       |
| status           | varchar(255) | YES  |     | NULL    |       |
| status_reason    | varchar(255) | YES  |     | NULL    |       |
| parameters       | longtext     | YES  |     | NULL    |       |
| timeout          | int(11)      | YES  |     | NULL    |       |
| tenant           | varchar(256) | YES  |     | NULL    |       |
| disable_rollback | tinyint(1)   | NO   |     | NULL    |       |
| action           | varchar(255) | YES  |     | NULL    |       |
| deleted_at       | datetime     | YES  |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
16 rows in set (0.00 sec)

Does anyone have any suggestions as to how I get a working heat database?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140521/de2ea161/attachment.html>


More information about the Openstack mailing list