← Back to team overview

yahoo-eng-team team mailing list archive

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

 

** Also affects: openstack-ansible
   Importance: Undecided
       Status: New

** Changed in: openstack-ansible
    Milestone: None => newton-3

** Changed in: openstack-ansible
   Importance: Undecided => High

-- 
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:
  New
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


References