[PKG-Openstack-devel] Bug#895640: openstack-trove FTBFS: test failures
Adrian Bunk
bunk at debian.org
Fri Apr 13 21:44:59 BST 2018
Source: openstack-trove
Version: 1:9.0.0-1
Severity: serious
https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/openstack-trove.html
...
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_delete
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_delete
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table agent_heartbeats already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/005_heartbeat.py", line 37, in upgrade
create_tables([agent_heartbeats])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table agent_heartbeats already exists [SQL: '\nCREATE TABLE agent_heartbeats (\n\tid VARCHAR(36) NOT NULL, \n\tinstance_id VARCHAR(36) NOT NULL, \n\tupdated_at DATETIME, \n\tPRIMARY KEY (id)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_filename
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_filename
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table usage_events already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/010_add_usage.py", line 45, in upgrade
create_tables([usage_events])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table usage_events already exists [SQL: '\nCREATE TABLE usage_events (\n\tid VARCHAR(36) NOT NULL, \n\tinstance_name VARCHAR(36), \n\ttenant_id VARCHAR(36), \n\tnova_instance_id VARCHAR(36), \n\tinstance_size INTEGER, \n\tnova_volume_id VARCHAR(36), \n\tvolume_size INTEGER, \n\tend_time DATETIME, \n\tupdated DATETIME, \n\tPRIMARY KEY (id)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_backup_size
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_backup_size
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table quotas already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/011_quota.py", line 61, in upgrade
create_tables([quotas, quota_usages, reservations])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table quotas already exists [SQL: '\nCREATE TABLE quotas (\n\tid VARCHAR(36) NOT NULL, \n\tcreated DATETIME, \n\tupdated DATETIME, \n\ttenant_id VARCHAR(36), \n\tresource VARCHAR(255) NOT NULL, \n\thard_limit INTEGER, \n\tPRIMARY KEY (id), \n\tUNIQUE (tenant_id, resource)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_list
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_list
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: service_type
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/015_add_service_type.py", line 27, in upgrade
instances.create_column(service_type)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 139, in visit_column
super(SQLiteColumnGenerator,self).visit_column(column)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 104, in visit_column
self.execute()
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: service_type [SQL: '\nALTER TABLE instances ADD service_type VARCHAR(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_list_for_instance
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_list_for_instance
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: service_type
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/015_add_service_type.py", line 27, in upgrade
instances.create_column(service_type)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 139, in visit_column
super(SQLiteColumnGenerator,self).visit_column(column)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 104, in visit_column
self.execute()
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: service_type [SQL: '\nALTER TABLE instances ADD service_type VARCHAR(36)'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_filename_bad
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_filename_bad
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table datastores already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/016_add_datastore_type.py", line 54, in upgrade
create_tables([datastores, datastore_versions])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table datastores already exists [SQL: '\nCREATE TABLE datastores (\n\tid VARCHAR(36) NOT NULL, \n\tname VARCHAR(255), \n\tmanager VARCHAR(255) NOT NULL, \n\tdefault_version_id VARCHAR(36), \n\tPRIMARY KEY (id), \n\tUNIQUE (name)\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.PaginationTests.test_pagination_list_for_instance
trove.tests.unittests.backup.test_backup_models.PaginationTests.test_pagination_list_for_instance
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: manager
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 452, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/017_update_datastores.py", line 44, in upgrade
datastore_versions.create_column(manager)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 139, in visit_column
super(SQLiteColumnGenerator,self).visit_column(column)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 104, in visit_column
self.execute()
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: manager [SQL: '\nALTER TABLE datastore_versions ADD manager VARCHAR(255)'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_not_running
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_not_running
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: duplicate column name: manager
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/017_update_datastores.py", line 44, in upgrade
datastore_versions.create_column(manager)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 139, in visit_column
super(SQLiteColumnGenerator,self).visit_column(column)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 104, in visit_column
self.execute()
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
return self.connection.execute(self.buffer.getvalue())
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 942, in execute
return self._execute_text(object, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1104, in _execute_text
statement, parameters
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate column name: manager [SQL: '\nALTER TABLE datastore_versions ADD manager VARCHAR(255)'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_not_is_running
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_not_is_running
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: instances
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/019_datastore_fix.py", line 96, in upgrade
if has_instances_wo_datastore_version(instance_table):
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/019_datastore_fix.py", line 72, in has_instances_wo_datastore_version
limit=1
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/base.py", line 386, in execute
return e._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 2082, in _execute_clauseelement
return connection._execute_clauseelement(elem, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: instances [SQL: 'SELECT id \nFROM instances \nWHERE datastore_version_id is NULL\n LIMIT ? OFFSET ?'] [parameters: (1, 0)] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_running_exclude
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_running_exclude
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table configurations already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/020_configurations.py", line 55, in upgrade
create_tables([configurations])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table configurations already exists [SQL: '\nCREATE TABLE configurations (\n\tid VARCHAR(36) NOT NULL, \n\tname VARCHAR(64) NOT NULL, \n\tdescription VARCHAR(256), \n\ttenant_id VARCHAR(36) NOT NULL, \n\tdatastore_version_id VARCHAR(36) NOT NULL, \n\tdeleted BOOLEAN NOT NULL, \n\tdeleted_at DATETIME, \n\tPRIMARY KEY (id), \n\tCHECK (deleted IN (0, 1))\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.OrderingTests.test_list_for_instance
trove.tests.unittests.backup.test_backup_models.OrderingTests.test_list_for_instance
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such index: instances_deleted
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 510, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/030_add_master_slave.py", line 32, in upgrade
nullable=True)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 137, in visit_column
SQLiteHelper.visit_column(self,column)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 117, in visit_column
self.recreate_table(table,column,delta)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 88, in recreate_table
index.drop()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 3504, in drop
bind._run_visitor(ddl.SchemaDropper, self)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 939, in visit_index
self.connection.execute(DropIndex(index))
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such index: instances_deleted [SQL: '\nDROP INDEX instances_deleted'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_is_running
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_is_running
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table clusters already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/032_clusters.py", line 53, in upgrade
create_tables([clusters])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table clusters already exists [SQL: '\nCREATE TABLE clusters (\n\tid VARCHAR(36) NOT NULL, \n\tcreated DATETIME NOT NULL, \n\tupdated DATETIME NOT NULL, \n\tname VARCHAR(255) NOT NULL, \n\ttask_id INTEGER NOT NULL, \n\ttenant_id VARCHAR(36) NOT NULL, \n\tdatastore_version_id VARCHAR(36) NOT NULL, \n\tdeleted BOOLEAN, \n\tdeleted_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(datastore_version_id) REFERENCES datastore_versions (id), \n\tCHECK (deleted IN (0, 1))\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_check_swift_object_exist_client_exception
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_check_swift_object_exist_client_exception
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table clusters already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/032_clusters.py", line 53, in upgrade
create_tables([clusters])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table clusters already exists [SQL: '\nCREATE TABLE clusters (\n\tid VARCHAR(36) NOT NULL, \n\tcreated DATETIME NOT NULL, \n\tupdated DATETIME NOT NULL, \n\tname VARCHAR(255) NOT NULL, \n\ttask_id INTEGER NOT NULL, \n\ttenant_id VARCHAR(36) NOT NULL, \n\tdatastore_version_id VARCHAR(36) NOT NULL, \n\tdeleted BOOLEAN, \n\tdeleted_at DATETIME, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(datastore_version_id) REFERENCES datastore_versions (id), \n\tCHECK (deleted IN (0, 1))\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_get_last_completed
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_get_last_completed
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table datastore_version_metadata already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/036_add_datastore_version_metadata.py", line 55, in upgrade
create_tables([datastore_version_metadata])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table datastore_version_metadata already exists [SQL: '\nCREATE TABLE datastore_version_metadata (\n\tid VARCHAR(36) NOT NULL, \n\tdatastore_version_id VARCHAR(36), \n\t"key" VARCHAR(128) NOT NULL, \n\tvalue VARCHAR(128), \n\tcreated DATETIME NOT NULL, \n\tdeleted BOOLEAN NOT NULL, \n\tdeleted_at DATETIME, \n\tupdated_at DATETIME, \n\tPRIMARY KEY (id), \n\tCONSTRAINT "UQ_datastore_version_metadata_datastore_version_id_key_value" UNIQUE (datastore_version_id, "key", value), \n\tFOREIGN KEY(datastore_version_id) REFERENCES datastore_versions (id) ON DELETE CASCADE, \n\tCHECK (deleted IN (0, 1))\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.OrderingTests.test_list
trove.tests.unittests.backup.test_backup_models.OrderingTests.test_list
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: table modules already exists
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 510, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/037_modules.py", line 78, in upgrade
create_tables([modules, instance_modules])
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/schema.py", line 69, in create_tables
table.create()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 778, in create
checkfirst=checkfirst)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 791, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table modules already exists [SQL: '\nCREATE TABLE modules (\n\tid VARCHAR(64) NOT NULL, \n\tname VARCHAR(255) NOT NULL, \n\ttype VARCHAR(255) NOT NULL, \n\tcontents TEXT NOT NULL, \n\tdescription VARCHAR(255), \n\ttenant_id VARCHAR(64), \n\tdatastore_id VARCHAR(64), \n\tdatastore_version_id VARCHAR(64), \n\tauto_apply BOOLEAN NOT NULL, \n\tvisible BOOLEAN NOT NULL, \n\tlive_update BOOLEAN NOT NULL, \n\tmd5 VARCHAR(32) NOT NULL, \n\tcreated DATETIME NOT NULL, \n\tupdated DATETIME NOT NULL, \n\tdeleted BOOLEAN NOT NULL, \n\tdeleted_at DATETIME, \n\tPRIMARY KEY (id), \n\tCONSTRAINT "UQ_type_tenant_datastore_datastore_version_name" UNIQUE (type, tenant_id, datastore_id, datastore_version_id, name, deleted_at), \n\tCHECK (auto_apply IN (0, 1)), \n\tCHECK (visible IN (0, 1)), \n\tCHECK (live_update IN (0, 1)), \n\tCHECK (deleted IN (0, 1))\n)\n\n'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_swift_auth_token_client_exception
trove.tests.unittests.backup.test_backup_models.BackupORMTest.test_swift_auth_token_client_exception
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such index: clusters_tenant_id
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/backup/test_backup_models.py", line 275, in setUp
util.init_db()
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/util/util.py", line 31, in init_db
db_api.db_sync(CONF)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 108, in db_sync
migration.db_sync(options, version, repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 106, in db_sync
upgrade(options, version=version, repo_path=repo_path)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migration.py", line 64, in upgrade
return versioning_api.upgrade(sql_connection, repo_path, version)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 186, in upgrade
return _migrate(url, repository, version, upgrade=True, err=err, **opts)
File "<decorator-gen-15>", line 2, in _migrate
File "/usr/lib/python3/dist-packages/migrate/versioning/util/__init__.py", line 167, in with_engine
return f(*a, **kw)
File "/usr/lib/python3/dist-packages/migrate/versioning/api.py", line 366, in _migrate
schema.runchange(ver, change, changeset.step)
File "/usr/lib/python3/dist-packages/migrate/versioning/schema.py", line 93, in runchange
change.run(self.engine, step)
File "/usr/lib/python3/dist-packages/migrate/versioning/script/py.py", line 148, in run
script_func(engine)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/migrate_repo/versions/042_add_cluster_configuration_id.py", line 38, in upgrade
ForeignKey("configurations.id")))
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 475, in create_column
column.create(table=self, *p, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/schema.py", line 577, in create
engine._run_visitor(visitorcallable, self, connection, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
ret = super(AlterTableVisitor, self).traverse_single(elem)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 137, in visit_column
SQLiteHelper.visit_column(self,column)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 117, in visit_column
self.recreate_table(table,column,delta)
File "/usr/lib/python3/dist-packages/migrate/changeset/databases/sqlite.py", line 88, in recreate_table
index.drop()
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/schema.py", line 3504, in drop
bind._run_visitor(ddl.SchemaDropper, self)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1940, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1549, in _run_visitor
**kwargs).traverse_single(element)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 939, in visit_index
self.connection.execute(DropIndex(index))
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1009, in _execute_ddl
compiled
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1413, in _handle_dbapi_exception
exc_info
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such index: clusters_tenant_id [SQL: '\nDROP INDEX clusters_tenant_id'] (Background on this error at: http://sqlalche.me/e/e3q8)
======================================================================
FAIL: trove.tests.unittests.cluster.test_galera_cluster.ClusterTest.test_grow
trove.tests.unittests.cluster.test_galera_cluster.ClusterTest.test_grow
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/mock/mock.py", line 1305, in patched
return func(*args, **keywargs)
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/cluster/test_galera_cluster.py", line 322, in test_grow
self.cluster.grow(self.instances)
File "/build/1st/openstack-trove-9.0.0/trove/common/strategies/cluster/experimental/galera_common/api.py", line 156, in grow
configuration_id = self.db_info.configuration_id
AttributeError: 'DBCluster' object has no attribute 'configuration_id'
======================================================================
FAIL: trove.tests.unittests.mgmt.test_datastores.TestDatastoreVersion.test_version_update
trove.tests.unittests.mgmt.test_datastores.TestDatastoreVersion.test_version_update
----------------------------------------------------------------------
_StringException: Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
sqlite3.IntegrityError: UNIQUE constraint failed: datastore_versions.name
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/build/1st/openstack-trove-9.0.0/trove/tests/unittests/mgmt/test_datastores.py", line 34, in setUp
'154b350d-4d86-4214-9067-9c54b230c0da', 'pkg-1', 1)
File "/build/1st/openstack-trove-9.0.0/trove/datastore/models.py", line 594, in update_datastore_version
db_api.save(version)
File "/build/1st/openstack-trove-9.0.0/trove/db/sqlalchemy/api.py", line 62, in save
db_session.flush()
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2254, in flush
self._flush(objects)
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2380, in _flush
transaction.rollback(_capture_exception=True)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/langhelpers.py", line 66, in __exit__
compat.reraise(exc_type, exc_value, exc_tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 187, in reraise
raise value
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/session.py", line 2344, in _flush
flush_context.execute()
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 391, in execute
rec.execute(self)
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/unitofwork.py", line 556, in execute
uow
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 181, in save_obj
mapper, table, insert)
File "/usr/lib/python3/dist-packages/sqlalchemy/orm/persistence.py", line 830, in _emit_insert_statements
execute(statement, multiparams)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 948, in execute
return meth(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception
util.raise_from_cause(newraise, exc_info)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 186, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
context)
File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 507, in do_execute
cursor.execute(statement, parameters)
oslo_db.exception.DBDuplicateEntry: (sqlite3.IntegrityError) UNIQUE constraint failed: datastore_versions.name [SQL: 'INSERT INTO datastore_versions (id, datastore_id, name, image_id, packages, active, manager) VALUES (?, ?, ?, ?, ?, ?, ?)'] [parameters: ('8d3440d3-5908-469a-a342-350335ab079e', '51b6861b-e333-4b32-9a4f-b1a9e643f1d6', 'test_vr1', '154b350d-4d86-4214-9067-9c54b230c0da', 'pkg-1', 1, 'mysql')] (Background on this error at: http://sqlalche.me/e/gkpj)
----------------------------------------------------------------------
Ran 1645 tests in 414.504s
FAILED (failures=18, skipped=1)
make[1]: *** [debian/rules:39: override_dh_install] Error 1
More information about the Openstack-devel
mailing list