Public bug reported: 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, 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) [2] https://github.com/openstack/neutron- lib/commit/829e97024c2b73dd67bfd8a04c65f03be556eec8 (Neutron lib group by optimization change) [3] https://code.launchpad.net/~ubuntu-openstack- dev/ubuntu/+source/python-neutron-lib/+git/python-neutron-lib (Ubuntu Neutron lib in the UCA) ** Affects: python-neutron-lib (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/2092217 Title: [SRU] Missing Group-By Optimization Backport in Yoga and Antelope To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/python-neutron-lib/+bug/2092217/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
