[PKG-Openstack-devel] Bug#846997: ironic-common: No support for ALTER of constraints in SQLite dialect

Turbo Fredriksson turbo at bayour.com
Sun Dec 4 20:35:48 UTC 2016


Package: ironic-common
Version: 1:6.2.0-1
Severity: important

----- s n i p -----
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 2581ebaf0cb2, initial migration
INFO  [alembic.runtime.migration] Running upgrade 2581ebaf0cb2 -> 21b331f883ef, Add provision_updated_at
INFO  [alembic.runtime.migration] Running upgrade 21b331f883ef -> 3cb628139ea4, Nodes add console enabled
/usr/lib/python2.7/dist-packages/alembic/util/messaging.py:69: UserWarning: Skipping unsupported ALTER for creation of implicit constraint
  warnings.warn(msg)
INFO  [alembic.runtime.migration] Running upgrade 3cb628139ea4 -> 31baaf680d2b, Add Node instance info
INFO  [alembic.runtime.migration] Running upgrade 31baaf680d2b -> 3bea56f25597, add unique constraint to instance_uuid
CRITI [ironic] NotImplementedError: No support for ALTER of constraints in SQLite dialect
Traceback (most recent call last):
  File "/usr/bin/ironic-dbsync", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/dist-packages/ironic/cmd/dbsync.py", line 103, in main
    CONF.command.func()
  File "/usr/lib/python2.7/dist-packages/ironic/cmd/dbsync.py", line 35, in upgrade
    migration.upgrade(CONF.command.revision)
  File "/usr/lib/python2.7/dist-packages/ironic/db/migration.py", line 36, in upgrade
    return get_backend().upgrade(version)
  File "/usr/lib/python2.7/dist-packages/ironic/db/sqlalchemy/migration.py", line 56, in upgrade
    alembic.command.upgrade(config, revision or 'head')
  File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade
    script.run_env()
  File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 407, in run_env
    util.load_python_file(self.dir, 'env.py')
  File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 93, in load_python_file
    module = load_module_py(module_id, path)
  File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py
    mod = imp.load_source(module_id, path, fp)
  File "/usr/lib/python2.7/dist-packages/ironic/db/sqlalchemy/alembic/env.py", line 61, in <module>
    run_migrations_online()
  File "/usr/lib/python2.7/dist-packages/ironic/db/sqlalchemy/alembic/env.py", line 58, in run_migrations_online
    context.run_migrations()
  File "<string>", line 8, in run_migrations
  File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations
    self.get_context().run_migrations(**kw)
  File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations
    step.migration_fn(**kw)
  File "/usr/lib/python2.7/dist-packages/ironic/db/sqlalchemy/alembic/versions/3bea56f25597_add_unique_constraint_to_instance_uuid.py", line 33, in upgrade
    ["instance_uuid"])
  File "<string>", line 8, in create_unique_constraint
  File "<string>", line 3, in create_unique_constraint
  File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 394, in create_unique_constraint
    return operations.invoke(op)
  File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke
    return fn(self, operation)
  File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 135, in create_constraint
    operation.to_constraint(operations.migration_context)
  File "/usr/lib/python2.7/dist-packages/alembic/ddl/sqlite.py", line 34, in add_constraint
    "No support for ALTER of constraints in SQLite dialect")
NotImplementedError: No support for ALTER of constraints in SQLite dialect
dpkg: error processing package ironic-common (--configure):
 subprocess installed post-installation script returned error exit status 1
Setting up heat-common (1:7.0.0-1) ...
PKG-Openstack now calling: dbc_go heat-common configure
dbconfig-common: writing config to /etc/dbconfig-common/heat-common.conf
----- 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 ironic-common depends on:
ii  adduser                3.115
ii  dbconfig-common        2.0.6
ii  debconf [debconf-2.0]  1.5.59
ii  ipmitool               1.8.18-2
ii  lsb-base               9.20161125
ii  python-ironic          1:6.2.0-1
pn  python:any             <none>
ii  sqlite3                3.15.1-1
ii  sudo                   1.8.17p1-2

ironic-common recommends no packages.

ironic-common suggests no packages.

-- debconf information:
  ironic-common/pgsql/app-pass: (password omitted)
  ironic-common/app-password-confirm: (password omitted)
* ironic/admin-password: (password omitted)
* ironic-common/password-confirm: (password omitted)
  ironic-common/mysql/app-pass: (password omitted)
* ironic-common/mysql/admin-pass: (password omitted)
* ironic/admin-password-confirm: (password omitted)
  ironic-common/pgsql/admin-pass: (password omitted)
* ironic/rabbit_password: (password omitted)
* ironic-common/remote/port:
* ironic-common/database-type: mysql
* ironic-common/dbconfig-install: true
  ironic-common/pgsql/no-empty-passwords:
* ironic/enabled_drivers: pxe_ipmitool, pxe_ipminative, pxe_ssh, pxe_seamicro, pxe_iboot, pxe_ilo, pxe_drac, pxe_snmp
  ironic-common/passwords-do-not-match:
* ironic-common/remote/host: openstack.bayour.com
* ironic/admin-tenant-name: service
* ironic-common/purge: true
* ironic-common/dbconfig-upgrade: true
  ironic-common/pgsql/manualconf:
  ironic-common/pgsql/authmethod-user: password
  ironic-common/db/basepath:
  ironic-common/pgsql/admin-user: postgres
* ironic-common/dbconfig-remove: true
* ironic-common/mysql/method: TCP/IP
* ironic/configure_db: true
  ironic-common/internal/reconfiguring: false
* ironic-common/upgrade-error: abort
  ironic-common/internal/skip-preseed: false
  ironic-common/pgsql/method: TCP/IP
* ironic-common/mysql/admin-user: root
* ironic-common/remote/newhost: openstack.bayour.com
* ironic-common/missing-db-package-error: abort
* ironic/admin-user: ironic
* ironic-common/db/app-user: ironic
  ironic-common/pgsql/changeconf: false
* ironic-common/install-error: abort
* ironic-common/remove-error: abort
* ironic/rabbit_host: openstack.bayour.com
* ironic/auth-host: openstack.bayour.com
* ironic-common/dbconfig-reinstall: false
* ironic-common/upgrade-backup: true
* ironic-common/db/dbname: ironic
  ironic-common/pgsql/authmethod-admin: ident
* ironic/rabbit_userid: openstack



More information about the Openstack-devel mailing list