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?
_______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
