Hi Calvin, Thank you for the reply. It solved the "db sync" issue. But soon after this, the nova-compute daemons started throwing the following trace.
2013-04-30 15:53:21 TRACE nova OperationalError: (OperationalError) (1054, "Unknown column 'instance_metadata_1.instance_id' in 'field list'") When I checked the instance_metatdata table, I found that it has "instance_uuid" as a field and not "instance_id". It seems to be another issue with db sync. Suggestions? -- Shashank Sahni On Tue, Apr 30, 2013 at 2:32 AM, Calvin Walton <calvin.wal...@kepstin.ca>wrote: > On Mon, 2013-04-29 at 20:16 +0530, Shashank Sahni wrote: > > 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. > > This is due to a bug in one version of the Ubuntu package that included > a broken database migration; it had a foreign key on a latin-1 table > (dns_domains) referencing a text column on a utf-8 table (projects), > which mysql does not support. As a result, a *later* migration that > changed the projects table partially failed, and left the table in a > half-created state. > > I ran into this problem, and the only way I found to *fix* the error was > to dump the database to a sql file, drop the entire database, manually > edit the dump file to correct the referencing table charset on the > 'dns_domains' table, add the definition for the projects table back, > then restore the database from the dump. > > Related issues on launchpad: > https://bugs.launchpad.net/nova/+bug/993663 > https://bugs.launchpad.net/ubuntu/+source/nova/+bug/975085 > > Amusingly, if you're using keystone, the 'projects' table is actually > not used by anything, but it still has to exist. > > -- > Calvin Walton <calvin.wal...@kepstin.ca> >
_______________________________________________ Mailing list: https://launchpad.net/~openstack Post to : openstack@lists.launchpad.net Unsubscribe : https://launchpad.net/~openstack More help : https://help.launchpad.net/ListHelp