I get the following error in /var/log/nova/nova-manage.log when running 'nova-manage db sync' on nova trunk:
(nova): TRACE: File "/usr/lib/pymodules/python2.6/migrate/versioning/util/__init__.py", line 160, in with_engine
(nova): TRACE: return f(*a, **kw)
(nova): TRACE: File "/usr/lib/pymodules/python2.6/migrate/versioning/api.py", line 364, in _migrate
(nova): TRACE: schema.runchange(ver, change, changeset.step)
(nova): TRACE: File "/usr/lib/pymodules/python2.6/migrate/versioning/schema.py", line 83, in runchange
(nova): TRACE: change.run(self.engine, step)
(nova): TRACE: File "/usr/lib/pymodules/python2.6/migrate/versioning/script/py.py", line 140, in run
(nova): TRACE: script_func(engine)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/047_remove_instances_fk_from_vif.py", line 48, in upgrade
(nova): TRACE: migrate_engine.execute("ALTER TABLE migrations DROP " \
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1715, in execute
(nova): TRACE: return connection.execute(statement, *multiparams, **params)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1157, in execute
(nova): TRACE: params)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1253, in _execute_text
(nova): TRACE: return self.__execute_context(context)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1268, in __execute_context
(nova): TRACE: context.parameters[0], context=context)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1367, in _cursor_execute
(nova): TRACE: context)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py", line 1360, in _cursor_execute
(nova): TRACE: context)
(nova): TRACE: File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/default.py", line 288, in do_execute
(nova): TRACE: cursor.execute(statement, parameters)
(nova): TRACE: File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
(nova): TRACE: self.errorhandler(self, exc, value)
(nova): TRACE: File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
(nova): TRACE: raise errorclass, errorvalue
(nova): TRACE: OperationalError: (OperationalError) (1025, "Error on rename of './nova/migrations' to './nova/#sql2-272a-2b' (errno: 152)") 'ALTER TABLE migrations DROP FOREIGN KEY `virtual_interfaces_ibfk_2`;' ()
(nova): TRACE:
