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

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

Reply via email to