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