neutron

  1. Bug #1918145
  2. Comment #72

Comment 72 for bug 1918145

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Related fix merged to neutron-lib (stable/2023.1)

Reviewed: https://review.opendev.org/c/openstack/neutron-lib/+/885080
Committed: https://opendev.org/openstack/neutron-lib/commit/86ea887de64bba3d48a245884aea961b04afad0a
Submitter: "Zuul (22348)"
Branch: stable/2023.1

commit 86ea887de64bba3d48a245884aea961b04afad0a
Author: Rodolfo Alonso Hernandez <email address hidden>
Date: Sun May 28 17:43:30 2023 +0200

    Add a "GROUP BY" clause on queries with RBAC entries

    As reported in the Neutron patch [1], this change introduce a
    "GROUP BY" clause on the SQL queries with RBAC entries. With [1],
    all resouces with RBAC entries ('network', 'qospolicy',
    'securitygroup', 'addressscope', 'subnetpool', 'addressgroup') will
    load the RBAC entries with "joined" strategy.

    Because of the low cardinality of the RBAC query when all the RBAC
    registers are in one single project, this patch groups the resource
    queries by the resource ID. That will reduce the results returned by
    the SQL engine to only the singular registers required.

    [1]https://review.opendev.org/c/openstack/neutron/+/884877

    Related-Bug: #1918145
    Change-Id: I800e0356714d59ba93ab6252c77be0a82f024055
    (cherry picked from commit 829e97024c2b73dd67bfd8a04c65f03be556eec8)