Your message dated Sun, 18 Dec 2016 11:42:04 +0100
with message-id <[email protected]>
and subject line Closing for now
has caused the Debian Bug report #847000,
regarding neutron-common: Cannot add a NOT NULL column with default value NULL
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.)


-- 
847000: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=847000
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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

--- 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 ---

Reply via email to