Comment 6 for bug 1301036

Revision history for this message
Lars Kellogg-Stedman (larsks) wrote :

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'
  (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)ENGINE=InnoDB CHARSET=utf8\n\n'
  ()

This happens when there is a foreign key reference from one of these
utf8 tables to a latin1 table.