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

[James Page]

Thanks Bryan

I'm happy with the updates and have sponsored them into the selected
targets HOWEVER this bug will need full SRU documentation before we
subscribe the ubuntu-sru team and accept into proposed pockets for
testing.

** Changed in: python-neutron-lib (Ubuntu)
       Status: Invalid => Fix Released

** Changed in: cloud-archive
       Status: Invalid => Fix Released

** Changed in: cloud-archive/zed
       Status: Fix Released => Won't Fix

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to Ubuntu Cloud Archive.
https://bugs.launchpad.net/bugs/2092217

Title:
  [SRU] Missing Group-By Optimization Backport in Yoga and Antelope

Status in Ubuntu Cloud Archive:
  Fix Released
Status in Ubuntu Cloud Archive antelope series:
  New
Status in Ubuntu Cloud Archive bobcat series:
  Fix Released
Status in Ubuntu Cloud Archive caracal series:
  Fix Released
Status in Ubuntu Cloud Archive yoga series:
  New
Status in Ubuntu Cloud Archive zed series:
  Won't Fix
Status in python-neutron-lib package in Ubuntu:
  Fix Released
Status in python-neutron-lib source package in Jammy:
  Confirmed

Bug description:
  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/2092217/+subscriptions