Bug#846995: marked as done (manila-common: syntax error [SQL: u'ALTER TABLE shares ALTER COLUMN )

Debian Bug Tracking System Sun, 18 Dec 2016 02:42:57 -0800

Your message dated Sun, 18 Dec 2016 11:39:31 +0100
with message-id <[email protected]>
and subject line Closing for now
has caused the Debian Bug report #846995,
regarding manila-common: syntax error [SQL: u'ALTER TABLE shares 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.)


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

--- Begin Message ---

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

--- 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#846995: marked as done (manila-common: syntax error [SQL: u'ALTER TABLE shares ALTER COLUMN )

Reply via email to