Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

nova-manage db sync failed

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 TRACE nova engine._run_visitor(visitorcallable, self, connection, *kwargs) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2302, in _run_visitor 2013-08-04 21:37:24.684 27213 TRACE nova conn._run_visitor(visitorcallable, element, *kwargs) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1972, in _run_visitor 2013-08-04 21:37:24.684 27213 TRACE nova *kwargs).traverse_single(element) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 53, in traverse_single 2013-08-04 21:37:24.684 27213 TRACE nova ret = super(AlterTableVisitor, self).traverse_single(elem) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single 2013-08-04 21:37:24.684 27213 TRACE nova return meth(obj, **kw) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 101, in visit_column 2013-08-04 21:37:24.684 27213 TRACE nova self.execute() 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 42, in execute 2013-08-04 21:37:24.684 27213 TRACE nova return self.connection.execute(self.buffer.getvalue()) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute 2013-08-04 21:37:24.684 27213 TRACE nova params) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text 2013-08-04 21:37:24.684 27213 TRACE nova statement, parameters 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context 2013-08-04 21:37:24.684 27213 TRACE nova context) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context 2013-08-04 21:37:24.684 27213 TRACE nova context) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute 2013-08-04 21:37:24.684 27213 TRACE nova cursor.execute(statement, parameters) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute 2013-08-04 21:37:24.684 27213 TRACE nova self.errorhandler(self, exc, value) 2013-08-04 21:37:24.684 27213 TRACE nova File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 2013-08-04 21:37:24.684 27213 TRACE nova raise errorclass, errorvalue 2013-08-04 21:37:24.684 27213 TRACE nova OperationalError: (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

nova-manage db sync failed

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)
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)
**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)
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 TRACE nova     engine._run_visitor(visitorcallable, self, connection, *kwargs)
**kwargs)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2302, in _run_visitor
2013-08-04 21:37:24.684 27213 TRACE nova     conn._run_visitor(visitorcallable, element, *kwargs)
**kwargs)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1972, in _run_visitor
2013-08-04 21:37:24.684 27213 TRACE nova     *kwargs).traverse_single(element)
**kwargs).traverse_single(element)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 53, in traverse_single
2013-08-04 21:37:24.684 27213 TRACE nova     ret = super(AlterTableVisitor, self).traverse_single(elem)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
2013-08-04 21:37:24.684 27213 TRACE nova     return meth(obj, **kw)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 101, in visit_column
2013-08-04 21:37:24.684 27213 TRACE nova     self.execute()
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 42, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     return self.connection.execute(self.buffer.getvalue())
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     params)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
2013-08-04 21:37:24.684 27213 TRACE nova     statement, parameters
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
2013-08-04 21:37:24.684 27213 TRACE nova     context)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
2013-08-04 21:37:24.684 27213 TRACE nova     context)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
2013-08-04 21:37:24.684 27213 TRACE nova     cursor.execute(statement, parameters)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     self.errorhandler(self, exc, value)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2013-08-04 21:37:24.684 27213 TRACE nova     raise errorclass, errorvalue
2013-08-04 21:37:24.684 27213 TRACE nova OperationalError: (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 

nova

nova-manage db sync failed

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 TRACE nova     engine._run_visitor(visitorcallable, self, connection, **kwargs)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2302, in _run_visitor
2013-08-04 21:37:24.684 27213 TRACE nova     conn._run_visitor(visitorcallable, element, **kwargs)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1972, in _run_visitor
2013-08-04 21:37:24.684 27213 TRACE nova     **kwargs).traverse_single(element)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 53, in traverse_single
2013-08-04 21:37:24.684 27213 TRACE nova     ret = super(AlterTableVisitor, self).traverse_single(elem)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 106, in traverse_single
2013-08-04 21:37:24.684 27213 TRACE nova     return meth(obj, **kw)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 101, in visit_column
2013-08-04 21:37:24.684 27213 TRACE nova     self.execute()
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 42, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     return self.connection.execute(self.buffer.getvalue())
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1449, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     params)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text
2013-08-04 21:37:24.684 27213 TRACE nova     statement, parameters
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
2013-08-04 21:37:24.684 27213 TRACE nova     context)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
2013-08-04 21:37:24.684 27213 TRACE nova     context)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 331, in do_execute
2013-08-04 21:37:24.684 27213 TRACE nova     cursor.execute(statement, parameters)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
2013-08-04 21:37:24.684 27213 TRACE nova     self.errorhandler(self, exc, value)
2013-08-04 21:37:24.684 27213 TRACE nova   File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
2013-08-04 21:37:24.684 27213 TRACE nova     raise errorclass, errorvalue
2013-08-04 21:37:24.684 27213 TRACE nova OperationalError: (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