Wednesday, 2025-02-26

sean-k-mooney[m]bauzas:  can you review this in your morning and the repoducer patch above it https://review.opendev.org/c/openstack/nova/+/932931/2 i would like to make sure thats included in epoxy so we can start backporting it to stable ideally beforee bobcat goes eol.00:16
opendevreviewmelanie witt proposed openstack/nova master: nova-manage: Add --max-rows option to 'db purge' command  https://review.opendev.org/c/openstack/nova/+/92733900:17
sean-k-mooney[m]so i think that is related to a donwstream bug report right ^ should the user really have to pass —max rows or should nova just do it in bataches automatically00:19
melwittsean-k-mooney: it is related to a downstream bug report but the bug reporter noted that what we need is the same ability we have for archive_deleted_rows (which allows someone to control what size they want the batches to be). --max-rows defaults to 100000:21
sean-k-mooney[m]i commented on the review as well but ya i noticed that defaulting when i looked more closely00:24
sean-k-mooney[m]i guess that kind of indirectly does what i asked for so im ok with that i think00:25
sean-k-mooney[m]basiclly it would be good for nova to hide this impelation detail form the user. its unlikely that archiveing 1000 instance would exceeed the transaction limit size00:26
sean-k-mooney[m]posible but unlikely00:26
sean-k-mooney[m]* purgeing not archiveing00:26
sean-k-mooney[m]to me the fact a transaction size limit is a internal detail that a user of nova manage should ideallly not need to care about00:27
melwittfwiw the database transaction limit and packet size etc is all configurable on the database side so it's not something you can assume00:27
sean-k-mooney[m]right but it is something we can look up00:27
melwittin my experience, operators do like to tune this to how they want, so I haven't thought about hiding bc of that00:27
sean-k-mooney[m]im still of the opion that nova should not have shadow tables and archiving should be done externally to noav using other tooling :)00:28
melwittnot really because we can't go looking into their innodb config or whatever00:28
sean-k-mooney[m]you can make an sql query to look it up i touhgt00:29
sean-k-mooney[m]the same way you can do that to get the connection limit00:29
melwittoh. I guess you could do that00:29
sean-k-mooney[m]https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html#sysvar_group_replication_transaction_size_limit00:30
sean-k-mooney[m]melwitt that could be a future thing00:31
melwittI feel like that would be a separate thing where if we did it we would change archive to work the same way, at the same time. I think they should be consistent. 00:31
sean-k-mooney[m]the fact you providing a default kind of paper over the problem00:31
sean-k-mooney[m]ya im not going to ask you to put it in the current patch fro that reason00:32
melwittand this patch is addressing the fact that today, if your shadow tables are too large, you are just screwed and you can't purge them with nova tooling and you have to truncate them manually00:32
sean-k-mooney[m]i just wanted to raise that design point00:32
melwittfair enough :)00:32
sean-k-mooney[m]yep so personally i think we should be deprecating the nova tooling and saying you should use some fo the external toolign for this00:33
sean-k-mooney[m]but i know that wont happen any time soon00:33
melwittI think people might find that harsh. what kind of external tooling are you thinking of?00:34
sean-k-mooney[m]there are two diffent set of tooling00:36
sean-k-mooney[m]there is a tool that manages archiveing and purging records for all service in a common way inculdiign for serice that dont have shadow tables00:37
sean-k-mooney[m]ill see if i can find the link but it handels nova neuron ectar all the same way with the ablity to archive them to a diffent database service instance or locally to files00:38
melwittoh, right, that does sound familiar00:38
sean-k-mooney[m]there si allso osops tools which has a nova specifc srcipt https://opendev.org/openstack/osops/src/branch/master/tools/generic/nova/openstack_db_archive.sh00:38
melwittyeah, I see what you mean now. I agree I think that would be ideal for there to be a unified thing that will work for all of the projects00:39
melwittwhen you said "external" I thought you meant external to openstack and was confused00:39
sean-k-mooney[m]https://github.com/ovh/osarchiver00:41
sean-k-mooney[m]well i was thinking of ^00:41
sean-k-mooney[m]thats the thing that basicaly does this for all proejcts in a consistent way00:41
melwittoh, interesting00:42
sean-k-mooney[m]it basically does not use shadowtable at all00:42
sean-k-mooney[m]it can arcive without deletign or it can archive and delete the rows in teh service dbs00:43
sean-k-mooney[m]to get a similar effect00:43
sean-k-mooney[m]given you can restore thing from the shadown tabels to the main tables i would actully say its more usefual because it mvoes the data to an entirly differnt db in teh same format00:44
sean-k-mooney[m]which is you ever wanted to restore those rows back for any reason would be simpler00:44
sean-k-mooney[m]its like doing incremental backups of only the rows marked as deleted00:45
sean-k-mooney[m]the reason osarchiver is not hosted in opendev is because we didnt agree which repo to put it in00:45
sean-k-mooney[m]which is a shame00:45
melwittyeah, I was just thinking that if people kept incremental backups there would be no use for shadow tables00:45
melwitthah, nice00:46
sean-k-mooney[m]there was a maining list tread about it like 4 years ago  i belvie and it just stalled out00:46
melwittreposhed00:47
sean-k-mooney[m]melwitt: anyway i think that a better technial solution i just dont think we will ever get to that at least not unless something changes 00:47
sean-k-mooney[m]i wanted to use that in our new installer but…. it was too much effort to advocate for that and get by in00:48
melwittyeah. especially difficult if it's not in opendev00:49
sean-k-mooney[m]it was more that pm didnt want use to focus on day two operations like automating backups of db in the operators00:50
sean-k-mooney[m]so providing incremental backups and “archiving” of this in a centralised way was not a priority00:51
sean-k-mooney[m]so we just use nova manage in a k8s cron job instead00:51
sean-k-mooney[m]i.e. we keep is simpel using the upstream tooling00:51
sean-k-mooney[m]im not saying it could never be in scope but it was not in the mvp list for v100:52
melwittyeah00:52
sean-k-mooney[m]ill try and add that to my review list for tomorrow00:54
sean-k-mooney[m]its not nessisally impacted by ff but while i have context i might as well00:54
melwitthaha thanks00:55
sean-k-mooney[m]if you feel like reviewing something small this and the repoducer under neath is waiting for a second +2 https://review.opendev.org/c/openstack/nova/+/932931/2 although i pinged sylain to hopefully take a look above00:55
sean-k-mooney[m]i think its time i went to sleep chat to you tomorrow o/00:57
melwittsylvain would be ideal for that one but if he doesn't get to it I can do it00:57
melwittseeya tomorrow o/00:57
opendevreviewMerged openstack/nova master: Fix device type when booting from ISO image  https://review.opendev.org/c/openstack/nova/+/90961101:24
opendevreviewmelanie witt proposed openstack/nova master: DNM test headers  https://review.opendev.org/c/openstack/nova/+/94275201:39
opendevreviewAmit Uniyal proposed openstack/nova master: WIP: remove swap.disk from disk.info  https://review.opendev.org/c/openstack/nova/+/94275906:38
opendevreviewmelanie witt proposed openstack/nova master: DNM test headers  https://review.opendev.org/c/openstack/nova/+/94275206:45
opendevreviewMerged openstack/nova master: Add repoducer test for bug 2074219  https://review.opendev.org/c/openstack/nova/+/93293008:50
bauzasgibi: sean-k-mooney[m] : I'd appreciate if you could get a swing for https://review.opendev.org/c/openstack/nova/+/845757/09:11
bauzasI'll also try to look at the functests failing09:12
opendevreviewAmit Uniyal proposed openstack/nova stable/2024.2: WIP: remove swap.disk from disk.info  https://review.opendev.org/c/openstack/nova/+/94276409:20
opendevreviewAmit Uniyal proposed openstack/nova stable/2024.1: WIP: remove swap.disk from disk.info  https://review.opendev.org/c/openstack/nova/+/94276509:31
opendevreviewCallum Dickinson proposed openstack/nova master: Add image meta to libvirt XML metadata  https://review.opendev.org/c/openstack/nova/+/94276609:34
opendevreviewAmit Uniyal proposed openstack/nova stable/2023.2: WIP: remove swap.disk from disk.info  https://review.opendev.org/c/openstack/nova/+/94276909:54
gibibauzas: is it something we need to land before FF or something we can land after FF?10:17
bauzasgibi: well, this is not really a bugfix10:17
bauzasbut it fixes evecuates for VGPUs10:18
opendevreviewMerged openstack/nova master: Fix detaching devices by alias with mdevs  https://review.opendev.org/c/openstack/nova/+/93293110:38
opendevreviewCallum Dickinson proposed openstack/nova master: Add image meta to libvirt XML metadata  https://review.opendev.org/c/openstack/nova/+/94276611:18
sean-k-mooneybauzas: ack ill add it to my list, i have to do a pass on the nova-operator stuff and then melwitt's nova-manage command today but i think i can get to those as well11:25
sean-k-mooneybauzas: i think it might fix evacuate for anything with nested resouce providers if i rememebr correctly11:25
sean-k-mooneymaybe not11:26
sean-k-mooneythat not the patch i was thinkign of11:27
opendevreviewStefan Hoffmann proposed openstack/os-vif master: [ovs] Add method to get external_ids from Interface  https://review.opendev.org/c/openstack/os-vif/+/94271511:43
opendevreviewStefan Hoffmann proposed openstack/nova master: optional wait for ovn plug and create tap  https://review.opendev.org/c/openstack/nova/+/94278612:04
fricklerUggla: please check https://review.opendev.org/c/openstack/governance/+/942507/comment/029df38c_6df9f638/ . it would likely also be helpful if you could join the #openstack-tc channel while you are PTL16:30
Ugglafrickler, I'm currently in a meeting, but I'will have a look after.16:32
fricklerUggla: thx, not urgent, just so you don't miss it16:34
sean-k-mooneydviroel: left some minor feedback on https://review.opendev.org/c/openstack/nova/+/938604 but i think this is mostly good to go16:53
dviroelsean-k-mooney:  oh, thanks, indeed, going to update it16:55
sean-k-mooneyim looking at the tempest patch now so far looks good to me16:56
sean-k-mooneydviroel: minor comment on https://review.opendev.org/c/openstack/tempest/+/939375 as well17:05
sean-k-mooneyover all it looks fine to me but i htink you need to update teh import17:05
sean-k-mooneygmann: ^ would you be able to comment on the questions i have inline and confirm the schema inheritance is correct or not?17:06
opendevreviewDouglas Viroel proposed openstack/nova master: Add support for showing scheduler_hints in server details  https://review.opendev.org/c/openstack/nova/+/93860417:38
dviroelsean-k-mooney: ^ updated. Lets see if functional is going to pass. I added a scheduler hint to the server creation req 17:40
dviroelin the api_sample_tests17:41
sean-k-mooneyassuming it green i think ill be +217:45
sean-k-mooneyill check back in a bit once we get some results17:45
sean-k-mooneyif it does break thign we can revert that chagne and try and update it in a follow uponce the feature is merged17:46
sean-k-mooneydviroel: it looks a little funky https://5671b50e1757693146fd-d2676880cd4ce07846d9d5d9e5ab28d1.ssl.cf1.rackcdn.com/938604/11/check/build-openstack-api-ref/6d89054/docs/#id3017:48
sean-k-mooneyi have not looked at the code but did you really use a regex?17:48
sean-k-mooney"scheduler_hints": {17:48
sean-k-mooney            "same_host": [17:48
sean-k-mooney                "[0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12}"17:48
sean-k-mooney            ]17:48
sean-k-mooney        },17:48
dviroeli was reusing an example from a sever creation17:51
dviroelv2.63 i think17:51
sean-k-mooneyok well it net to be a uuid17:52
sean-k-mooneyas in the example respocne shoudl not be the validation critia17:52
sean-k-mooneyit shoudl be somethign like "dc877f7e-7d69-4c3c-956b-1978cd8ed754"17:52
dviroelyeah, let me fix that17:52
sean-k-mooneyits apprently an arry of uuids17:53
sean-k-mooneyat least based on your tempets change17:53
sean-k-mooneyoh17:55
sean-k-mooneyit can be a single uuid as a stirng or an away or them 17:55
sean-k-mooneythe 2.90 create exmaple has 17:55
sean-k-mooney "OS-SCH-HNT:scheduler_hints": {17:56
sean-k-mooney        "same_host": "48e6a9f6-30af-47e0-bc04-acaed113bb4e"17:56
sean-k-mooney    }17:56
sean-k-mooneyas an example in the request17:56
sean-k-mooneyso you can just do the same in the responce example17:56
sean-k-mooneywell without the OS-SCH-HNT prefix17:57
sean-k-mooneyeverything else looked good excpti the example value17:57
dviroelyeah, they are adding this in the request sample, but not in the template, but the test does not validate that18:01
melwitthuh, yeah, this should not have been a regex 😝 https://github.com/openstack/nova/blob/master/doc/api_samples/servers/v2.63/server-create-req.json someone missed that in review18:03
sean-k-mooneyya.. i noticed it was broken there18:04
sean-k-mooneybut given that out of scop of dviroel's patch i decied not to mention that18:04
sean-k-mooneyim sure we have other cases where that has happen18:04
melwittwell he mentioned it above, that's how I found it18:05
sean-k-mooneymelwitt: since your about would you have tim eto take a look at dviroel patch since you have recently look at all this for the other api changes18:06
dviroeli used the 'uuid' - and it the end, it was replace in the post server: https://opendev.org/openstack/nova/src/commit/8f57fa7359d57e186fc6b75424b4900dc63c564f/nova/tests/functional/api_sample_tests/test_servers.py#L7018:07
melwittyeah, I can look at it18:07
sean-k-mooneycool https://review.opendev.org/c/openstack/nova/+/938604/11 is the nova change and https://review.opendev.org/c/openstack/tempest/+/939375 is the tempest update, finall https://review.opendev.org/c/openstack/nova/+/942728 pulls those together18:07
sean-k-mooneydviroel: i will try and look at the sdk and clinet changes also but nova and tempest are the priorities18:08
dviroelack, thanks sean-k-mooney - yeah, not so sure if my client change is correct, ptal when you have some time18:09
opendevreviewDouglas Viroel proposed openstack/nova master: Add support for showing scheduler_hints in server details  https://review.opendev.org/c/openstack/nova/+/93860418:21
gmannsean-k-mooney: sure, checking18:30
opendevreviewribaudr proposed openstack/nova master: Augment the LiveMigrateData object  https://review.opendev.org/c/openstack/nova/+/94214318:50
opendevreviewribaudr proposed openstack/nova master: Add live_migratable flag to PCI device specification  https://review.opendev.org/c/openstack/nova/+/94214418:50
opendevreviewribaudr proposed openstack/nova master: Update manager to allow vfio pci device live migration  https://review.opendev.org/c/openstack/nova/+/94214518:50
opendevreviewribaudr proposed openstack/nova master: Update conductor and filters allowing migration with SR-IOV devices  https://review.opendev.org/c/openstack/nova/+/94214618:50
opendevreviewribaudr proposed openstack/nova master: Update driver to map the targeted address for SR-IOV PCI devices  https://review.opendev.org/c/openstack/nova/+/94214718:50
opendevreviewribaudr proposed openstack/nova master: Update conductor and filters allowing migration with SR-IOV devices  https://review.opendev.org/c/openstack/nova/+/94214619:04
opendevreviewribaudr proposed openstack/nova master: Update driver to map the targeted address for SR-IOV PCI devices  https://review.opendev.org/c/openstack/nova/+/94214719:04
mikalMorning19:14
opendevreviewCallum Dickinson proposed openstack/nova master: Add image meta to libvirt XML metadata  https://review.opendev.org/c/openstack/nova/+/94276619:19
opendevreviewRyota, Ochiai proposed openstack/nova master: doc: Delete deprecated settings of the installation guide  https://review.opendev.org/c/openstack/nova/+/89607419:21
gmannsean-k-mooney: dviroel: reviewed the nova and tempest change, we are missing the update server APIs changes which is also impacted when we update the views/servers.py20:12
gmannin nova side it is just documentation and test and in tempest tests we need to add schems and test for update server20:13
dviroelgmann: oh thanks, I missed the update server. going to propose an update, thanks20:16
opendevreviewCallum Dickinson proposed openstack/nova master: Add image meta to libvirt XML metadata  https://review.opendev.org/c/openstack/nova/+/94276620:20
opendevreviewCallum Dickinson proposed openstack/nova master: Add image meta to libvirt XML metadata  https://review.opendev.org/c/openstack/nova/+/94276620:29
opendevreviewDouglas Viroel proposed openstack/nova master: Add support for showing scheduler_hints in server details  https://review.opendev.org/c/openstack/nova/+/93860420:53
opendevreviewMax proposed openstack/nova master: feat: nova-manage db instance events cleanup  https://review.opendev.org/c/openstack/nova/+/91692721:27
*** dviroel is now known as dviroel_bbl21:31
gmann3422:03
gmannplease ignore22:05
gmanndviroel_bbl: ack22:09
sean-k-mooney[m]gmann:  so  dviroel dint modify server update in this api microverions22:11
sean-k-mooney[m]if we missed that in this change its also missing from 2.9822:12
sean-k-mooney[m]for the image properies in server show22:12
*** dviroel_bbl is now known as dviroel23:17
dviroelsean-k-mooney: and pinned_availability_zone in 2.96 too23:30
sean-k-mooney[m]yes more then likely but we should fix that seperatly23:31
dviroelmy tempest change is not going to pass without theses fixes in tempest side, since now I am testing update server too, and thy are missing23:33
gmannsean-k-mooney[m]: it does. this line change the update server API also https://review.opendev.org/c/openstack/nova/+/938604/12/nova/api/openstack/compute/views/servers.py#33523:38
sean-k-mooney[m]in directly via reusing show23:39
gmannbasically we have to keep these 4 APIs (GET, GET details, Rebuild, update server) response consistent (we fixed it in 2.74). I commented in the spec also to mention all these 4 APIs response change together23:40
gmannI did not check earlier microversion 2.98 or 2.96 but we should keep all these 4 APIs response consistently and they get changed together when we change the views/servers.py23:41

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