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 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
