yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem@xxxxxxxxxx>]

I'm going to say this is invalid since it's a Folsom release candidate
build?  Did you mean service pack 1 instead of release candidate 1?  If
that was the case, the version would be 2012.2.1.

** Tags added: db

** Changed in: nova
       Status: New => Invalid

** Changed in: nova
       Status: Invalid => Incomplete

-- 
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):
  Incomplete

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