yahoo-eng-team team mailing list archive

[Kevin Benton <1558827@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

The filter hook added in https://review.openstack.org/#/c/255285 causes
SQLAlchemy to add the networks table to the FROM statement without a
restricted join condition. This results in many duplicate rows coming
back from the DB query. This is okay for normal record retrieval because
sqlalchemy would deduplicate the records. However, when calling .count()
on the query, it returns a number far too large.

This breaks the quota engine for plugins that don't use the newer method
of tracking resources.

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

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

** Changed in: neutron
   Importance: Undecided => Critical

** Changed in: neutron
    Milestone: None => mitaka-1

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

Title:
  port filter hook for network tenant id matching breaks counting

Status in neutron:
  New

Bug description:
  The filter hook added in https://review.openstack.org/#/c/255285
  causes SQLAlchemy to add the networks table to the FROM statement
  without a restricted join condition. This results in many duplicate
  rows coming back from the DB query. This is okay for normal record
  retrieval because sqlalchemy would deduplicate the records. However,
  when calling .count() on the query, it returns a number far too large.

  This breaks the quota engine for plugins that don't use the newer
  method of tracking resources.

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