In talking with Thomas it sounds like there is a problem with using
latest sqlalchemy-migrate and sqlalchemy > 0.7.99 with nova, I do
remember Dan Prince needing to fix something in nova when we tried
updating to migrate 0.8.2 for sqla 0.8 support, we'd have to go back and
find that change and backport it to stable/havana. It was pretty
trivial from what I remember, something about the migration test code
putting a cap on migrate/sqlalchemy for a now-invalid reason.
** Changed in: nova
Status: Invalid => New
** Changed in: nova
Importance: Wishlist => Undecided
--
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):
New
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
