neutron

Unknown column 'r.project_id' in FWaaS migrations

Bug #1613299 reported by Travis Truman
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
OpenStack-Ansible
Fix Released
High
Unassigned
OpenStack-Ansible newton-3
neutron
Fix Released
Critical
Nate Johnston
neutron newton-3 "n3"

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.

Tags: db fwaas
Jesse Pretorius (jesse-pretorius)
Changed in openstack-ansible:
milestone: none → newton-3
importance: Undecided → High
Nate Johnston (nate-johnston)
Changed in neutron:
status: New → Confirmed
importance: Undecided → Critical
assignee: nobody → Nate Johnston (nate-johnston)
milestone: none → newton-3
tags: added: db fwaas
OpenStack Infra (hudson-openstack)
Changed in neutron:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to neutron-fwaas (master)

Fix proposed to branch: master
Review: https://review.openstack.org/355511

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on neutron-fwaas (master)

Change abandoned by Nate Johnston (<email address hidden>) on branch: master
Review: https://review.openstack.org/355483
Reason: Abandoned in favor of fixing it https://review.openstack.org/355511

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron-fwaas (master)

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 address hidden>
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
Revision history for this message
Jean-Philippe Evrard (jean-philippe-evrard) wrote :

Ignore this comment, it was fixed because it was master and the upstream bug was fixed.

Changed in openstack-ansible:
status: New → Incomplete
status: Incomplete → Confirmed
status: Confirmed → Fix Released
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix included in openstack/neutron-fwaas 9.0.0.0b3

This issue was fixed in the openstack/neutron-fwaas 9.0.0.0b3 development milestone.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.