Ask Your Question
1

nova-manage db sync failed

asked 2013-08-04 09:26:01 -0600

anonymous user

Anonymous

updated 2013-08-05 10:28:18 -0600

smaffulli gravatar image

host os: ubuntu 13.04 server

root@openstack:~# nova-manage db sync
Command failed, please check log for more info
2013-08-04 21:37:24.684 27213 CRITICAL nova [-] (OperationalError) (1060, "Duplicate column name 'new_deleted'") '\nALTER TABLE quotas ADD new_deleted INTEGER(11)' ()
2013-08-04 21:37:24.684 27213 TRACE nova Traceback (most recent call last):
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/bin/nova-manage", line 1263, in <module>
2013-08-04 21:37:24.684 27213 TRACE nova     main()
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/bin/nova-manage", line 1255, in main
2013-08-04 21:37:24.684 27213 TRACE nova     fn(*fn_args, **fn_kwargs)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/bin/nova-manage", line 798, in sync
2013-08-04 21:37:24.684 27213 TRACE nova     return migration.db_sync(version)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/migration.py", line 32, in db_sync
2013-08-04 21:37:24.684 27213 TRACE nova     return IMPL.db_sync(version=version)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 78, in db_sync
2013-08-04 21:37:24.684 27213 TRACE nova     return versioning_api.upgrade(get_engine(), repository, version)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2013-08-04 21:37:24.684 27213 TRACE nova     return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2013-08-04 21:37:24.684 27213 TRACE nova   File "<string>", line 2, in _migrate
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 43, in patched_with_engine
2013-08-04 21:37:24.684 27213 TRACE nova     return f(*a, **kw)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2013-08-04 21:37:24.684 27213 TRACE nova     schema.runchange(ver, change, changeset.step)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in runchange
2013-08-04 21:37:24.684 27213 TRACE nova     change.run(self.engine, step)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145, in run
2013-08-04 21:37:24.684 27213 TRACE nova     script_func(engine)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/152_change_type_of_deleted_column.py", line 73, in upgrade
2013-08-04 21:37:24.684 27213 TRACE nova     return upgrade_enterprise_dbs(migrate_engine)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/152_change_type_of_deleted_column.py", line 61, in upgrade_enterprise_dbs
2013-08-04 21:37:24.684 27213 TRACE nova     new_deleted.create(table, populate_default=True)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 528, in create
2013-08-04 21:37:24.684 27213 ...
(more)
edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
1

answered 2013-08-05 04:53:52 -0600

Tolik gravatar image

if this is fresh installation a nova, try to drop database (nova), create new database and try sync again.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

Stats

Asked: 2013-08-04 09:26:01 -0600

Seen: 1,434 times

Last updated: Aug 05 '13