yahoo-eng-team team mailing list archive

[Kevin Benton <1550618@xxxxxxxxxxxxxxxxxx>]

Public bug reported:


We are now getting the following warnings after the QoS RBAC patch
merged:

/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'target_tenant' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('target_tenant', String(length=255), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
  (key, getattr(existing, 'table', None), value))
/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'object_id' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('object_id', String(length=36), ForeignKey('qos_policies.id'), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
  (key, getattr(existing, 'table', None), value))
/opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'action' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('action', String(length=255), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
  (key, getattr(existing, 'table', None), value))

** Affects: neutron
     Importance: Undecided
     Assignee: Kevin Benton (kevinbenton)
         Status: New

** Changed in: neutron
     Assignee: (unassigned) => Kevin Benton (kevinbenton)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1550618

Title:
  sqlalchemy column replacement warnings on rbac tables

Status in neutron:
  New

Bug description:

  We are now getting the following warnings after the QoS RBAC patch
  merged:

  /opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'target_tenant' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('target_tenant', String(length=255), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
    (key, getattr(existing, 'table', None), value))
  /opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'object_id' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('object_id', String(length=36), ForeignKey('qos_policies.id'), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
    (key, getattr(existing, 'table', None), value))
  /opt/stack/neutron/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/base.py:526: SAWarning: Column 'action' on table Table('networkrbacs', MetaData(bind=None), Column('tenant_id', String(length=255), table=<networkrbacs>), Column('id', String(length=36), table=<networkrbacs>, primary_key=True, nullable=False, default=ColumnDefault(<function <lambda> at 0x7fa3bebe7b90>)), Column('target_tenant', String(length=255), table=<networkrbacs>, nullable=False), Column('action', String(length=255), table=<networkrbacs>, nullable=False), Column('object_id', String(length=36), ForeignKey('networks.id'), table=<networkrbacs>, nullable=False), schema=None) being replaced by Column('action', String(length=255), table=<qospolicyrbacs>, nullable=False), which has the same key.  Consider use_labels for select() statements.
    (key, getattr(existing, 'table', None), value))

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1550618/+subscriptions