[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