All parts involving indexes and foreign keys in revision 185 failed. I had to create them by hand and in some cases I wasn't able to drop foreign keys or indexes... gave error 150 and 152.
I could (maybe) restore a backup of that mysql database tomorrow and try the db sync again but I'm not sure I have a backup since it's the lab of the lab I'm using. Dave -----Original Message----- From: mikalst...@gmail.com [mailto:mikalst...@gmail.com] On Behalf Of Michael Still Sent: October-27-13 7:39 PM To: David Hill Cc: Blair Zajac; openstack@lists.openstack.org Subject: Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop index 'instance_uuid' These sound like bugs worth filing... Is it too late to get a list of tables / indexes you had problems with? Michael On Mon, Oct 28, 2013 at 10:34 AM, David Hill <david.h...@ubisoft.com> wrote: > Hi guys, > > I experienced the same issue while upgrading from Grizzly to Havana > ... I had to create manually some indexes before it could drop them! :( > > Dave > > > -----Original Message----- > From: Michael Still [mailto:mi...@stillhq.com] > Sent: October-27-13 6:06 PM > To: Blair Zajac > Cc: openstack@lists.openstack.org > Subject: Re: [Openstack] Grizzly -> Havana nova upgrade failure: Cannot drop > index 'instance_uuid' > > Can you run this against your nova mysql database and let us know the result? > > show create table instance_info_caches \G > > Thanks, > Michael > > On Sun, Oct 27, 2013 at 7:58 PM, Blair Zajac <bl...@orcaware.com> wrote: >> Hello, >> >> I was running Ubuntu 13.04 and upgraded tonight to 13.10. I was running the >> Ubuntu Precise 1:2013.1.3-0ubuntu1.1 on 13.04 and am now on 13.10's provided >> 1:2013.2~rc2-0ubuntu1. >> >> After getting the box up, migrating the nova database failed with the below >> error. I am using MySQL. >> >> Suggestions on how to fix this? >> >> Thanks, >> Blair >> >> >> # nova-manage -v db sync >> 2013-10-27 01:47:03.615 24457 INFO migrate.versioning.api [-] 161 -> 162... >> 2013-10-27 01:47:03.673 24457 INFO migrate.versioning.api [-] done >> ... >> ... >> 2013-10-27 01:47:16.373 24457 INFO migrate.versioning.api [-] 184 -> 185... >> Command failed, please check log for more info >> 2013-10-27 01:47:17.835 24457 CRITICAL nova [-] (OperationalError) (1553, >> "Cannot drop index 'instance_uuid': needed in a foreign key constraint") >> 'ALTER TABLE instance_info_caches DROP INDEX instance_uuid' () >> 2013-10-27 01:47:17.835 24457 TRACE nova Traceback (most recent call last): >> 2013-10-27 01:47:17.835 24457 TRACE nova File "/usr/bin/nova-manage", line >> 10, in <module> >> 2013-10-27 01:47:17.835 24457 TRACE nova sys.exit(main()) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 1377, in main >> 2013-10-27 01:47:17.835 24457 TRACE nova ret = fn(*fn_args, **fn_kwargs) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/cmd/manage.py", line 885, in sync >> 2013-10-27 01:47:17.835 24457 TRACE nova return >> migration.db_sync(version) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 33, in db_sync >> 2013-10-27 01:47:17.835 24457 TRACE nova return >> IMPL.db_sync(version=version) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 75, >> in db_sync >> 2013-10-27 01:47:17.835 24457 TRACE nova return >> versioning_api.upgrade(get_engine(), repository, version) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in >> upgrade >> 2013-10-27 01:47:17.835 24457 TRACE nova return _migrate(url, >> repository, version, upgrade=True, err=err, **opts) >> 2013-10-27 01:47:17.835 24457 TRACE nova File "<string>", line 2, in >> _migrate >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 40, >> in patched_with_engine >> 2013-10-27 01:47:17.835 24457 TRACE nova return f(*a, **kw) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in >> _migrate >> 2013-10-27 01:47:17.835 24457 TRACE nova schema.runchange(ver, change, >> changeset.step) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in >> runchange >> 2013-10-27 01:47:17.835 24457 TRACE nova change.run(self.engine, step) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line >> 145, in run >> 2013-10-27 01:47:17.835 24457 TRACE nova script_func(engine) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/185_rename_unique_constraints.py", >> line 129, in upgrade >> 2013-10-27 01:47:17.835 24457 TRACE nova return >> _uc_rename(migrate_engine, upgrade=True) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/185_rename_unique_constraints.py", >> line 112, in _uc_rename >> 2013-10-27 01:47:17.835 24457 TRACE nova old_name, *(columns)) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/utils.py", line 197, in >> drop_unique_constraint >> 2013-10-27 01:47:17.835 24457 TRACE nova uc.drop() >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/constraint.py", line 59, >> in drop >> 2013-10-27 01:47:17.835 24457 TRACE nova >> self.__do_imports('constraintdropper', *a, **kw) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/constraint.py", line 32, >> in __do_imports >> 2013-10-27 01:47:17.835 24457 TRACE nova run_single_visitor(engine, >> visitorcallable, self, *a, **kw) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/databases/visitor.py", >> line 75, in run_single_visitor >> 2013-10-27 01:47:17.835 24457 TRACE nova fn(element, **kwargs) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 272, >> in visit_migrate_unique_constraint >> 2013-10-27 01:47:17.835 24457 TRACE nova self._visit_constraint(*p, **k) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 284, >> in _visit_constraint >> 2013-10-27 01:47:17.835 24457 TRACE nova self.execute() >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 42, in >> execute >> 2013-10-27 01:47:17.835 24457 TRACE nova return >> self.connection.execute(self.buffer.getvalue()) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 662, in >> execute >> 2013-10-27 01:47:17.835 24457 TRACE nova params) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 805, in >> _execute_text >> 2013-10-27 01:47:17.835 24457 TRACE nova statement, parameters >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 874, in >> _execute_context >> 2013-10-27 01:47:17.835 24457 TRACE nova context) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1024, in >> _handle_dbapi_exception >> 2013-10-27 01:47:17.835 24457 TRACE nova exc_info >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 195, in >> raise_from_cause >> 2013-10-27 01:47:17.835 24457 TRACE nova reraise(type(exception), >> exception, tb=exc_tb) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 867, in >> _execute_context >> 2013-10-27 01:47:17.835 24457 TRACE nova context) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 324, >> in do_execute >> 2013-10-27 01:47:17.835 24457 TRACE nova cursor.execute(statement, >> parameters) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute >> 2013-10-27 01:47:17.835 24457 TRACE nova self.errorhandler(self, exc, >> value) >> 2013-10-27 01:47:17.835 24457 TRACE nova File >> "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in >> defaulterrorhandler >> 2013-10-27 01:47:17.835 24457 TRACE nova raise errorclass, errorvalue >> 2013-10-27 01:47:17.835 24457 TRACE nova OperationalError: >> (OperationalError) (1553, "Cannot drop index 'instance_uuid': needed in a >> foreign key constraint") 'ALTER TABLE instance_info_caches DROP INDEX >> instance_uuid' () >> 2013-10-27 01:47:17.835 24457 TRACE nova >> >> _______________________________________________ >> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >> Post to : openstack@lists.openstack.org >> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > > > > -- > Rackspace Australia > > _______________________________________________ > Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > Post to : openstack@lists.openstack.org > Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack -- Rackspace Australia _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : openstack@lists.openstack.org Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack