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

[Bryan Fraschetti]

This debdiff contains the upstream neutron lib change as a patch in
debian/patches/rbac-group-by-optimization.patch for the yoga release.

Note that in this debdiff, accompanying the above change is a patch for
an unrelated test change: debian/patches/deprecated-tenant-
validation.patch. This patch addresses a test in
neutron_lib/tests/unit/test_context.py which checks for a field that was
deprecated in oslo. In particular, the change removes said test. This
patch was merged upstream right around the time that Yoga was released:
https://opendev.org/openstack/neutron-
lib/commit/a8abe9d592da5bcf065af40e0ba1cd3599ede1e7. As debuild was
failing on the test that this change removes, I chose to include the
commit in the diff

** Patch added: "lp2092217_yoga.debdiff"
   https://bugs.launchpad.net/ubuntu/+source/python-neutron-lib/+bug/2092217/+attachment/5846269/+files/lp2092217_yoga.debdiff

** Description changed:

  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 is missing in stable/yoga and stable/antelope,
+ 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 in preparation of the library optimization)
+ [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)
+ 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)

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

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

Status in python-neutron-lib package in Ubuntu:
  New

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/ubuntu/+source/python-neutron-lib/+bug/2092217/+subscriptions