Reviewed: https://review.openstack.org/355511 Committed: https://git.openstack.org/cgit/openstack/neutron-fwaas/commit/?id=fd778596122e2ae3fd784149d510f606c03bea28 Submitter: Jenkins Branch: master
commit fd778596122e2ae3fd784149d510f606c03bea28 Author: Nate Johnston <[email protected]> Date: Mon Aug 15 14:52:43 2016 +0000 Fix column_name in migration from project_id change This commit fixes a bug that was introduced in https://review.openstack.org/352216 where an incorrect table name was referenced. This change substitutes in the correct table name. This commit appears to be causing OSA DB migration failures. See: https://bugs.launchpad.net/neutron/+bug/1613299 Change-Id: I9cfb98e418432209840a75647e1683f1b9204c4a Closes-bug: #1613299 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1613299 Title: Unknown column 'r.project_id' in FWaaS migrations Status in neutron: Fix Released Status in openstack-ansible: New Bug description: Running the FWaaS router insertion migration fails with: http://logs.openstack.org/01/354101/4/gate/gate-openstack-ansible- os_nova-ansible-func-ubuntu- trusty/4b14021/console.html#_2016-08-15_13_44_02_455515 Specific issue: "oslo_db.exception.DBError: (pymysql.err.InternalError) (1054, u"Unknown column 'r.project_id' in 'where clause'") [SQL: u'insert into firewall_router_associations select f.id as fw_id, r.id as router_id from firewalls f, routers r where f.tenant_id=r.project_id']" Issue occurs when installing Neutron master using OpenStack-Ansible on Ubuntu 14.04 from source. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1613299/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
