nova-manage db sync error

[Yun Mao]

I just tried devstack master branch with a fresh installed ubuntu 12.04. The db sync error is as follows:

+ /opt/stack/nova/bin/nova-manage db sync
2012-04-30 16:18:08 DEBUG nova.utils [-] backend <module 'nova.db.sqlalchemy.migration' from '/opt/stack/nova/nova/db/sqlalchemy/migration.pyc'> from (pid=18353) __get_backend /opt/stack/nova/nova/utils.py:631
2012-04-30 16:18:08 WARNING nova.utils [-] /usr/lib/python2.7/dist-packages/sqlalchemy/pool.py:639: SADeprecationWarning: The 'listeners' argument to Pool (and create_engine()) is deprecated. Use event.listen().
  Pool.__init__(self, creator, **kw)

2012-04-30 16:18:08 WARNING nova.utils [-] /usr/lib/python2.7/dist-packages/sqlalchemy/pool.py:145: SADeprecationWarning: Pool.add_listener is deprecated. Use event.listen()
  self.add_listener(l)

2012-04-30 16:18:12 WARNING nova.utils [-] /opt/stack/nova/nova/db/sqlalchemy/migrate_repo/versions/075_convert_bw_usage_to_store_network_id.py:49: SADeprecationWarning: useexisting is deprecated. Use extend_existing.
  useexisting=True)

2012-04-30 16:18:13 WARNING nova.utils [-] /opt/stack/nova/nova/db/sqlalchemy/migrate_repo/versions/081_drop_instance_id_bw_cache.py:40: SADeprecationWarning: useexisting is deprecated. Use extend_existing.
  useexisting=True)

Command failed, please check log for more info
2012-04-30 16:18:13 CRITICAL nova [-] (OperationalError) (1025, "Error on rename of './nova/#sql-44f3_29' to './nova/dns_domains' (errno: 150)") 'ALTER TABLE dns_domains Engine=InnoDB' ()
2012-04-30 16:18:13 TRACE nova Traceback (most recent call last):
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/bin/nova-manage", line 1754, in <module>
2012-04-30 16:18:13 TRACE nova main()
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/bin/nova-manage", line 1741, in main
2012-04-30 16:18:13 TRACE nova fn(*fn_args, **fn_kwargs)
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/bin/nova-manage", line 1106, in sync
2012-04-30 16:18:13 TRACE nova return migration.db_sync(version)
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/nova/db/migration.py", line 30, in db_sync
2012-04-30 16:18:13 TRACE nova return IMPL.db_sync(version=version)
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 83, in db_sync
2012-04-30 16:18:13 TRACE nova return versioning_api.upgrade(get_engine(), repository, version)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2012-04-30 16:18:13 TRACE nova return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2012-04-30 16:18:13 TRACE nova File "<string>", line 2, in _migrate
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/migration.py", line 39, in patched_with_engine
2012-04-30 16:18:13 TRACE nova return f(*a, **kw)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2012-04-30 16:18:13 TRACE nova schema.runchange(ver, change, changeset.step)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
2012-04-30 16:18:13 TRACE nova change.run(self.engine, step)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
2012-04-30 16:18:13 TRACE nova script_func(engine)
2012-04-30 16:18:13 TRACE nova File "/opt/stack/nova/nova/db/sqlalchemy/migrate_repo/versions/086_set_engine_mysql_innodb.py", line 33, in upgrade
2012-04-30 16:18:13 TRACE nova migrate_engine.execute("ALTER TABLE dns_domains Engine=InnoDB")
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2297, in execute
2012-04-30 16:18:13 TRACE nova return connection.execute(statement, *multiparams, **params)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in execute
2012-04-30 16:18:13 TRACE nova params)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1582, in _execute_text
2012-04-30 16:18:13 TRACE nova statement, parameters
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in _execute_context
2012-04-30 16:18:13 TRACE nova context)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in _execute_context
2012-04-30 16:18:13 TRACE nova context)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in do_execute
2012-04-30 16:18:13 TRACE nova cursor.execute(statement, parameters)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2012-04-30 16:18:13 TRACE nova self.errorhandler(self, exc, value)
2012-04-30 16:18:13 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2012-04-30 16:18:13 TRACE nova raise errorclass, errorvalue
2012-04-30 16:18:13 TRACE nova OperationalError: (OperationalError) (1025, "Error on rename of './nova/#sql-44f3_29' to './nova/dns_domains' (errno: 150)") 'ALTER TABLE dns_domains Engine=InnoDB' ()
2012-04-30 16:18:13 TRACE nova
++ failed
++ local r=1

[Chuck Short (zulcss)]

This has been recently fixed by:

https://github.com/openstack/nova/commit/7b5fdac84b513c6b606848cc353995d6abb9a7c9#nova/db/sqlalchemy/migrate_repo/versions/096_recreate_dns_domains.py

[Vishal (vishal-gupta)]

When running sudo nova-manage db sync command
Then getting this error :-
vishal@Cloud2SME1:~$ sudo nova-manage db sync
2012-06-03 01:23:56 DEBUG nova.utils [-] backend <module 'nova.db.sqlalchemy.mig ration' from '/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.pyc' > from (pid=2770) __get_backend /usr/lib/python2.7/dist-packages/nova/utils.py:6 58

^C2012-06-03 01:24:14 CRITICAL nova [-]
2012-06-03 01:24:14 TRACE nova Traceback (most recent call last):
2012-06-03 01:24:14 TRACE nova File "/usr/bin/nova-manage", line 1744, in <module>
2012-06-03 01:24:14 TRACE nova main()
2012-06-03 01:24:14 TRACE nova File "/usr/bin/nova-manage", line 1731, in main
2012-06-03 01:24:14 TRACE nova fn(*fn_args, **fn_kwargs)
2012-06-03 01:24:14 TRACE nova File "/usr/bin/nova-manage", line 1102, in sync
2012-06-03 01:24:14 TRACE nova return migration.db_sync(version)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 30, in db_sync
2012-06-03 01:24:14 TRACE nova return IMPL.db_sync(version=version)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 51, in db_sync
2012-06-03 01:24:14 TRACE nova return versioning_api.upgrade(FLAGS.sql_connection, repo_path, version)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2012-06-03 01:24:14 TRACE nova return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2012-06-03 01:24:14 TRACE nova File "<string>", line 2, in _migrate
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 159, in with_engine
2012-06-03 01:24:14 TRACE nova return f(*a, **kw)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2012-06-03 01:24:14 TRACE nova schema.runchange(ver, change, changeset.step)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/
2012-06-03 01:24:14 TRACE nova change.run(self.engine, step)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/
2012-06-03 01:24:14 TRACE nova script_func(engine)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/nova/db/
2012-06-03 01:24:14 TRACE nova migrate_engine.execute("ALTER TABLE migration
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalche
2012-06-03 01:24:14 TRACE nova return connection.execute(statement, *multipa
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalche
2012-06-03 01:24:14 TRACE nova params)
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalche
2012-06-03 01:24:14 TRACE nova statement, parameters
2012-06-03 01:24:14 TRACE nova File "/usr/lib/python2.7/dist-pack...