Public bug reported: 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. ** Affects: neutron Importance: Undecided Status: New ** Affects: openstack-ansible Importance: High Status: New -- 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 -- 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
