[Openstack-operators] nova.projects mysql table getting lost almost *every* day!

Sean Dague sdague at linux.vnet.ibm.com
Wed Jul 11 16:11:24 UTC 2012


On 07/11/2012 11:52 AM, erkan yanar wrote:
> Hi,
> 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.

	-Sean

-- 
Sean Dague
IBM Linux Technology Center
email: sdague at linux.vnet.ibm.com
alt-email: sldague at us.ibm.com





More information about the Openstack-operators mailing list