[PKG-Openstack-devel] Bug#846995: manila-common: syntax error [SQL: u'ALTER TABLE shares ALTER COLUMN
Turbo Fredriksson
turbo at bayour.com
Sun Dec 4 20:29:58 UTC 2016
Package: manila-common
Version: 1:3.0.0-1
Severity: important
----- s n i p -----
2016-12-04 20:26:34.557 7550 INFO alembic.runtime.migration [-] Context impl SQLiteImpl.
2016-12-04 20:26:34.557 7550 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2016-12-04 20:26:34.567 7550 INFO alembic.runtime.migration [-] Running upgrade -> 162a3e673105, manila_init
2016-12-04 20:26:34.634 7550 INFO alembic.runtime.migration [-] Running upgrade 162a3e673105 -> 211836bf835c, add access level
2016-12-04 20:26:34.636 7550 INFO alembic.runtime.migration [-] Running upgrade 211836bf835c -> 38e632621e5a, change volume_type to share_type
2016-12-04 20:26:34.637 7550 INFO 38e632621e5a_change_volume_type_to_share_type_py [-] Renaming column name shares.volume_type_id to shares.share_type.id
2016-12-04 20:26:34.638 7550 CRITICAL manila [-] OperationalError: (pysqlite2.dbapi2.OperationalError) near "ALTER": syntax error [SQL: u'ALTER TABLE shares ALTER COLUMN volume_type_id TYPE VARCHAR(36)']
2016-12-04 20:26:34.638 7550 ERROR manila Traceback (most recent call last):
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/bin/manila-manage", line 10, in <module>
2016-12-04 20:26:34.638 7550 ERROR manila sys.exit(main())
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/cmd/manage.py", line 453, in main
2016-12-04 20:26:34.638 7550 ERROR manila fn(*fn_args)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/cmd/manage.py", line 212, in sync
2016-12-04 20:26:34.638 7550 ERROR manila return migration.upgrade(version)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/db/migration.py", line 28, in upgrade
2016-12-04 20:26:34.638 7550 ERROR manila return IMPL.upgrade(version)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/db/migrations/alembic/migration.py", line 51, in upgrade
2016-12-04 20:26:34.638 7550 ERROR manila return alembic.command.upgrade(_alembic_config(), revision or 'head')
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
2016-12-04 20:26:34.638 7550 ERROR manila script.run_env()
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
2016-12-04 20:26:34.638 7550 ERROR manila util.load_python_file(self.dir, 'env.py')
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
2016-12-04 20:26:34.638 7550 ERROR manila module = load_module_py(module_id, path)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
2016-12-04 20:26:34.638 7550 ERROR manila mod = imp.load_source(module_id, path, fp)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/db/migrations/alembic/env.py", line 41, in <module>
2016-12-04 20:26:34.638 7550 ERROR manila run_migrations_online()
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/db/migrations/alembic/env.py", line 36, in run_migrations_online
2016-12-04 20:26:34.638 7550 ERROR manila context.run_migrations() # pylint: disable=E1101
2016-12-04 20:26:34.638 7550 ERROR manila File "<string>", line 8, in run_migrations
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
2016-12-04 20:26:34.638 7550 ERROR manila self.get_context().run_migrations(**kw)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
2016-12-04 20:26:34.638 7550 ERROR manila step.migration_fn(**kw)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/manila/db/migrations/alembic/versions/38e632621e5a_change_volume_type_to_share_type.py", line 43, in upgrade
2016-12-04 20:26:34.638 7550 ERROR manila type_=sa.String(length=36))
2016-12-04 20:26:34.638 7550 ERROR manila File "<string>", line 8, in alter_column
2016-12-04 20:26:34.638 7550 ERROR manila File "<string>", line 3, in alter_column
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1420, in alter_column
2016-12-04 20:26:34.638 7550 ERROR manila return operations.invoke(alt)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
2016-12-04 20:26:34.638 7550 ERROR manila return fn(self, operation)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 53, in alter_column
2016-12-04 20:26:34.638 7550 ERROR manila **operation.kw
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 160, in alter_column
2016-12-04 20:26:34.638 7550 ERROR manila existing_nullable=existing_nullable,
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
2016-12-04 20:26:34.638 7550 ERROR manila return conn.execute(construct, *multiparams, **params)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-12-04 20:26:34.638 7550 ERROR manila return meth(self, multiparams, params)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2016-12-04 20:26:34.638 7550 ERROR manila return connection._execute_ddl(self, multiparams, params)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2016-12-04 20:26:34.638 7550 ERROR manila compiled
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-12-04 20:26:34.638 7550 ERROR manila context)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-12-04 20:26:34.638 7550 ERROR manila util.raise_from_cause(newraise, exc_info)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-12-04 20:26:34.638 7550 ERROR manila reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-12-04 20:26:34.638 7550 ERROR manila context)
2016-12-04 20:26:34.638 7550 ERROR manila File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-12-04 20:26:34.638 7550 ERROR manila cursor.execute(statement, parameters)
2016-12-04 20:26:34.638 7550 ERROR manila OperationalError: (pysqlite2.dbapi2.OperationalError) near "ALTER": syntax error [SQL: u'ALTER TABLE shares ALTER COLUMN volume_type_id TYPE VARCHAR(36)']
2016-12-04 20:26:34.638 7550 ERROR manila
----- s n i p -----
-- System Information:
Debian Release: stretch/sid
APT prefers testing-updates
APT policy: (500, 'testing-updates'), (500, 'testing-proposed-updates'), (500, 'testing')
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 manila-common depends on:
ii adduser 3.115
ii dbconfig-common 2.0.6
ii debconf [debconf-2.0] 1.5.59
iu python-manila 1:3.0.0-1
pn python2.7:any <none>
manila-common recommends no packages.
manila-common suggests no packages.
-- debconf information:
manila-common/app-password-confirm: (password omitted)
* manila/admin-password: (password omitted)
* manila-common/password-confirm: (password omitted)
* manila-common/mysql/admin-pass: (password omitted)
manila-common/mysql/app-pass: (password omitted)
manila-common/pgsql/admin-pass: (password omitted)
manila-common/pgsql/app-pass: (password omitted)
* manila/rabbit_password: (password omitted)
* manila/admin-password-confirm: (password omitted)
* manila-common/remote/newhost: openstack.bayour.com
manila-common/pgsql/manualconf:
* manila-common/remote/port:
manila-common/pgsql/changeconf: false
* manila-common/install-error: abort
* manila-common/remove-error: abort
manila-common/internal/skip-preseed: false
* manila-common/purge: true
* manila/rabbit_host: openstack.bayour.com
* manila-common/db/app-user: manila
manila-common/internal/reconfiguring: false
* manila/configure_db: true
* manila-common/upgrade-backup: true
* manila/admin-tenant-name: service
manila-common/passwords-do-not-match:
* manila-common/database-type: mysql
* manila-common/dbconfig-install: true
* manila/auth-host: openstack.bayour.com
manila-common/pgsql/admin-user: postgres
* manila-common/upgrade-error: abort
* manila-common/mysql/method: TCP/IP
* manila-common/mysql/admin-user: root
* manila/admin-user: manila
manila-common/pgsql/no-empty-passwords:
* manila-common/dbconfig-upgrade: true
manila-common/pgsql/authmethod-user: password
* manila/rabbit_userid: openstack
manila-common/pgsql/authmethod-admin: ident
manila-common/db/basepath:
* manila-common/remote/host: openstack.bayour.com
* manila-common/missing-db-package-error: abort
* manila-common/dbconfig-reinstall: false
* manila-common/db/dbname: manila
* manila-common/dbconfig-remove: true
manila-common/pgsql/method: TCP/IP
More information about the Openstack-devel
mailing list