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