[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron Milestone: kilo-1 => 2015.1.0 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron (Ubuntu) Importance: Undecided => Medium ** Changed in: neutron (Ubuntu) Status: Confirmed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
I'm not sure this is entirely fixed. I'm seeing very similar behavior running Percona XtraDB Cluster 5.5.39-36.0-55, and neutron 2014.2.1 (the migrations come from: python-neutron-2014.2.1-6.el7ost.noarch): Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11549 Server version: 5.5.39-36.0-55 Percona XtraDB Cluster (GPL), Release rel36.0, Revision 824, WSREP version 25.11, wsrep_25.11.r4023 Copyright (c) 2009-2014 Percona LLC and/or its affiliates Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show tables; Empty set (0.00 sec) mysql> neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini current INFO [alembic.migration] Context impl MySQLImpl. INFO [alembic.migration] Will assume non-transactional DDL. Current revision for mysql://neutron:X@10.202.117.5/neutron: None neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugin.ini upgrade head INFO [alembic.migration] Context impl MySQLImpl. INFO [alembic.migration] Will assume non-transactional DDL. INFO [alembic.migration] Running upgrade None -> havana, havana_initial INFO [alembic.migration] Running upgrade havana -> e197124d4b9, add unique constraint to members INFO [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a unique constraint on (agent_type, host) columns to prevent a race condition when an agent entry is 'upserted'. INFO [alembic.migration] Running upgrade 1fcfc149aca4 -> 50e86cb2637a, nsx_mappings INFO [alembic.migration] Running upgrade 50e86cb2637a -> 1421183d533f, NSX DHCP/metadata support INFO [alembic.migration] Running upgrade 1421183d533f -> 3d3cb89d84ee, nsx_switch_mappings INFO [alembic.migration] Running upgrade 3d3cb89d84ee -> 4ca36cfc898c, nsx_router_mappings INFO [alembic.migration] Running upgrade 4ca36cfc898c -> 27cc183af192, ml2_vnic_type INFO [alembic.migration] Running upgrade 27cc183af192 -> 50d5ba354c23, ml2 binding:vif_details INFO [alembic.migration] Running upgrade 50d5ba354c23 -> 157a5d299379, ml2 binding:profile INFO [alembic.migration] Running upgrade 157a5d299379 -> 3d2585038b95, VMware NSX rebranding INFO [alembic.migration] Running upgrade 3d2585038b95 -> abc88c33f74f, lb stats INFO [alembic.migration] Running upgrade abc88c33f74f -> 1b2580001654, nsx_sec_group_mapping INFO [alembic.migration] Running upgrade 1b2580001654 -> e766b19a3bb, nuage_initial INFO [alembic.migration] Running upgrade e766b19a3bb -> 2eeaf963a447, floatingip_status INFO [alembic.migration] Running upgrade 2eeaf963a447 -> 492a106273f8, Brocade ML2 Mech. Driver INFO [alembic.migration] Running upgrade 492a106273f8 -> 24c7ea5160d7, Cisco CSR VPNaaS INFO [alembic.migration] Running upgrade 24c7ea5160d7 -> 81c553f3776c, bsn_consistencyhashes INFO [alembic.migration] Running upgrade 81c553f3776c -> 117643811bca, nec: delete old ofc mapping tables INFO [alembic.migration] Running upgrade 117643811bca -> 19180cf98af6, nsx_gw_devices INFO [alembic.migration] Running upgrade 19180cf98af6 -> 33dd0a9fa487, embrane_lbaas_driver INFO [alembic.migration] Running upgrade 33dd0a9fa487 -> 2447ad0e9585, Add IPv6 Subnet properties INFO [alembic.migration] Running upgrade 2447ad0e9585 -> 538732fa21e1, NEC Rename quantum_id to neutron_id INFO [alembic.migration] Running upgrade 538732fa21e1 -> 5ac1c354a051, n1kv segment allocs for cisco n1kv plugin INFO [alembic.migration] Running upgrade 5ac1c354a051 -> icehouse, icehouse INFO [alembic.migration] Running upgrade icehouse -> 54f7549a0e5f, set_not_null_peer_address INFO [alembic.migration] Running upgrade 54f7549a0e5f -> 1e5dd1d09b22, set_not_null_fields_lb_stats INFO [alembic.migration] Running upgrade 1e5dd1d09b22 -> b65aa907aec, set_length_of_protocol_field INFO [alembic.migration] Running upgrade b65aa907aec -> 33c3db036fe4, set_length_of_description_field_metering INFO [alembic.migration] Running upgrade 33c3db036fe4 -> 4eca4a84f08a, Remove ML2 Cisco Credentials DB INFO [alembic.migration] Running upgrade 4eca4a84f08a -> d06e871c0d5, set_admin_state_up_not_null_ml2 INFO [alembic.migration] Running upgrade d06e871c0d5 -> 6be312499f9, set_not_null_vlan_id_cisco INFO [alembic.migration] Running upgrade 6be312499f9 -> 1b837a7125a9, Cisco APIC Mechanism Driver INFO [alembic.migration] Running upgrade 1b837a7125a9 -> 10cd28e692e9, nuage_extraroute INFO [alembic.migration] Running upgrade 10cd28e692e9 -> 2db5203cb7a9, nuage_floatingip INFO [alembic.migration] Running upgrade 2db5203cb7a9 -> 5446f2a45467, set_server_default INFO [alembic.migration] Running upgrade 5446f2a45467 -> db_healing, Include all tables and make migrations unconditional. INFO [ale
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: neutron (Ubuntu) Status: New => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron/juno Importance: Undecided => Medium ** Tags removed: in-stable-juno juno-backport-potential ** Changed in: neutron/juno Assignee: (unassigned) => Jakub Libosvar (libosvar) ** Tags removed: clean database error install networking neutron -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron/juno Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron/juno Status: New => Fix Committed ** Changed in: neutron/juno Milestone: None => 2014.2.1 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Also affects: neutron/juno 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/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Reviewed: https://review.openstack.org/136710 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=467a4496cfcd74b473730d2baa667fd633e4d0b3 Submitter: Jenkins Branch:stable/juno commit 467a4496cfcd74b473730d2baa667fd633e4d0b3 Author: Jakub Libosvar Date: Fri Oct 31 15:49:40 2014 +0100 Drop and recreate FK if adding new PK to routerl3bindings Since MySQL 5.6 FK columns cannot be altered. As a workaround we can drop the FK before ALTER COLUMN and then recreate it. Change-Id: Icd1b3075cf29a6b0c477a4ddea2e6ebee91baef8 Closes-Bug: 1384555 (cherry picked from commit b5f1cc48b877caaebc944154d56a8bb4060aa9b0) ** Tags added: in-stable-juno -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Reviewed: https://review.openstack.org/132273 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=b5f1cc48b877caaebc944154d56a8bb4060aa9b0 Submitter: Jenkins Branch:master commit b5f1cc48b877caaebc944154d56a8bb4060aa9b0 Author: Jakub Libosvar Date: Fri Oct 31 15:49:40 2014 +0100 Drop and recreate FK if adding new PK to routerl3bindings Since MySQL 5.6 FK columns cannot be altered. As a workaround we can drop the FK before ALTER COLUMN and then recreate it. Change-Id: Icd1b3075cf29a6b0c477a4ddea2e6ebee91baef8 Closes-Bug: 1384555 ** Changed in: neutron Status: In Progress => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron Milestone: None => kilo-1 ** Changed in: neutron Importance: Undecided => Medium ** Tags added: juno-backport-potential -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
I tried the patch from c#17 in a packstack install on fedora 21. After dropping the old neutron database and rebuilding it, the migration now works for me -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Changed in: neutron Assignee: Lars Kellogg-Stedman (larsks) => Jakub Libosvar (libosvar) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Fix proposed to branch: master Review: https://review.openstack.org/132275 ** Changed in: neutron Assignee: Jakub Libosvar (libosvar) => Lars Kellogg-Stedman (larsks) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Fix proposed to branch: master Review: https://review.openstack.org/132273 ** Changed in: neutron Status: Won't Fix => In Progress ** Changed in: neutron Assignee: Ann Kamyshnikova (akamyshnikova) => Jakub Libosvar (libosvar) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Interesting as on MySQL 5.6 I still don't have any errors, tried mariadb 10.1 and migrations still worked. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
The problem since MySQL 5.6 forbids to alter column with FK constraint. I tested solution we drop both FKs (router_id, l3_agent_id), set new primary key for l3_agent_id and then re-create FKs and it works. I'll send patch soon. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
We're seeing this issue on Fedora 21 with mariadb-10.0.14-7.fc21.x86_64, it doesn't reproduce on Fedora 20 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
I used 10.0.14 and migrations work. I this is problem of current 10.0 versionof MariaDB. MySQL works fine and it is tested a lot. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
Due to this bug Neutron will only work with version <= 5.5 of mysql/mariadb, e.g. older versions. Downgrading to 5.5 isn't a solution, it's a workaround! It also means there is no database upgrade path for OpenStack, and this version limitation isn't mentioned anywhere in the documentation. I'd say that's a pretty big deal that somebody should look at! If not a Neutron core developer, then somebody that works on SQLAlchemy. If nobody is willing to address the actual technical issue then at least the version limitation should be added to the documentation. Can't force you to work on this, just saying that I think ignoring this would be a mistake. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
I think since this is problem with specific version of sql backend while other versions work correctly there's no need to fix this. ** Changed in: neutron Status: Opinion => Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1384555] Re: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0
** Summary changed: - Openstack Neutron Database error on filling database + SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1384555 Title: SQL error during alembic.migration when populating Neutron database on MariaDB 10.0 To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1384555/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs