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

2025-03-07 Thread Timo Aaltonen
Hello Bryan, or anyone else affected, Accepted python-neutron-lib into jammy-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/python- neutron-lib/2.20.0-0ubuntu1.1 in a few hours, and then in the -proposed repository. Please help us by testing this new

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

2025-01-22 Thread James Page
@tjaalton as noted in my comment (missing SRU information); I don't usually sponsor without that in place but on this occasion missed that it was not present. I see it is now - thanks @bryanfrashetti -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscri

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

2025-01-22 Thread Bryan Fraschetti
** Description changed: [ Impact ]   * There is a missing performance optimization in the Yoga (2.20.0-0ubuntu1) and Antelope (3.4.0-0ubuntu1) releases of neutron-lib caused by a missing database query optimization at [1], which is present upstream. In particular, the commit at [1] mi

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

2025-01-22 Thread Bryan Fraschetti
** Description changed: [ Impact ]   * There is a missing performance optimization in the Yoga (2.20.0-0ubuntu1) and Antelope (3.4.0-0ubuntu1) releases of neutron-lib caused by a missing database query optimization at [1], which is present upstream. In particular, the commit at [1] mi

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

2025-01-22 Thread Bryan Fraschetti
** Description changed: [ Impact ] - * There is a missing performance optimization in the Yoga +   * There is a missing performance optimization in the Yoga (2.20.0-0ubuntu1) and Antelope (3.4.0-0ubuntu1) releases of neutron-lib caused by a missing database query optimization at [1], wh

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

2025-01-22 Thread Bryan Fraschetti
** 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]. + [ Impact ] - Looking at the Ubuntu Neutron lib

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

2025-01-17 Thread Timo Aaltonen
missing sru information please, don't sponsor uploads without it! -- 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

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

2025-01-14 Thread James Page
Also for the jammy upload you will need to detail why the additional patch for oslo.context behavioural changes is required - I'm guessing without it you see a test failure during the package build? -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed

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

2025-01-14 Thread 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 => Fi

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

2025-01-13 Thread James Page
** Changed in: python-neutron-lib (Ubuntu) Status: Confirmed => Invalid ** Changed in: cloud-archive Status: New => Invalid -- 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:

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

2025-01-10 Thread Bryan Fraschetti
** Changed in: python-neutron-lib (Ubuntu) Assignee: (unassigned) => Bryan Fraschetti (bryanfraschetti) ** Changed in: python-neutron-lib (Ubuntu) Status: New => Confirmed ** Changed in: python-neutron-lib (Ubuntu Jammy) Status: New => Confirmed -- You received this bug notif

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

2025-01-09 Thread Bryan Fraschetti
** No longer affects: cloud-archive/antelope ** Also affects: cloud-archive/antelope Importance: Undecided Status: New ** Also affects: python-neutron-lib (Ubuntu Jammy) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubunt

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

2024-12-20 Thread Simon Quigley
Surely ubuntu-sponsors isn't the right team to sponsor OpenStack uploads? -- 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 Antelo

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

2024-12-19 Thread Ubuntu Foundations Team Bug Bot
The attachment "lp2092217_antelope.debdiff" seems to be a debdiff. The ubuntu-sponsors team has been subscribed to the bug report so that they can review and hopefully sponsor the debdiff. If the attachment isn't a patch, please remove the "patch" flag from the attachment, remove the "patch" tag,

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

2024-12-19 Thread Bryan Fraschetti
** Also affects: cloud-archive Importance: Undecided Status: New ** Also affects: cloud-archive/caracal Importance: Undecided Status: New ** Also affects: cloud-archive/yoga Importance: Undecided Status: New ** Also affects: cloud-archive/zed Importance: Undecide

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

2024-12-19 Thread 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

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

2024-12-19 Thread Bryan Fraschetti
This debdiff contains the upstream neutron lib change as a patch in debian/patches/rbac-group-by-optimization.patch ** Patch added: "lp2092217_antelope.debdiff" https://bugs.launchpad.net/ubuntu/+source/python-neutron-lib/+bug/2092217/+attachment/5846243/+files/lp2092217_antelope.debdiff --

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

2024-12-19 Thread Bryan Fraschetti
** 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],

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

2024-12-19 Thread Bryan Fraschetti
-- 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.ne