← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1613299] Re: Unknown column 'r.project_id' in FWaaS migrations

 

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

** Changed in: openstack-ansible
       Status: New => Incomplete

** Changed in: openstack-ansible
       Status: Incomplete => Confirmed

** Changed in: openstack-ansible
       Status: Confirmed => 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:
  Fix Released

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


References