Public bug reported: the migration step 56893333aa52_fix_identifier_map_fk fails to work against mysql 5.7 - I validated against mysql-5.5 in trusty as well and its fine against this version of MySQL.
Error: (1171, u'All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead') Command: [SQL: u'ALTER TABLE cisco_csr_identifier_map MODIFY ipsec_site_conn_id VARCHAR(36) NULL'] Log trace 2016-04-08 11:28:36 INFO shared-db-relation-changed INFO [alembic.runtime.migration] Running upgrade kilo -> 56893333aa52, fix identifier map fk 2016-04-08 11:28:36 INFO shared-db-relation-changed Traceback (most recent call last): 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/bin/neutron-db-manage", line 10, in <module> 2016-04-08 11:28:36 INFO shared-db-relation-changed sys.exit(main()) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 749, in main 2016-04-08 11:28:36 INFO shared-db-relation-changed return_val |= bool(CONF.command.func(config, CONF.command.name)) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 225, in do_upgrade 2016-04-08 11:28:36 INFO shared-db-relation-changed desc=branch, sql=CONF.command.sql) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron/db/migration/cli.py", line 127, in do_alembic_command 2016-04-08 11:28:36 INFO shared-db-relation-changed getattr(alembic_command, cmd)(config, *args, **kwargs) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/command.py", line 174, in upgrade 2016-04-08 11:28:36 INFO shared-db-relation-changed script.run_env() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/script/base.py", line 397, in run_env 2016-04-08 11:28:36 INFO shared-db-relation-changed util.load_python_file(self.dir, 'env.py') 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/util/pyfiles.py", line 81, in load_python_file 2016-04-08 11:28:36 INFO shared-db-relation-changed module = load_module_py(module_id, path) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/util/compat.py", line 79, in load_module_py 2016-04-08 11:28:36 INFO shared-db-relation-changed mod = imp.load_source(module_id, path, fp) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron_vpnaas/db/migration/alembic_migrations/env.py", line 87, in <module> 2016-04-08 11:28:36 INFO shared-db-relation-changed run_migrations_online() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron_vpnaas/db/migration/alembic_migrations/env.py", line 78, in run_migrations_online 2016-04-08 11:28:36 INFO shared-db-relation-changed context.run_migrations() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "<string>", line 8, in run_migrations 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/runtime/environment.py", line 797, in run_migrations 2016-04-08 11:28:36 INFO shared-db-relation-changed self.get_context().run_migrations(**kw) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/runtime/migration.py", line 312, in run_migrations 2016-04-08 11:28:36 INFO shared-db-relation-changed step.migration_fn(**kw) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/neutron_vpnaas/db/migration/alembic_migrations/versions/liberty/contract/56893333aa52_fix_identifier_map_fk.py", line 57, in upgrade 2016-04-08 11:28:36 INFO shared-db-relation-changed existing_nullable=True) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "<string>", line 8, in alter_column 2016-04-08 11:28:36 INFO shared-db-relation-changed File "<string>", line 3, in alter_column 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/operations/ops.py", line 1414, in alter_column 2016-04-08 11:28:36 INFO shared-db-relation-changed return operations.invoke(alt) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/operations/base.py", line 318, in invoke 2016-04-08 11:28:36 INFO shared-db-relation-changed return fn(self, operation) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/operations/toimpl.py", line 53, in alter_column 2016-04-08 11:28:36 INFO shared-db-relation-changed **operation.kw 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/ddl/mysql.py", line 66, in alter_column 2016-04-08 11:28:36 INFO shared-db-relation-changed else existing_autoincrement 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 118, in _exec 2016-04-08 11:28:36 INFO shared-db-relation-changed return conn.execute(construct, *multiparams, **params) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute 2016-04-08 11:28:36 INFO shared-db-relation-changed return meth(self, multiparams, params) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection 2016-04-08 11:28:36 INFO shared-db-relation-changed return connection._execute_ddl(self, multiparams, params) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl 2016-04-08 11:28:36 INFO shared-db-relation-changed compiled 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context 2016-04-08 11:28:36 INFO shared-db-relation-changed context) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception 2016-04-08 11:28:36 INFO shared-db-relation-changed util.raise_from_cause(newraise, exc_info) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 200, in raise_from_cause 2016-04-08 11:28:36 INFO shared-db-relation-changed reraise(type(exception), exception, tb=exc_tb) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context 2016-04-08 11:28:36 INFO shared-db-relation-changed context) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute 2016-04-08 11:28:36 INFO shared-db-relation-changed cursor.execute(statement, parameters) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 158, in execute 2016-04-08 11:28:36 INFO shared-db-relation-changed result = self._query(query) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/cursors.py", line 308, in _query 2016-04-08 11:28:36 INFO shared-db-relation-changed conn.query(q) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 820, in query 2016-04-08 11:28:36 INFO shared-db-relation-changed self._affected_rows = self._read_query_result(unbuffered=unbuffered) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1002, in _read_query_result 2016-04-08 11:28:36 INFO shared-db-relation-changed result.read() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 1285, in read 2016-04-08 11:28:36 INFO shared-db-relation-changed first_packet = self.connection._read_packet() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 966, in _read_packet 2016-04-08 11:28:36 INFO shared-db-relation-changed packet.check_error() 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/connections.py", line 394, in check_error 2016-04-08 11:28:36 INFO shared-db-relation-changed err.raise_mysql_exception(self._data) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception 2016-04-08 11:28:36 INFO shared-db-relation-changed _check_mysql_exception(errinfo) 2016-04-08 11:28:36 INFO shared-db-relation-changed File "/usr/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception 2016-04-08 11:28:36 INFO shared-db-relation-changed raise errorclass(errno, errorvalue) 2016-04-08 11:28:36 INFO shared-db-relation-changed oslo_db.exception.DBError: (pymysql.err.DataError) (1171, u'All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead') [SQL: u'ALTER TABLE cisco_csr_identifier_map MODIFY ipsec_site_conn_id VARCHAR(36) NULL'] ProblemType: Bug DistroRelease: Ubuntu 16.04 Package: python-neutron-vpnaas 2:8.0.0-0ubuntu1 ProcVersionSignature: User Name 4.4.0-17.33-generic 4.4.6 Uname: Linux 4.4.0-17-generic x86_64 ApportVersion: 2.20.1-0ubuntu1 Architecture: amd64 Date: Fri Apr 8 11:39:55 2016 Ec2AMI: ami-00000101 Ec2AMIManifest: FIXME Ec2AvailabilityZone: nova Ec2InstanceType: m1.small.osci Ec2Kernel: unavailable Ec2Ramdisk: unavailable PackageArchitecture: all SourcePackage: neutron-vpnaas UpgradeStatus: No upgrade log present (probably fresh install) mtime.conffile..etc.neutron.neutron.vpnaas.conf: 2016-04-08T11:34:40.736000 ** Affects: neutron Importance: Undecided Status: New ** Affects: neutron-vpnaas (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug ec2-images xenial ** Also affects: neutron Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1567899 Title: alembic migration failure with mysql 5.7 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1567899/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs