yahoo-eng-team team mailing list archive

[Rodolfo Alonso <2018000@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

In QoSPlugin._get_ports_with_policy, if the "networks_ids" list is
empty, the filter we apply on the SQL query is empty. That throws the
following warning [1].

Using the last oslo.db and slqalchemy versions, the message is:
  SAWarning: SELECT statement has a cartesian product between FROM element(s) "networks" and FROM element "qos_port_policy_bindings_1".  Apply join condition(s) between each element to resolve.

[1]https://paste.opendev.org/show/bphVO9ULGIXtbC9tVdbd/

** Affects: neutron
     Importance: Low
     Assignee: Rodolfo Alonso (rodolfo-alonso-hernandez)
         Status: New

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

** Changed in: neutron
     Assignee: (unassigned) => Rodolfo Alonso (rodolfo-alonso-hernandez)

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

Title:
  SQL warning retrieving ports if the network list is empty

Status in neutron:
  New

Bug description:
  In QoSPlugin._get_ports_with_policy, if the "networks_ids" list is
  empty, the filter we apply on the SQL query is empty. That throws the
  following warning [1].

  Using the last oslo.db and slqalchemy versions, the message is:
    SAWarning: SELECT statement has a cartesian product between FROM element(s) "networks" and FROM element "qos_port_policy_bindings_1".  Apply join condition(s) between each element to resolve.

  [1]https://paste.opendev.org/show/bphVO9ULGIXtbC9tVdbd/

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