These tests pass for me with sqlite.
** Changed in: nova
Status: Incomplete => Invalid
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1236040
Title:
Nova 2013.2 rc1 has a failed "walk version" unit test
Status in OpenStack Compute (Nova):
Invalid
Bug description:
This unit test is the only one I have in all of the 9393 unit tests of
the Nova Debian package I'm building in Sid. It'd be nice to have it
fixed.
Traceback (most recent call last):
File
"/home/zigo/sources/openstack/havana/nova/build-area/nova-2013.2~rc1/nova/tests/db/test_migrations.py",
line 159, in test_walk_versions
self._walk_versions(engine, self.snake_walk)
File
"/home/zigo/sources/openstack/havana/nova/build-area/nova-2013.2~rc1/nova/tests/db/test_migrations.py",
line 381, in _walk_versions
engine, version - 1, with_data=True)
File
"/home/zigo/sources/openstack/havana/nova/build-area/nova-2013.2~rc1/nova/tests/db/test_migrations.py",
line 398, in _migrate_down
self.migration_api.downgrade(engine, self.REPOSITORY, version)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line
202, in downgrade
return _migrate(url, repository, version, upgrade=False, err=err, **opts)
File "<string>", line 2, in _migrate
File
"/home/zigo/sources/openstack/havana/nova/build-area/nova-2013.2~rc1/nova/db/sqlalchemy/migration.py",
line 40, in patched_with_engine
return f(*a, **kw)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line
366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line
91, in runchange
change.run(self.engine, step)
File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py",
line 145, in run
script_func(engine)
File
"/home/zigo/sources/openstack/havana/nova/build-area/nova-2013.2~rc1/nova/db/sqlalchemy/migrate_repo/versions/206_add_instance_cleaned.py",
line 47, in downgrade
instances.columns.cleaned.drop()
File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line
549, in drop
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1479, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1122, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line
53, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line
111, in traverse_single
return meth(obj, **kw)
File
"/usr/lib/python2.7/dist-packages/migrate/changeset/databases/sqlite.py", line
90, in visit_column
super(SQLiteColumnDropper,self).visit_column(column)
File
"/usr/lib/python2.7/dist-packages/migrate/changeset/databases/sqlite.py", line
53, in visit_column
self.recreate_table(table,column,delta)
File
"/usr/lib/python2.7/dist-packages/migrate/changeset/databases/sqlite.py", line
40, in recreate_table
table.create(bind=self.connection)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/schema.py", line 614, in
create
checkfirst=checkfirst)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1122, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line
111, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line 93,
in visit_table
self.traverse_single(index)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line
111, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/ddl.py", line 105,
in visit_index
self.connection.execute(schema.CreateIndex(index))
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
662, in execute
params)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
720, in _execute_ddl
compiled
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
874, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
1024, in _handle_dbapi_exception
exc_info
File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line
195, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line
867, in _execute_context
context)
File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
324, in do_execute
cursor.execute(statement, parameters)
OperationalError: (OperationalError) table instances has no column named
cleaned u'CREATE INDEX instances_host_deleted_cleaned_idx ON instances (host,
deleted, cleaned)' ()
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1236040/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
