Earlier  
Later
New Search
Posted Nick Remark
#openstack-nova - 2021-12-09
10:21:19 gibi regarding nova-manage that feels optional to me, and probably pslestang can state if OVH needs it or not
10:21:30 gibi so this is a requirement question
10:21:34 bauzas yeah
10:21:36 pslestang bauzas: by the way we already need to change the nova-manage purge behaviour which actually rely on update_at column for instance_action_* tables instead of deleted_at
10:21:44 bauzas correct
10:22:08 bauzas we also need to look at which methods look at instance actions
10:22:23 bauzas we know the API for sure
10:22:40 bauzas but I wonder whether we also look at the actions within nova directly
10:22:52 sean-k-mooney bauzas: we dont need to modify the db but we do need to modify hte db queries
10:22:59 sean-k-mooney the schema will remain the same
10:23:15 bauzas sean-k-mooney: agreed this isn't a DB schema modifcatioin
10:23:19 gibi sean-k-mooney: ooh the same already has deleted column, I missed that
10:23:20 bauzas but this is about the values
10:23:40 sean-k-mooney gibi: yep it already inherits form teh softdelete mixin
10:23:40 pslestang gibi: at OVH we do not use nova-manage but it could be useful for someone
10:23:41 bauzas for the moment, soft-deleted instances have not deleted actions
10:23:51 sean-k-mooney gibi: we just currently dont soft delete it
10:24:10 bauzas if we start to soft-delete actions when deleting instances, then I wonder what happens for existing instance related actions
10:24:26 sean-k-mooney the remain not deleted
10:24:30 sean-k-mooney but that wont mater
10:24:40 bauzas sean-k-mooney: this is one direction
10:24:45 sean-k-mooney since we will just start ignoring that field
10:24:47 bauzas or one solution
10:25:02 sean-k-mooney well setting a colume to the value it currently has in an update is valid
10:25:06 bauzas anyway, needs to get my daughter, moving
10:25:16 sean-k-mooney so the resotre can ignore it too and just always set it to 0
10:25:34 sean-k-mooney even if its already 0 becuase we did not migrate the existing ones to eb soft deleted
10:26:24 sean-k-mooney pslestang: wehn you archive the deleted rows it will delete the instance actions
10:26:55 sean-k-mooney so by the time you get to purge they shoudl already be gone form the main table
10:27:41 sean-k-mooney archiveing the delete rows will remove the instance form the main table which would break the forien key constraitnt on the isntnace action table
10:28:08 sean-k-mooney so the rows have to be removed to archive the instance to the shadow tables
10:28:10 pslestang sean-k-mooney: from what I saw when you archive the deleted rows it does not delete the instance actions but copy them in shadow tables
10:28:37 sean-k-mooney it shoudl delete them form the main table and copy them to the shadow table
10:28:44 sean-k-mooney basically a move
10:28:49 pslestang yes that's it
10:29:00 sean-k-mooney yep that is the expect behavior
10:29:19 sean-k-mooney and pruge should remove them for the shadow tabels
10:29:43 pslestang and when we purge de archived rows, it deletes the instances based on deleted_at date, and deleted the insatnce_action bases on updated_at date
10:30:13 sean-k-mooney if you are using --before yes
10:30:27 pslestang yep
10:30:43 sean-k-mooney we could likely adapt that to use delete_at if its popluatedand fall abck to updated at if not
10:31:02 sean-k-mooney or just leave it as is
10:33:25 pslestang I prefer to adapt the code to make it consistent with the soft-delete of instance_actions
10:33:42 sean-k-mooney bauzas: im prety sure we dont look at the actions in nova they are write only
10:34:16 sean-k-mooney pslestang: ok would you prefer to write this all down in a short spec which we can try an appove in the review day on the 14th
10:34:29 sean-k-mooney or just proceed with this as a specless blueprint
10:34:57 pslestang I can write a short spec
10:34:58 sean-k-mooney i dont thinks we really need a spec but i think having one to document this would be good so im happy to review it if you write it
10:35:06 pslestang sure
10:35:20 sean-k-mooney cool feel free to add me and likely gibi/bauzas to it
10:35:22 pslestang is it better to change the one I wrote or to create a new one?
10:35:36 sean-k-mooney oh you already have one?
10:35:57 pslestang I was talking about the BP
10:36:26 sean-k-mooney oh reuse the blueprint you have now but file a spec with the same name
10:36:51 pslestang ok understand, I will dot it asap
10:37:03 sean-k-mooney cool
10:46:31 bauzas pslestang: thanks pslestang for writing up a quick spec
10:46:39 bauzas you can see the template and the already existing specs too
10:47:05 bauzas I'm not really asking about a paperwork, just want to be sure we don't miss any important issue
10:48:56 sean-k-mooney yep for me the spec is more just documentaiton/todo list in this case rather then a detailed design requirement because its complex
10:49:29 sean-k-mooney this is a relitively simple change we just dont want to miss any interop or upgrade impact
10:50:08 sean-k-mooney i think we are all supportive of doing it so you dont really need to convice use just detail what needs to be done
10:53:51 gibi bauzas: could you quickly mark this wontfix https://bugs.launchpad.net/nova/+bug/1953734 as it is talking about a deprecated API ? (I don't want to do it as I was asked downstream to open it :D)
10:54:45 bauzas gibi: hehe sure :p
10:54:54 bauzas do you want my bank account ?
10:55:04 bauzas :D
10:55:05 gibi I will pay in beer
10:55:05 gibi :D
10:55:14 gibi when we finally meet again
10:55:43 bauzas well, if I was paying for a vine in 2019 for the next meeting, then it would be a very nice one :)
10:56:05 bauzas after 3 years
10:56:42 sean-k-mooney gibi: what is the invalid input in this case by the way
10:57:00 bauzas hmmm, https://docs.openstack.org/api-ref/compute/?expanded=list-security-groups-by-server-detail#servers-security-groups-servers-os-security-groups
10:57:26 bauzas unfortunately, we don't document the fact that the POST action is now deprecated
10:57:37 gibi sean-k-mooney: security_group is expected to be a dict not a string
10:57:49 sean-k-mooney ah ok
10:57:55 gibi These APIs are proxy calls to the Network service. Nova has deprecated all the proxy APIs and users should use the native APIs instead. These will fail with a 404 starting from microversion 2.36. See: Relevant Network APIs.
10:58:03 bauzas gibi: yeah I know
10:58:15 gibi I think this is for the whole /os-security-groups resource
10:58:15 sean-k-mooney yep the post action i tough twas only vailid for nova networks
10:58:20 bauzas gibi: I'm just saying we don't document it in our API docs :p
10:58:56 bauzas gibi: well, then the GET /os-security-groups action should be told to by deprecated in our API docs :)
10:58:59 gibi I think the documentation is there in the header
10:59:13 bauzas oh, did I miss something in the docs ?
10:59:15 sean-k-mooney https://docs.openstack.org/api-ref/compute/?expanded=list-security-groups-by-server-detail#list-security-groups
10:59:30 sean-k-mooney bauzas: its in the os-security-groups section
10:59:38 sean-k-mooney These APIs are proxy calls to the Network service. Nova has deprecated all the proxy APIs and users should use the native APIs instead. These will fail with a 404 starting from microversion 2.36. See: Relevant Network APIs.
10:59:47 bauzas I'm blind
10:59:58 sean-k-mooney you were looking at the instance action
11:00:01 sean-k-mooney that does not have the hearder
11:00:28 sean-k-mooney but the os-security-groups endpoint section does
11:00:35 bauzas what the f***
11:00:40 sean-k-mooney bauzas: https://docs.openstack.org/api-ref/compute/?expanded=list-security-groups-by-server-detail#delete-deallocate-floating-ip-address
11:00:45 sean-k-mooney the big red box ^
11:00:49 bauzas yeah I get it now
11:00:56 sean-k-mooney :)
11:01:12 bauzas but... can't get why I wasn't able to see it in my own link
11:01:24 sean-k-mooney bauzas: because you were not looking in the right section
11:01:42 sean-k-mooney you were looking at /servers/uuid/os-secuirty-groups
11:01:49 sean-k-mooney that was not deprecated

Earlier   Later