[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-09-02 Thread OpenStack Infra
Reviewed: https://review.openstack.org/305141 Committed: https://git.openstack.org/cgit/openstack/neutron-vpnaas/commit/?id=be6602854cb6399b44d0768a7ec73055e9e6dd8b Submitter: Jenkins Branch:stable/liberty commit be6602854cb6399b44d0768a7ec73055e9e6dd8b Author: James Page Date: Fri Apr 8

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-05-20 Thread OpenStack Infra
Reviewed: https://review.openstack.org/305135 Committed: https://git.openstack.org/cgit/openstack/neutron-vpnaas/commit/?id=58a5251515b7d58ee55f9604ad882f6a678c9bf4 Submitter: Jenkins Branch:stable/mitaka commit 58a5251515b7d58ee55f9604ad882f6a678c9bf4 Author: James Page Date: Fri Apr 8 1

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-12 Thread OpenStack Infra
Reviewed: https://review.openstack.org/303376 Committed: https://git.openstack.org/cgit/openstack/neutron-vpnaas/commit/?id=3aeae7a3e5a351577002237663ed08ac908d5b45 Submitter: Jenkins Branch:master commit 3aeae7a3e5a351577002237663ed08ac908d5b45 Author: James Page Date: Fri Apr 8 13:17:26

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread Launchpad Bug Tracker
This bug was fixed in the package neutron-vpnaas - 2:8.0.0-0ubuntu2 --- neutron-vpnaas (2:8.0.0-0ubuntu2) xenial; urgency=medium * d/p/fix-nullable-pk.patch: Fix issue with migration step that attempts to set the default for a primary key to NULL; MySQL 5.7 errors on this as

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread Robie Basak
Also: http://dev.mysql.com/doc/refman/5.6/en/create-table.html "A PRIMARY KEY is a unique index where all key columns must be defined as NOT NULL. If they are not explicitly declared as NOT NULL, MySQL declares them so implicitly (and silently). A table can have only one PRIMARY KEY. The name of

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread James Page
** Changed in: neutron-vpnaas (Ubuntu) Status: New => In Progress ** Changed in: neutron-vpnaas (Ubuntu) Importance: Undecided => Critical -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/15678

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread OpenStack Infra
Fix proposed to branch: master Review: https://review.openstack.org/303376 ** Changed in: neutron Status: New => In Progress ** Changed in: neutron Assignee: (unassigned) => James Page (james-page) -- You received this bug notification because you are a member of Ubuntu Bugs, which

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread James Page
Reference: http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-3.html "Columns in a PRIMARY KEY must be NOT NULL, but if declared explicitly as NULL produced no error. Now an error occurs. For example, a statement such as CREATE TABLE t (i INT NULL PRIMARY KEY) is rejected. The same occurs fo

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread Ihar Hrachyshka
** Tags added: db vpnaas -- 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.n

[Bug 1567899] Re: alembic migration failure with mysql 5.7

2016-04-08 Thread Robie Basak
I'm told that putting NOT NULL in the schema should do it, and there should be no consequences because it was enforced like that previously anyway. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1567899