[PKG-Openstack-devel] Bug#846999: barbican-common: syntax error [SQL: u'ALTER TABLE containers ALTER COLUMN
Turbo Fredriksson
turbo at bayour.com
Sun Dec 4 20:39:40 UTC 2016
Package: barbican-common
Version: 1:3.0.0~rc1-2
Severity: important
----- s n i p -----
Now calling barbican-db-manage upgrade: this may take a while...
2016-12-04 20:36:52.340 8574 WARNING barbican.model.migration.commands [-] !!! Limited support for migration commands using sqlite databases; This operation may not succeed.
2016-12-04 20:36:52.353 8574 INFO alembic.runtime.migration [-] Context impl SQLiteImpl.
2016-12-04 20:36:52.353 8574 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.
2016-12-04 20:36:52.415 8574 INFO alembic.runtime.migration [-] Running upgrade -> 1a0c2cdafb38, create test table
2016-12-04 20:36:52.452 8574 INFO alembic.runtime.migration [-] Running upgrade 1a0c2cdafb38 -> juno, juno_initial
2016-12-04 20:36:53.142 8574 INFO alembic.runtime.migration [-] Running upgrade juno -> 13d127569afa, create_secret_store_metadata_table
2016-12-04 20:36:53.256 8574 INFO alembic.runtime.migration [-] Running upgrade 13d127569afa -> 1e86c18af2dd, add new columns type meta containerId
2016-12-04 20:36:53.424 8574 INFO alembic.runtime.migration [-] Running upgrade 1e86c18af2dd -> cd4106a1a0, add-cert-to-container-type
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage [-] Problem seen trying to run barbican db manage
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage Traceback (most recent call last):
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/cmd/db_manage.py", line 176, in main
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage dm.execute()
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/cmd/db_manage.py", line 164, in execute
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage args.func(args)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/cmd/db_manage.py", line 141, in upgrade
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage commands.upgrade(to_version=args.version, sql_url=args.dburl)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/model/migration/commands.py", line 63, in upgrade
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage alembic_command.upgrade(alembic_cfg, to_version)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage script.run_env()
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage util.load_python_file(self.dir, 'env.py')
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage module = load_module_py(module_id, path)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage mod = imp.load_source(module_id, path, fp)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/model/migration/alembic_migrations/env.py", line 100, in <module>
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage run_migrations_online()
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/model/migration/alembic_migrations/env.py", line 91, in run_migrations_online
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage context.run_migrations()
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "<string>", line 8, in run_migrations
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage self.get_context().run_migrations(**kw)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage step.migration_fn(**kw)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/barbican/model/migration/alembic_migrations/versions/cd4106a1a0_add_cert_to_container_type.py", line 21, in upgrade
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage op.alter_column('containers', 'type', type_=enum_type)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "<string>", line 8, in alter_column
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "<string>", line 3, in alter_column
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1420, in alter_column
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage return operations.invoke(alt)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage return fn(self, operation)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 53, in alter_column
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage **operation.kw
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 160, in alter_column
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage existing_nullable=existing_nullable,
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage return conn.execute(construct, *multiparams, **params)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage return meth(self, multiparams, params)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage return connection._execute_ddl(self, multiparams, params)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage compiled
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage context)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage exc_info
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage context)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage cursor.execute(statement, parameters)
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage OperationalError: (pysqlite2.dbapi2.OperationalError) near "ALTER": syntax error [SQL: u'ALTER TABLE containers ALTER COLUMN type TYPE VARCHAR(11)']
2016-12-04 20:36:53.425 8574 ERROR barbican.cmd.db_manage
ERROR: (pysqlite2.dbapi2.OperationalError) near "ALTER": syntax error [SQL: u'ALTER TABLE containers ALTER COLUMN type TYPE VARCHAR(11)']
dpkg: error processing package barbican-common (--configure):
subprocess installed post-installation script returned error exit status 1
----- 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 barbican-common depends on:
ii adduser 3.115
ii dbconfig-common 2.0.6
ii debconf [debconf-2.0] 1.5.59
ii python-barbican 1:3.0.0~rc1-2
ii python-pysqlite2 2.7.0-1
pn python:any <none>
barbican-common recommends no packages.
barbican-common suggests no packages.
-- debconf information:
* barbican-common/password-confirm: (password omitted)
* barbican-common/mysql/admin-pass: (password omitted)
barbican-common/app-password-confirm: (password omitted)
barbican-common/pgsql/admin-pass: (password omitted)
barbican-common/pgsql/app-pass: (password omitted)
* barbican/rabbit_password: (password omitted)
* barbican/admin-password: (password omitted)
barbican-common/mysql/app-pass: (password omitted)
* barbican/admin-password-confirm: (password omitted)
* barbican-common/db/dbname: barbican
* barbican-common/database-type: mysql
* barbican-common/dbconfig-remove: true
* barbican-common/db/app-user: barbican
* barbican/admin-tenant-name: service
* barbican/rabbit_userid: openstack
barbican-common/internal/skip-preseed: false
* barbican/auth-host: openstack.bayour.com
barbican-common/pgsql/authmethod-user: password
barbican-common/db/basepath:
* barbican/configure_db: true
* barbican-common/install-error: abort
barbican-common/pgsql/method: TCP/IP
barbican-common/pgsql/no-empty-passwords:
* barbican/admin-user: barbican
barbican-common/passwords-do-not-match:
barbican-common/pgsql/changeconf: false
barbican-common/pgsql/manualconf:
* barbican-common/mysql/method: TCP/IP
* barbican/rabbit_host: openstack.bayour.com
* barbican-common/remote/newhost: openstack.bayour.com
* barbican-common/remote/port:
* barbican-common/upgrade-backup: true
* barbican-common/purge: true
* barbican-common/missing-db-package-error: abort
barbican-common/pgsql/authmethod-admin: ident
* barbican-common/remote/host: openstack.bayour.com
* barbican-common/upgrade-error: abort
* barbican-common/remove-error: abort
* barbican-common/dbconfig-upgrade: true
* barbican-common/dbconfig-reinstall: false
* barbican-common/mysql/admin-user: root
barbican-common/pgsql/admin-user: postgres
* barbican-common/dbconfig-install: true
barbican-common/internal/reconfiguring: false
More information about the Openstack-devel
mailing list