yahoo-eng-team team mailing list archive

[Corey Bryant <corey.bryant@xxxxxxxxxxxxx>]

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 <gessau@xxxxxxxxx>
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 <gessau@xxxxxxxxx>
  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