[Openstack] Failed "db sync" while upgrading from essex to folsom

Shashank Sahni shredder12 at gmail.com
Mon Apr 29 17:45:12 UTC 2013


Hello Yaguang,

Thanks for your response, but no luck :( This table, projects, and related
ones - users, user_project_association etc. seem to be skeleton from the
time authentication service was a part of nova. The related tables are all
empty. I tried to delete it, but got "table doesn't exist" error. Although,
the .frm file exists in /var/lib/mysql. Something seems to have gone wrong
with InnoDB.

--
Shashank Sahni


On Mon, Apr 29, 2013 at 9:29 PM, Yaguang Tang <heut2008 at gmail.com> wrote:

> This is a MYsql DB issue, you can try to restart MYsql if possible.
>
>
> 2013/4/29 Shashank Sahni <shredder12 at gmail.com>
>
>> Hi everyone,
>>
>> I'm having some trouble upgrading from essex to folsom. The cloud is
>> currently running on Ubuntu 12.04. For the upgrade, I included the folsom
>> repo(ubuntu cloud archive) and upgraded the packages. Things went fine
>> until I issued "nova-manage db sync". It failed with the following error.
>>
>> 2013-04-29 20:13:50 23254 TRACE nova     raise
>> exc.NoSuchTableError(full_name)
>> 2013-04-29 20:13:50 23254 TRACE nova NoSuchTableError: `projects`
>>
>> Ironically, the table exists. But I get the same message accessing it
>> through mysql console.
>>
>> Any suggestions?
>>
>> --
>> Shashank Sahni
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openstack
>> Post to     : openstack at lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~openstack
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Tang Yaguang
>
> Canonical Ltd. | www.ubuntu.com | www.canonical.com
> Mobile:  +86 152 1094 6968
> gpg key: 0x187F664F
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack/attachments/20130429/1abe4897/attachment.html>


More information about the Openstack mailing list