Marking this as invalid since it must be working, we're now supporting
sqlalchemy 0.8.
** 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/1209345
Title:
Migration tests fail with sqlalchemy 0.8
Status in OpenStack Compute (Nova):
Invalid
Bug description:
File
"/��BUILDDIR��/nova-2013.2+git201308071233~saucy/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)' ()
======================================================================
FAIL: process-returncode
tags: worker-0
----------------------------------------------------------------------
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1209345/+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
