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 <[email protected]> wrote: > This is a MYsql DB issue, you can try to restart MYsql if possible. > > > 2013/4/29 Shashank Sahni <[email protected]> > >> 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 : [email protected] >> 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 > >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : [email protected] Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp
