yahoo-eng-team team mailing list archive

[OpenStack Infra <1613299@xxxxxxxxxxxxxxxxxx>]

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 <nate_johnston@xxxxxxxxxxxxxxxxx>
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