[Openstack] HEAT and MySQL 5.6

Clint Dilks clintd at waikato.ac.nz
Tue May 20 21:30:40 UTC 2014


Hi,

I seem to be hitting a known issue with HEAT MySQL 5.6 and UTF8

ERROR: (OperationalError) (1071, 'Specified key was too long; max key
length is 767 bytes') 'CREATE INDEX ix_software_config_tenant ON
software_config (tenant)' ()

So based off https://bugs.launchpad.net/heat/+bug/1316646 I have made the
following modifications to the heat database.

mysql> alter table software_config modify column tenant varchar(64) NOT
NULL;

mysql> CREATE INDEX ix_software_config_tenant ON software_config (tenant);

Is reducing the size of the tenant column likely to cause issues later?

Thanks :)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20140521/1d41a21b/attachment.html>


More information about the Openstack mailing list