[PKG-Openstack-devel] Bug#769764: ironic-common: fails to upgrade from 'sid': No support for ALTER of constraints in SQLite dialect

[Andreas Beckmann]

Package: ironic-common
Version: 2014.2-2
Severity: serious
User: debian-qa at lists.debian.org
Usertags: piuparts

Hi,

during a test with piuparts I noticed your package fails to upgrade from
'sid'.
It installed fine in 'sid', then the upgrade to 'experimental' fails.

>From the attached log (scroll to the bottom...):

  Setting up ironic-common (2014.2-2) ...
  Installing new version of config file /etc/ironic/rootwrap.d/ironic-utils.filters ...
  PKG-Openstack now calling: dbc_go ironic-common configure 2014.1-10
  dbconfig-common: writing config to /etc/dbconfig-common/ironic-common.conf
  INFO  [alembic.migration] Context impl SQLiteImpl.
  INFO  [alembic.migration] Will assume non-transactional DDL.
  INFO  [alembic.migration] Running upgrade 3cb628139ea4 -> 31baaf680d2b, Add Node instance info
  INFO  [alembic.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 100, in main
      CONF.command.func()
    File "/usr/lib/python2.7/dist-packages/ironic/cmd/dbsync.py", line 36, 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 125, in upgrade
      script.run_env()
    File "/usr/lib/python2.7/dist-packages/alembic/script.py", line 203, in run_env
      util.load_python_file(self.dir, 'env.py')
    File "/usr/lib/python2.7/dist-packages/alembic/util.py", line 212, in load_python_file
      module = load_module_py(module_id, path)
    File "/usr/lib/python2.7/dist-packages/alembic/compat.py", line 58, 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 54, in <module>
      run_migrations_online()
    File "/usr/lib/python2.7/dist-packages/ironic/db/sqlalchemy/alembic/env.py", line 51, in run_migrations_online
      context.run_migrations()
    File "<string>", line 7, in run_migrations
    File "/usr/lib/python2.7/dist-packages/alembic/environment.py", line 688, in run_migrations
      self.get_context().run_migrations(**kw)
    File "/usr/lib/python2.7/dist-packages/alembic/migration.py", line 258, in run_migrations
      change(**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 7, in create_unique_constraint
    File "/usr/lib/python2.7/dist-packages/alembic/operations.py", line 621, in create_unique_constraint
      schema=schema, **kw)
    File "/usr/lib/python2.7/dist-packages/alembic/ddl/sqlite.py", line 21, 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
  Processing triggers for libc-bin (2.19-13) ...
  Errors were encountered while processing:
   ironic-common


cheers,

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ironic-common_2014.2-2.log.gz
Type: application/gzip
Size: 15856 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/openstack-devel/attachments/20141116/0140b7e8/attachment.bin>