[PKG-Openstack-devel] Bug#827739: trove-common: MySQL error: Cannot change column 'datastore_version_id'
Turbo Fredriksson
turbo at bayour.com
Mon Jun 20 11:58:37 UTC 2016
Package: trove-common
Version: 1:5.0.0-2
Severity: important
Trying to install Trove on Sid give this error:
----- s n i p -----
[...]
2016-06-20 12:48:10.686 19719 INFO migrate.versioning.api [-] 17 -> 18...
2016-06-20 12:48:10.741 19719 INFO migrate.versioning.api [-] done
2016-06-20 12:48:10.741 19719 INFO migrate.versioning.api [-] 18 -> 19...
/usr/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py:3888: SAWarning: Textual column expression 'id' should be explicitly declared with text('id'), or use column('id') for more specificity (this warning may be suppressed after 10 occurrences)
if guess_is_literal else "column"
2016-06-20 12:48:10.794 19719 DEBUG migrate.versioning.util [-] Disposing SQLAlchemy engine Engine(mysql+pymysql://trove:***@openstack.bayour.com/trove) with_engine /usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py:163
Command failed, please check log for more info.
2016-06-20 12:48:10.795 19719 CRITICAL root [-] InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'datastore_version_id': used in a foreign key constraint 'instances_ibfk_1'") [SQL: u'\nALTER TABLE instances CHANGE COLUMN datastore_version_id datastore_version_id VARCHAR(36) COLLATE utf8_unicode_ci NOT NULL']
2016-06-20 12:48:10.795 19719 ERROR root Traceback (most recent call last):
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/bin/trove-manage", line 10, in <module>
2016-06-20 12:48:10.795 19719 ERROR root sys.exit(main())
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 222, in main
2016-06-20 12:48:10.795 19719 ERROR root Commands().execute()
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 61, in execute
2016-06-20 12:48:10.795 19719 ERROR root exec_method(**kwargs)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/cmd/manage.py", line 45, in db_sync
2016-06-20 12:48:10.795 19719 ERROR root self.db_api.db_sync(CONF, repo_path=repo_path)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/api.py", line 103, in db_sync
2016-06-20 12:48:10.795 19719 ERROR root migration.db_sync(options, version, repo_path)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migration.py", line 122, in db_sync
2016-06-20 12:48:10.795 19719 ERROR root upgrade(options, version=version, repo_path=repo_path)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migration.py", line 64, in upgrade
2016-06-20 12:48:10.795 19719 ERROR root return versioning_api.upgrade(sql_connection, repo_path, version)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in upgrade
2016-06-20 12:48:10.795 19719 ERROR root return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2016-06-20 12:48:10.795 19719 ERROR root File "<decorator-gen-15>", line 2, in _migrate
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line 160, in with_engine
2016-06-20 12:48:10.795 19719 ERROR root return f(*a, **kw)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in _migrate
2016-06-20 12:48:10.795 19719 ERROR root schema.runchange(ver, change, changeset.step)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 93, in runchange
2016-06-20 12:48:10.795 19719 ERROR root change.run(self.engine, step)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 148, in run
2016-06-20 12:48:10.795 19719 ERROR root script_func(engine)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/trove/db/sqlalchemy/migrate_repo/versions/019_datastore_fix.py", line 114, in upgrade
2016-06-20 12:48:10.795 19719 ERROR root instance_table.c.datastore_version_id.alter(nullable=False)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 534, in alter
2016-06-20 12:48:10.795 19719 ERROR root return alter_column(self, *p, **k)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 141, in alter_column
2016-06-20 12:48:10.795 19719 ERROR root engine._run_visitor(visitorcallable, delta)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1856, in _run_visitor
2016-06-20 12:48:10.795 19719 ERROR root conn._run_visitor(visitorcallable, element, **kwargs)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1481, in _run_visitor
2016-06-20 12:48:10.795 19719 ERROR root **kwargs).traverse_single(element)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 56, in traverse_single
2016-06-20 12:48:10.795 19719 ERROR root ret = super(AlterTableVisitor, self).traverse_single(elem)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 121, in traverse_single
2016-06-20 12:48:10.795 19719 ERROR root return meth(obj, **kw)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/databases/mysql.py", line 47, in visit_column
2016-06-20 12:48:10.795 19719 ERROR root self.execute()
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 44, in execute
2016-06-20 12:48:10.795 19719 ERROR root return self.connection.execute(self.buffer.getvalue())
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 906, in execute
2016-06-20 12:48:10.795 19719 ERROR root return self._execute_text(object, multiparams, params)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1054, in _execute_text
2016-06-20 12:48:10.795 19719 ERROR root statement, parameters
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-06-20 12:48:10.795 19719 ERROR root context)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2016-06-20 12:48:10.795 19719 ERROR root exc_info
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-06-20 12:48:10.795 19719 ERROR root reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-06-20 12:48:10.795 19719 ERROR root context)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-06-20 12:48:10.795 19719 ERROR root cursor.execute(statement, parameters)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-06-20 12:48:10.795 19719 ERROR root result = self._query(query)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-06-20 12:48:10.795 19719 ERROR root conn.query(q)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 835, in query
2016-06-20 12:48:10.795 19719 ERROR root self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1019, in _read_query_result
2016-06-20 12:48:10.795 19719 ERROR root result.read()
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1302, in read
2016-06-20 12:48:10.795 19719 ERROR root first_packet = self.connection._read_packet()
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 981, in _read_packet
2016-06-20 12:48:10.795 19719 ERROR root packet.check_error()
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 393, in check_error
2016-06-20 12:48:10.795 19719 ERROR root err.raise_mysql_exception(self._data)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-06-20 12:48:10.795 19719 ERROR root _check_mysql_exception(errinfo)
2016-06-20 12:48:10.795 19719 ERROR root File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 115, in _check_mysql_exception
2016-06-20 12:48:10.795 19719 ERROR root raise InternalError(errno, errorvalue)
2016-06-20 12:48:10.795 19719 ERROR root InternalError: (pymysql.err.InternalError) (1832, u"Cannot change column 'datastore_version_id': used in a foreign key constraint 'instances_ibfk_1'") [SQL: u'\nALTER TABLE instances CHANGE COLUMN datastore_version_id datastore_version_id VARCHAR(36) COLLATE utf8_unicode_ci NOT NULL']
2016-06-20 12:48:10.795 19719 ERROR root
dpkg: error processing package trove-common (--configure):
[...]
----- s n i p -----
-- System Information:
Debian Release: stretch/sid
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Kernel: Linux 3.16.0-4-amd64 (SMP w/16 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages trove-common depends on:
ii adduser 3.114
ii dbconfig-common 2.0.4
ii debconf [debconf-2.0] 1.5.59
ii python-trove 1:5.0.0-2
ii sqlite3 3.13.0-1
trove-common recommends no packages.
trove-common suggests no packages.
-- debconf information:
trove-common/password-confirm: (password omitted)
trove-common/pgsql/app-pass: (password omitted)
* trove-common/mysql/admin-pass: (password omitted)
* trove/admin-password: (password omitted)
trove-common/app-password-confirm: (password omitted)
trove-common/pgsql/admin-pass: (password omitted)
* trove/rabbit_password: (password omitted)
trove-common/mysql/app-pass: (password omitted)
* trove/configure_db: true
trove-common/db/basepath: /var/lib/trove
* trove/admin-tenant-name: admin
trove-common/install-error: abort
* trove-common/mysql/admin-user: root
trove-common/dbconfig-upgrade: true
trove-common/pgsql/no-empty-passwords:
* trove-common/remote/port:
trove-common/pgsql/manualconf:
trove-common/passwords-do-not-match:
* trove-common/db/app-user: trove
* trove-common/db/dbname: trove
trove-common/upgrade-error: abort
trove-common/purge: false
trove-common/pgsql/method: TCP/IP
trove-common/internal/skip-preseed: false
trove-common/upgrade-backup: true
trove-common/internal/reconfiguring: false
* trove-common/remote/host: control
trove-common/dbconfig-reinstall: false
* trove-common/dbconfig-install: true
* trove/rabbit_host: control
* trove/rabbit_userid: openstack
trove-common/pgsql/changeconf: false
trove-common/pgsql/admin-user: postgres
trove-common/dbconfig-remove: true
trove-common/missing-db-package-error: abort
trove-common/remove-error: abort
* trove-common/mysql/method: TCP/IP
trove-common/remote/newhost: control
* trove-common/database-type: mysql
* trove/auth-host: 10.0.4.1
trove-common/pgsql/authmethod-user: password
* trove/admin-user: admin
trove-common/pgsql/authmethod-admin: password
More information about the Openstack-devel
mailing list