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

Adam Gandelman adamg at canonical.com
Wed Jul 11 17:23:48 UTC 2012


On 07/11/2012 09:11 AM, Sean Dague wrote:
> 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
>

Addressed upstream by https://bugs.launchpad.net/nova/+bug/993663, fixed 
in Ubuntu 12.04 as of nova 2012.1+stable~20120612-3ee026e-0ubuntu1.   
Hopefully installing the Ubuntu update helps with the original poster's 
issues.

Adam

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-operators/attachments/20120711/9c2733ef/attachment.html>


More information about the Openstack-operators mailing list