cinder unit tests failing - TestMigrations

Bug #1368869 reported by Ian Govett
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Cinder
New
Undecided
Unassigned

Bug Description

running from the master repo, I'm seeing fails with the cinder.tests.test_migrations.TestMigrations class.

I rebuilt my venv, but this didn't fix the problem. My latest code patchs are also failing in gerrit due to this same problem.

here's the log messages.

 ./run_tests.sh -d cinder.tests.test_migrations.TestMigrations
Tests running...
No handlers could be found for logger "migrate.versioning.script.sql"
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_downgrade_007_removes_fk
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 532, in test_downgrade_007_removes_fk
    for metadata in self.metadatas_downgraded_from(7):
  File "cinder/tests/test_migrations.py", line 498, in _metadatas
    engine, TestMigrations.REPOSITORY, downgrade_to)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_migration_011
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 715, in test_migration_011
    migration_api.downgrade(engine, TestMigrations.REPOSITORY, 10)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_migration_012
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 745, in test_migration_012
    migration_api.downgrade(engine, TestMigrations.REPOSITORY, 11)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_migration_013
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 771, in test_migration_013
    migration_api.downgrade(engine, TestMigrations.REPOSITORY, 12)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_migration_014
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 797, in test_migration_014
    migration_api.downgrade(engine, TestMigrations.REPOSITORY, 13)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()
======================================================================
ERROR: cinder.tests.test_migrations.TestMigrations.test_walk_versions
----------------------------------------------------------------------
Traceback (most recent call last):
  File "cinder/tests/test_migrations.py", line 241, in test_walk_versions
    self._walk_versions(engine, self.snake_walk)
  File "cinder/tests/test_migrations.py", line 329, in _walk_versions
    self._migrate_down(engine, version - 1)
  File "cinder/tests/test_migrations.py", line 347, in _migrate_down
    version)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-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/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
    return f(*a, **kw)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate
    schema.runchange(ver, change, changeset.step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange
    change.run(self.engine, step)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/sql.py", line 45, in run
    conn.execute(statement)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute
    return self._execute_text(object, multiparams, params)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text
    statement, parameters
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1160, in _handle_dbapi_exception
    exc_info
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/home/igovett/cinder/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute
    cursor.execute(statement, parameters)
OperationalError: (OperationalError) cannot commit - no transaction is active u'COMMIT;' ()

Ran 27 tests in 3.662s
FAILED (failures=6)

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.