Bug#895640: marked as done (openstack-trove FTBFS: test failures)

[Debian Bug Tracking System]

Your message dated Thu, 6 Sep 2018 22:20:57 +0200
with message-id <28b30fae-26a0-865d-b656-8a4bd3903...@debian.org>
and subject line Closing this one
has caused the Debian Bug report #895640,
regarding openstack-trove FTBFS: test failures
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact ow...@bugs.debian.org
immediately.)


-- 
895640: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=895640
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems

--- 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 ---

--- Begin Message ---

This bug was fixed by latest upload to Sid.

--- End Message ---