--- Begin Message ---
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
--- End Message ---