I looked at whether or not we could port the change from Glance into Heat, but
it turns out that's not going to be easy: because Heat from Havana -> Icehouse
creates several new tables, all explicitly set to utf8, these upgrade steps
will fail with an error along the lines of:
I looked at whether or not we could port the change from Glance into Heat, but
it turns out that's not going to be easy: because Heat from Havana -> Icehouse
creates several new tables, all explicitly set to utf8, these upgrade steps
will fail with an error along the lines of:
ERROR: (OperationalError) (1005, "Can't create table 'heat.stack_lock' ENGINE= InnoDB CHARSET=utf8\n\n'
(errno: 150)") '\nCREATE TABLE stack_lock (\n\tstack_id VARCHAR(36)
NOT NULL, \n\tcreated_at DATETIME, \n\tupdated_at DATETIME,
\n\tengine_id VARCHAR(36), \n\tPRIMARY KEY (stack_id), \n\tFOREIGN
KEY(stack_id) REFERENCES stack (id)\n)
()
This happens when there is a foreign key reference from one of these
utf8 tables to a latin1 table.