Public bug reported: A neutron database upgrade using the master branches results in a traceback that includes "Unknown column 'r.tenant_id' in 'where clause'".
The upgrade command is: neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head It seems that it may be related to the following change in neutron- fwaas: commit c3e491cae388713bb175d803de6a216a8816b816 Author: Henry Gessau <[email protected]> Date: Thu Jul 14 13:59:31 2016 -0400 Rename DB columns: tenant -> project All occurences of ``tenant_id`` across the neutron database are being renamed to ``project_id``. This neutron-fwaas change accompanies the neutron change: I87a8ef342ccea004731ba0192b23a8e79bc382dc Partially-Implements: blueprint keystone-v3 Change-Id: I984502745629280c033e52f0f1c06fc268fa0255 Meanwhile, neutron_fwaas/db/migration/alembic_migrations/versions/540142f314f4_fwaas_router_insertion.py still has tenant_id in the SQL_STATEMENT: SQL_STATEMENT = ( "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.%s" ) Attached is a full traceback. ** Affects: neutron Importance: Undecided Status: New ** Attachment added: "neutron-db-manage-traceback.log" https://bugs.launchpad.net/bugs/1611834/+attachment/4718404/+files/neutron-db-manage-traceback.log -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1611834 Title: [neutron-fwaas] "Unknown column 'r.tenant_id' in 'where clause'" Status in neutron: New Bug description: A neutron database upgrade using the master branches results in a traceback that includes "Unknown column 'r.tenant_id' in 'where clause'". The upgrade command is: neutron-db-manage --config-file /etc/neutron/neutron.conf --config- file /etc/neutron/plugins/ml2/ml2_conf.ini upgrade head It seems that it may be related to the following change in neutron- fwaas: commit c3e491cae388713bb175d803de6a216a8816b816 Author: Henry Gessau <[email protected]> Date: Thu Jul 14 13:59:31 2016 -0400 Rename DB columns: tenant -> project All occurences of ``tenant_id`` across the neutron database are being renamed to ``project_id``. This neutron-fwaas change accompanies the neutron change: I87a8ef342ccea004731ba0192b23a8e79bc382dc Partially-Implements: blueprint keystone-v3 Change-Id: I984502745629280c033e52f0f1c06fc268fa0255 Meanwhile, neutron_fwaas/db/migration/alembic_migrations/versions/540142f314f4_fwaas_router_insertion.py still has tenant_id in the SQL_STATEMENT: SQL_STATEMENT = ( "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.%s" ) Attached is a full traceback. To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1611834/+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
