Bug#846999: marked as done (barbican-common: syntax error [SQL: u'ALTER TABLE containers ALTER COLUMN )

Debian Bug Tracking System Sun, 18 Dec 2016 02:46:03 -0800

Your message dated Sun, 18 Dec 2016 11:41:27 +0100
with message-id <[email protected]>
and subject line Closing for now
has caused the Debian Bug report #846999,
regarding barbican-common: syntax error [SQL: u'ALTER TABLE containers ALTER 
COLUMN 
to be marked as done.


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

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
846999: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=846999
Debian Bug Tracking System
Contact [email protected] with problems

--- Begin Message ---

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

--- End Message ---

--- Begin Message ---

It's not clear if this bug is valid, closing for now until we have more
info. Discussion is still open, but maybe best on the team's list.

Thomas Goirand (zigo)

--- End Message ---

Bug#846999: marked as done (barbican-common: syntax error [SQL: u'ALTER TABLE containers ALTER COLUMN )

Reply via email to