[PKG-Openstack-devel] Bug#847000: neutron-common: Cannot add a NOT NULL column with default value NULL

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

Package: neutron-common
Version: 2:9.0.0-5
Severity: important

----- s n i p -----
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
Running upgrade for neutron ...
INFO  [alembic.runtime.migration] Context impl SQLiteImpl.
INFO  [alembic.runtime.migration] Will assume non-transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> kilo, kilo_initial
INFO  [alembic.runtime.migration] Running upgrade kilo -> 354db87e3225, nsxv_vdr_metadata.py
INFO  [alembic.runtime.migration] Running upgrade 354db87e3225 -> 599c6a226151, neutrodb_ipam
INFO  [alembic.runtime.migration] Running upgrade 599c6a226151 -> 52c5312f6baf, Initial operations in support of address scopes
INFO  [alembic.runtime.migration] Running upgrade 52c5312f6baf -> 313373c0ffee, Flavor framework
INFO  [alembic.runtime.migration] Running upgrade 313373c0ffee -> 8675309a5c4f, network_rbac
INFO  [alembic.runtime.migration] Running upgrade 8675309a5c4f -> 45f955889773, quota_usage
INFO  [alembic.runtime.migration] Running upgrade 45f955889773 -> 26c371498592, subnetpool hash
INFO  [alembic.runtime.migration] Running upgrade 26c371498592 -> 1c844d1677f7, add order to dnsnameservers
INFO  [alembic.runtime.migration] Running upgrade 1c844d1677f7 -> 1b4c6e320f79, address scope support in subnetpool
INFO  [alembic.runtime.migration] Running upgrade 1b4c6e320f79 -> 48153cb5f051, qos db changes
INFO  [alembic.runtime.migration] Running upgrade 48153cb5f051 -> 9859ac9c136, quota_reservations
INFO  [alembic.runtime.migration] Running upgrade 9859ac9c136 -> 34af2b5c5a59, Add dns_name to Port
INFO  [alembic.runtime.migration] Running upgrade 34af2b5c5a59 -> 59cb5b6cf4d, Add availability zone
INFO  [alembic.runtime.migration] Running upgrade 59cb5b6cf4d -> 13cfb89f881a, add is_default to subnetpool
/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 13cfb89f881a -> 32e5974ada25, Add standard attribute table
INFO  [alembic.runtime.migration] Running upgrade 32e5974ada25 -> ec7fcfbf72ee, Add network availability zone
INFO  [alembic.runtime.migration] Running upgrade ec7fcfbf72ee -> dce3ec7a25c9, Add router availability zone
INFO  [alembic.runtime.migration] Running upgrade dce3ec7a25c9 -> c3a73f615e4, Add ip_version to AddressScope
Traceback (most recent call last):
  File "/usr/bin/neutron-db-manage", line 10, in <module>
    sys.exit(main())
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 686, in main
    return_val |= bool(CONF.command.func(config, CONF.command.name))
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 207, in do_upgrade
    desc=branch, sql=CONF.command.sql)
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 108, in do_alembic_command
    getattr(alembic_command, cmd)(config, *args, **kwargs)
  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/neutron/db/migration/alembic_migrations/env.py", line 120, in <module>
    run_migrations_online()
  File "/usr/lib/python2.7/dist-packages/neutron/db/migration/alembic_migrations/env.py", line 114, 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/neutron/db/migration/alembic_migrations/versions/mitaka/expand/c3a73f615e4_add_ip_version_to_address_scope.py", line 33, in upgrade
    sa.Column('ip_version', sa.Integer(), nullable=False))
  File "<string>", line 8, in add_column
  File "<string>", line 3, in add_column
  File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1541, in add_column
    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 123, in add_column
    schema=schema
  File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 172, in add_column
    self._exec(base.AddColumn(table_name, column, schema=schema))
  File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec
    return conn.execute(construct, *multiparams, **params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
    return connection._execute_ddl(self, multiparams, params)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
    compiled
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
    util.raise_from_cause(newraise, exc_info)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb, cause=cause)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
    context)
  File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (pysqlite2.dbapi2.OperationalError) Cannot add a NOT NULL column with default value NULL [SQL: u'ALTER TABLE address_scopes ADD COLUMN ip_version INTEGER NOT NULL']
dpkg: error processing package neutron-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 neutron-common depends on:
ii  adduser                3.115
ii  dbconfig-common        2.0.6
ii  debconf [debconf-2.0]  1.5.59
ii  dpkg-dev               1.18.15
ii  python-mysqldb         1.3.7-1+b1
ii  python-neutron         2:9.0.0-5
ii  python-pyparsing       2.1.10+dfsg1-1
ii  python-sqlalchemy      1.0.15+ds1-1
pn  python2.7:any          <none>
pn  python:any             <none>
ii  sqlite3                3.15.1-1

neutron-common recommends no packages.

neutron-common suggests no packages.

-- debconf information:
* neutron/admin-password: (password omitted)
  neutron-common/pgsql/admin-pass: (password omitted)
  neutron-common/mysql/app-pass: (password omitted)
* neutron/nova_admin_password: (password omitted)
* neutron/rabbit_password: (password omitted)
  neutron-common/pgsql/app-pass: (password omitted)
* neutron-common/mysql/admin-pass: (password omitted)
* neutron/admin-password-confirm: (password omitted)
  neutron-common/app-password-confirm: (password omitted)
* neutron-common/password-confirm: (password omitted)
* neutron-common/db/app-user: neutron
* neutron-common/db/dbname: neutron
  neutron-common/passwords-do-not-match:
* neutron-common/upgrade-error: abort
* neutron-common/upgrade-backup: true
* neutron-common/missing-db-package-error: abort
* neutron/rabbit_userid: openstack
* neutron-common/mysql/admin-user: root
  neutron-common/pgsql/changeconf: false
* neutron-common/remote/host: openstack.bayour.com
* neutron/plugin-select: ml2
  neutron-common/internal/skip-preseed: false
* neutron/admin-tenant-name: service
* neutron/tenant_network_type: gre
  neutron-common/pgsql/authmethod-user: password
  neutron-common/db/basepath:
* neutron-common/remote/newhost: openstack.bayour.com
* neutron-common/dbconfig-upgrade: true
* neutron/auth-host: openstack.bayour.com
* neutron/admin-user: neutron
* neutron/nova_region: europe-london
* neutron/tunnel_id_ranges: 1:1000
  neutron-common/pgsql/admin-user: postgres
* neutron-common/remove-error: abort
* neutron/enable_tunneling: true
  neutron-common/internal/reconfiguring: false
* neutron-common/database-type: mysql
  neutron-common/pgsql/manualconf:
* neutron/rabbit_host: openstack.bayour.com
* neutron/nova_admin_tenant_name: service
* neutron/nova_url: http://openstack.bayour.com:8774/v2
* neutron-common/mysql/method: TCP/IP
* neutron/nova_admin_username: neutron
  neutron-common/pgsql/no-empty-passwords:
* neutron/local_ip:
* neutron-common/remote/port:
* neutron-common/purge: true
* neutron-common/dbconfig-install: true
* neutron-common/dbconfig-reinstall: false
  neutron-common/pgsql/method: TCP/IP
* neutron/nova_admin_tenant_id:
* neutron/configure_db: true
* neutron-common/install-error: abort
* neutron-common/dbconfig-remove: true
  neutron-common/pgsql/authmethod-admin: ident

More information about the Openstack-devel mailing list