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)