Earlier  
Posted Nick Remark
#openstack-nova - 2023-09-12
08:04:28 bauzas the objects relationships diffezr
08:04:42 stephenfin the relationships haven't changed. All that has changed is how we describe them
08:04:45 bauzas but the docs don't tell anything about the executed JOINs
08:05:18 bauzas stephenfin: that's my natural first thoughts, but then I wonder if the description change may arise some query modification
08:05:24 stephenfin this model is preferred because it's more explicit and iiuc allows for type hinting without a separate plugin
08:05:31 bauzas since relationships are now both-ways
08:06:07 stephenfin they were always both ways
08:06:23 stephenfin for example: look at the first thing we modified in https://review.opendev.org/c/openstack/nova/+/860829/1/nova/db/api/models.py
08:06:37 stephenfin sorry, https://review.opendev.org/c/openstack/nova/+/860829/1/nova/db/api/models.py#b150 (with anchor)
08:07:05 stephenfin that's saying the local side is called 'host_mapping' and the remote side is called 'cell_mapping'
08:07:16 stephenfin as defined by the backref
08:07:39 stephenfin now, instead of declaring both of these on one side, we declare it on both sides
08:08:20 stephenfin so if anything it's a bit more duplication but for the advantage of explicitness and readability/parseability
08:16:39 stephenfin bauzas: here, compare the output of these. First, with backref: https://paste.opendev.org/show/bD4K8pJoSl212q37kvEZ/
08:16:48 stephenfin then, with back_populates: https://paste.opendev.org/show/bonhcuiyNJtYmM0wITE0/
08:17:00 bauzas excellent, that's what I was testing
08:17:09 stephenfin they're modified versions of my examples from https://that.guru/blog/sqlalchemy-relationships-without-foreign-keys/
08:17:23 stephenfin spoiler: it's the same SQL
08:18:32 bauzas so the main thing to doublecheck is that the implicit relationship that was given by the other way is now explicit in the object
08:18:41 bauzas right?
08:18:56 bauzas because if not, we regress by loosing a JOIN
08:19:41 stephenfin yeah, that makes sense
08:50:14 opendevreview Merged openstack/os-vif stable/2023.2: Update .gitreview for stable/2023.2 https://review.opendev.org/c/openstack/os-vif/+/894060
09:44:53 bauzas stephenfin: I may have spotted a problem with bdms.deleted https://review.opendev.org/c/openstack/nova/+/860829
09:45:15 bauzas stephenfin: I need to go off the keyboard for gym reasons but I'll be back in the afternoon
09:50:19 kashyap Hehe, "gym reasons"
10:56:17 opendevreview Stephen Finucane proposed openstack/nova master: db: Remove unused relationships https://review.opendev.org/c/openstack/nova/+/894635
12:25:45 bauzas kashyap: I don't know how to call what I do :) let's say physical prep :)
13:01:29 kashyap Heh, I was just joking, dont' worry :)
13:34:58 stephenfin bauzas: you saw my reply, I assume?
13:35:18 stephenfin i can squash if you'd like but it's much of a muchness given it's "dead code"
13:35:20 bauzas stephenfin: I was literally seconds before pinging you
13:36:02 bauzas stephenfin: my only concern is that I need to check why we have this bdm relationship and I don't trust our test coverage for saying whether it's unused or not
13:36:32 bauzas at least I certainly understand why the backref was limiting to existing BDMs and not the deleted ones
13:37:50 bauzas stephenfin: wouldn't be easier to change the relationship in your first change to continue querying the non-deleted BDMs, and *then* remove the relationship later ?
13:38:05 stephenfin it would but then I need to rebase and lose the +2s :)
13:38:14 bauzas so, we could somehow merge the first one in Bobcat while the latter would be in Caracal
13:38:41 bauzas stephenfin: if this is just about a +2, we can ping sean-k-mooney :)
13:44:22 stephenfin Okay, once I know it won't take many months before it's looked at again :) I'll respin shortly after my current meeting
13:48:55 bauzas sure, I'll look
13:49:10 bauzas again, matter of priorities, y'know<
14:14:17 opendevreview Merged openstack/nova-specs master: Create specs directory for 2024.1 Caracal https://review.opendev.org/c/openstack/nova-specs/+/889177
14:30:02 opendevreview Stephen Finucane proposed openstack/nova master: db: Replace use of backref https://review.opendev.org/c/openstack/nova/+/860829
14:30:02 opendevreview Stephen Finucane proposed openstack/nova master: objects: Stop fetching from security_groups table https://review.opendev.org/c/openstack/nova/+/860850
14:30:03 opendevreview Stephen Finucane proposed openstack/nova master: db: Remove unused relationships https://review.opendev.org/c/openstack/nova/+/894635
14:30:10 stephenfin bauzas: sean-k-mooney: ^
15:50:09 bauzas reminder : nova meeting in 10 mins
15:50:28 bauzas stephenfin: saw your update, thanks, but I need to continue reviewing it
16:03:28 bauzas shit
16:03:33 bauzas #startmeeting nova
16:03:33 opendevmeet Meeting started Tue Sep 12 16:03:33 2023 UTC and is due to finish in 60 minutes. The chair is bauzas. Information about MeetBot at http://wiki.debian.org/MeetBot.
16:03:33 opendevmeet Useful Commands: #action #agreed #help #info #idea #link #topic #startvote.
16:03:33 opendevmeet The meeting name has been set to 'nova'
16:03:39 bauzas sorry folks about the late start :)
16:03:44 auniyal o/
16:03:46 gibi o/
16:03:47 elodilles o/
16:03:49 bauzas #link https://wiki.openstack.org/wiki/Meetings/Nova#Agenda_for_next_meeting
16:03:50 Uggla o/
16:03:59 bauzas #topic Bugs (stuck/critical)
16:04:04 bauzas #info One Critical bug
16:04:09 bauzas #link https://bugs.launchpad.net/nova/+bug/1983863
16:04:18 bauzas but iiuc, the fix is now merged
16:04:32 bauzas so, will be closed soon-ish
16:04:54 bauzas #link https://bugs.launchpad.net/nova/+bugs?search=Search&field.status=New 49 new untriaged bugs (+0 since the last meeting)
16:05:00 bauzas #info Add yourself in the team bug roster if you want to help https://etherpad.opendev.org/p/nova-bug-triage-roster
16:05:05 bauzas #info bug baton is bauzas
16:05:13 bauzas taking the baton for this week again
16:05:19 bauzas any bug to discuss ?
16:05:28 auniyal bauzas, ci bug https://bugs.launchpad.net/nova/+bug/2035095
16:06:04 bauzas I've seen an excerpt of this
16:06:11 bauzas basically the port doesn't become active
16:06:18 bauzas let's discuss this gate failure in the next topic
16:06:26 bauzas #topic Gate status
16:06:27 auniyal ack,
16:06:31 gibi is it a duplicate of https://bugs.launchpad.net/neutron/+bug/1940425 ?
16:06:32 bauzas #link https://bugs.launchpad.net/nova/+bugs?field.tag=gate-failure Nova gate bugs
16:06:43 bauzas so
16:07:03 bauzas auniyal: yes indeed, could you please mark it dup ?
16:07:11 auniyal yes
16:07:18 gmann o/
16:07:50 bauzas cool
16:07:57 bauzas #link https://zuul.openstack.org/builds?project=openstack%2Fnova&project=openstack%2Fplacement&pipeline=periodic-weekly Nova&Placement periodic jobs status
16:08:01 bauzas #info nova-emulation is still b0rked
16:08:05 bauzas #info https://zuul.openstack.org/build/d2ddbb3f307549aaa0575b9ee0f1daab
16:08:40 bauzas lots of keystone failures this time
16:08:47 bauzas so I guess this is unfortunate
16:11:16 bauzas moving on then ?
16:11:24 bauzas shall we discuss any other gate failure ?
16:12:07 bauzas looks not
16:12:14 bauzas #info Please look at the gate failures and file a bug report with the gate-failure tag.
16:12:18 bauzas #topic Release Planning
16:12:22 bauzas #link https://releases.openstack.org/bobcat/schedule.html
16:12:25 bauzas #info Nova deadlines are set in the above schedule
16:12:28 bauzas #info 2 days before RC1
16:12:32 bauzas #link https://etherpad.opendev.org/p/nova-bobcat-rc-potential Etherpad for tracking RCs
16:12:44 bauzas basically all the needed changes are approved now,
16:12:55 bauzas the cycle highlights got a correct round of reviews
16:13:08 bauzas so I'll prepare the reno prelude patch based on the highlights tomorrow morning
16:14:53 bauzas ok, let's jump then

Earlier   Later