Wednesday, 2025-12-10

opendevreviewGregory Thiemonge proposed openstack/octavia stable/2025.1: Update diskimage-create.sh to use noble as default  https://review.opendev.org/c/openstack/octavia/+/97034108:31
opendevreviewIvan Anfimov proposed openstack/octavia-dashboard stable/2025.2: Optimize empty loadbalancer page  https://review.opendev.org/c/openstack/octavia-dashboard/+/97037513:14
opendevreviewIvan Anfimov proposed openstack/octavia-dashboard stable/2025.1: Optimize empty loadbalancer page  https://review.opendev.org/c/openstack/octavia-dashboard/+/97037713:14
opendevreviewMerged openstack/octavia-dashboard master: Optimize empty loadbalancer page  https://review.opendev.org/c/openstack/octavia-dashboard/+/96929513:15
opendevreviewThéo Van Gyzel proposed openstack/octavia master: API data mapping performance enhancements  https://review.opendev.org/c/openstack/octavia/+/97040414:59
theovgHey all15:07
theovgIn an effort to improve API performance, I've started a patch and I would like some input before proceeding with more work and cleanup15:07
theovgEssentially DB model -> API model instead of DB model -> Data model -> API model15:07
theovghttps://review.opendev.org/c/openstack/octavia/+/97040415:07
theovgI'm getting the following improvements with the three calls I've worked on for now (same DevStack, same data):15:07
theovg- openstack loadbalancer show : 3.93s to 0.08s15:07
theovg- openstack loadbalancer listener show : 4.22s to 0.05s15:07
theovg- openstack loadbalancer status show : 5.25s to 2.88s15:07
opendevreviewMerged openstack/octavia-tempest-plugin master: Remove outdated comments from requirements files  https://review.opendev.org/c/openstack/octavia-tempest-plugin/+/96294615:07
opendevreviewMerged openstack/octavia-tempest-plugin master: Remove useless cover target  https://review.opendev.org/c/openstack/octavia-tempest-plugin/+/96294715:07
johnsom#startmeeting Octavia16:01
opendevmeetMeeting started Wed Dec 10 16:01:00 2025 UTC and is due to finish in 60 minutes.  The chair is johnsom. Information about MeetBot at http://wiki.debian.org/MeetBot.16:01
opendevmeetUseful Commands: #action #agreed #help #info #idea #link #topic #startvote.16:01
opendevmeetThe meeting name has been set to 'octavia'16:01
gthiemongeo/16:01
johnsomHello everyone16:01
rcruise-redhatGood morning!16:01
johnsom#topic Announcements16:02
johnsomThe only announcement I have is we are getting into the holiday season in the US and I will not be available until the 7th.16:02
johnsomWe can either cancel the weekly meeting for those weeks or someone else can host.16:03
johnsomWhat are your thoughts?16:03
gthiemongeI'll be on PTO too until January (except next week), so maybe we can cancel16:03
johnsomOk, sounds good. I will send out an email to the discuss list later today.16:05
johnsom#topic Brief progress reports / bugs needing review16:05
gthiemongeack16:05
johnsomI have been mostly consumed with downstream work and have not made much progress here this week.16:05
gthiemongeI found out that the 2025.1 jobs don't use Noble amphora image (but the control plan runs on Noble), so I backported:16:06
gthiemongehttps://review.opendev.org/c/openstack/octavia/+/97034116:06
johnsomAck, thanks.16:07
gthiemonge(I was looking at backporting a fix for haproxy 2.8, and the CI job didn't seem impacted by the bug, because it's still using an older version)16:07
gthiemongehttps://review.opendev.org/c/openstack/octavia-tempest-plugin/+/95675216:08
gthiemonge^ is not supposed to pass without a backport16:09
johnsomDoes that need a depends-on?16:09
gthiemongei'm w-1 right now, it may need a depends on a backport that doesn't exist yet :D16:10
johnsomOk, if there are no other updates, we can move on to open discussion16:12
johnsom#topic Open Discussion 16:13
gthiemongeearlier today, someone mentioned a proposal to improve API performance16:13
gthiemongehttps://review.opendev.org/c/openstack/octavia/+/97040416:14
gthiemongeresults look good, but I'm not sure we want db queries directly in the API code (or maybe it's fine)16:14
johnsomI am guessing that his related to the proposal to flatten the data model?16:14
gthiemongeI don't think it is16:15
johnsomOh, is it related to the performance drop in sqlalchemy?16:15
johnsomversions > 1.4 had a pretty big drop16:16
gthiemongeit skips some internal data conversions16:16
theovgHi, I'm the owner of the proposal; DB queries I was thinking of offloading. I'm looking for opinions on the general idea before putting more work into it16:16
theovgIt is mostly about bypassing to_data_model and from_data_model16:16
johnsomAh, yeah, so probably related to the "flatten data model" proposal. (I have not yet looked at the patch)16:17
johnsomCurrently the data model pulls in everything, recursively, and then picks what it needs from that data. It's horribly inefficient but simple. We have discussed that doing this does not have a lot of value and we should make all of the objects flat and not recurse as it's not really needed or could be done in the few cases it is needed.16:19
johnsomA quick look at the patch, I would encourage us to keep all of the sql specific code in the octavia/db/repositories.py file.16:21
johnsomThis has helped us in the past when sqlalchemy makes breaking changes for example.16:21
theovgThat was my observation; the patch I proposed lays out a parallel processing path "from_db_obj" which bypasses the data model system completely and showing great results on my benchmarks all without breaking any tests16:22
gthiemongeyeah in the proposal, skipping the conversions to the data model removes the issue with the recursion of the objects16:22
theovgDefinitely agree on the query code16:22
johnsomI will see if I can give you initial comments this week to not block your progress. I think you are on the same path we agreed needed to happen a while ago.16:23
theovgThank you!16:23
johnsomOk, we have a path forward here. Any other topics today?16:25
gthiemongenothing from me16:25
rcruise-redhatnone from me16:26
johnsomAll right, thank you everyone!16:26
johnsom#endmeeting16:26
opendevmeetMeeting ended Wed Dec 10 16:26:26 2025 UTC.  Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4)16:26
opendevmeetMinutes:        https://meetings.opendev.org/meetings/octavia/2025/octavia.2025-12-10-16.01.html16:26
opendevmeetMinutes (text): https://meetings.opendev.org/meetings/octavia/2025/octavia.2025-12-10-16.01.txt16:26
opendevmeetLog:            https://meetings.opendev.org/meetings/octavia/2025/octavia.2025-12-10-16.01.log.html16:26
theovgThanks again, have a good one16:26
rcruise-redhatThanks all, enjoy the rest of your week!16:27
opendevreviewRichard Cruise proposed openstack/octavia master: Fix spurious logging message in amphora-agent API  https://review.opendev.org/c/openstack/octavia/+/97042116:28
opendevreviewRichard Cruise proposed openstack/octavia master: Fix spurious logging message in amphora-agent API  https://review.opendev.org/c/openstack/octavia/+/97042116:28

Generated by irclog2html.py 4.0.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!