[Openstack] HEAT and MySQL 5.6

Clint Byrum clint at fewbar.com
Tue May 20 22:45:35 UTC 2014

Excerpts from Clint Dilks's message of 2014-05-20 14:30:40 -0700:
> 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
> mysql> CREATE INDEX ix_software_config_tenant ON software_config (tenant);
> Is reducing the size of the tenant column likely to cause issues later?

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.

More information about the Openstack mailing list