[Bug 2092217] [NEW] [SRU] Missing Group-By Optimization Backport in Yoga and Antelope

[Launchpad Bug Tracker]

You have been subscribed to a public bug by Ubuntu Foundations Team Bug Bot (crichton):

This SRU is related to bug #1918145, which reported slow RBAC queries in
Neutron. The performance issue was addressed upstream through modifying
the SQL queries [1] and using a GROUP BY clause in the Neutron lib [2].

Looking at the Ubuntu Neutron lib package [3], this group by
optimization clause [2] is missing in stable/yoga and stable/antelope,
although it present in Zed, Bobcat, and Caracal

Resources:
[1] https://review.opendev.org/c/openstack/neutron/+/884877 (Upstream neutron change alongside the library optimization)

[2] https://opendev.org/openstack/neutron-
lib/commit/829e97024c2b73dd67bfd8a04c65f03be556eec8 (Neutron lib group
by optimization change that is missing from yoga and antelope)

[3] https://code.launchpad.net/~ubuntu-openstack-
dev/ubuntu/+source/python-neutron-lib/+git/python-neutron-lib (Ubuntu
Neutron lib in the UCA)

** Affects: cloud-archive
     Importance: Undecided
         Status: New

** Affects: cloud-archive/antelope
     Importance: Undecided
         Status: New

** Affects: cloud-archive/bobcat
     Importance: Undecided
         Status: Fix Released

** Affects: cloud-archive/caracal
     Importance: Undecided
         Status: Fix Released

** Affects: cloud-archive/yoga
     Importance: Undecided
         Status: New

** Affects: cloud-archive/zed
     Importance: Undecided
         Status: Fix Released

** Affects: python-neutron-lib (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: patch
-- 
[SRU] Missing Group-By Optimization Backport in Yoga and Antelope
https://bugs.launchpad.net/bugs/2092217
You received this bug notification because you are a member of Ubuntu Sponsors, which is subscribed to the bug report.