[Openstack-operators] nova.projects mysql table getting lost almost *every* day!
sdague at linux.vnet.ibm.com
Wed Jul 11 16:11:24 UTC 2012
On 07/11/2012 11:52 AM, erkan yanar wrote:
> Sorry to jump in.
> Im just joined the list.
> It the table projects is there. The table dns_domains makes it 'vanish'.
> The table dns_domains is still latin1 while havin a FK-constraint to projects (utf8).
> Changing dns_domais to utf8 make your projects-table appear again.
> Take care to i.e.
> ALTER TABLE dns_domains modify `domain` varchar(255) character set utf8 NOT NULL;
> As a key over 512 utf8 chars exceeds the limitation for a single key in innodb.
Is this still an issue upstream? It would be good to get a bug / fix in
for folsom if it is.
IBM Linux Technology Center
email: sdague at linux.vnet.ibm.com
alt-email: sldague at us.ibm.com
More information about the Openstack-operators