)]}'
{"id":"openstack%2Fnova~887983","triplet_id":"openstack%2Fnova~stable%2Fyoga~I2209bf1b3320901cf603ec39163cf923b25b0359","project":"openstack/nova","branch":"stable/yoga","attention_set":{},"removed_from_attention_set":{"4690":{"account":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"last_update":"2024-02-06 15:04:17.000000000","reason":"Change was abandoned"}},"hashtags":[],"change_id":"I2209bf1b3320901cf603ec39163cf923b25b0359","subject":"database: Archive parent and child rows \"trees\" one at a time","status":"ABANDONED","created":"2023-07-07 18:16:50.000000000","updated":"2024-02-06 15:04:17.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"bc6b78eb80a68694daeb5e0a8ec296de4e5cbe5d","_number":887983,"virtual_id_number":887983,"owner":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2023-07-07 20:25:59.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-07-07 18:32:20.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2023-07-07 20:25:59.000000000","updated_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"reviewer":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"state":"REVIEWER"},{"updated":"2024-02-06 15:04:17.000000000","updated_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"CC"}],"messages":[{"id":"f3468c64cffe06da7a69923dbad5b75e618b414b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-07-07 18:16:50.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"cdcb4fa64737269a7468f39fff8553e328048af8","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-07-07 18:32:20.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/aab8c3941fa7404db0b638b72ab46f2e\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/0fdb7a8b1ea342b19468510a9ab05477 : SUCCESS in 12m 00s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/4e240b04fb3b4c5a98ecc07262fd67df : SUCCESS in 11m 46s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"0fff4d221ad0f880d23db628cb35030d2127d6a1","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-07-07 20:25:59.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/2afe1f5302eb4127adc17ac8f2ffe168\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/3a1f054c2d994829ac7da0837331c489 : SUCCESS in 1h 38m 08s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/d5138c91c269497280d44ae8f2fa22b2 : FAILURE in 38m 17s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/03d9bf4975fb412c9e94311060e56099 : SUCCESS in 45m 17s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/67a6c4bb6c454750aaa610dd1bab5075 : SUCCESS in 15m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/33aa51612cd0481daed6f725aad7fc8b : SUCCESS in 11m 40s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/66f61bdbc2bf4f129db55cd50a6382ec : SUCCESS in 13m 21s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/bc75520f0dd844689b6c10ebdc5cccbb : SUCCESS in 12m 30s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8433442584214a25ac4c5e5521d1ade0 : SUCCESS in 7m 56s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/f451c027f0f6437a8c5ec904d40348b3 : SUCCESS in 25m 00s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/b8202add0537494aa1e4953ae4715895 : SUCCESS in 50m 48s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/b18676b2c991485ea0484130734bf2f9 : SUCCESS in 1h 22m 17s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/cd1d9072fca8431786c4726f0483f91a : SUCCESS in 52m 50s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/7cec9b34c9af44d5ae6058b6931279c9 : SUCCESS in 39m 11s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/770fb8ca8bca4872b4c4fa8c2da9f917 : SUCCESS in 1h 41m 49s\n- nova-next https://zuul.opendev.org/t/openstack/build/41c4a93a8f17443aadbff5fe461bcf6d : SUCCESS in 2h 01m 30s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/292e7d6c3edf497db8cad9f136f518c5 : SUCCESS in 49m 01s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/b75a1e79876b4f0cbe58eb38a63b14a8 : FAILURE in 5m 03s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/46d0fb75b3b1416e8c87216ec662fb19 : SUCCESS in 23m 59s\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/a51f5916fa3d4502a5cbfae3bad5d173 : SUCCESS in 19m 19s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/6a71f08cbe8643a58a8e5f06ce9eb165 : SUCCESS in 20m 36s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/b9ff4524f95b4128b95d1eeccf306001 : SUCCESS in 1h 12m 49s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/645a91d39ae04ccdbf3c7623926544c2 : SUCCESS in 44m 00s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/65c72642819c4e3ebeed89683500e574 : SUCCESS in 34m 43s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/db96c26a99194cbbb5b4ab0371ea303f : FAILURE in 44m 08s (non-voting)\n- tempest-centos8-stream-fips https://zuul.opendev.org/t/openstack/build/e6a47eae47ff4bcc909357329051b7bb : FAILURE in 43m 15s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"bc6b78eb80a68694daeb5e0a8ec296de4e5cbe5d","tag":"autogenerated:gerrit:abandon","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2024-02-06 15:04:17.000000000","message":"Abandoned\n\nstable/yoga branch of openstack/nova is about to be deleted. To be able to do that, all open patches need to be abandoned. Please cherry pick the patch to unmaintained/yoga if you want to further work on this patch.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"b555279add583e6b0cee1bddb8d5642c68ad84a6","revisions":{"b555279add583e6b0cee1bddb8d5642c68ad84a6":{"kind":"REWORK","_number":1,"created":"2023-07-07 18:16:50.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/83/887983/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/83/887983/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/83/887983/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/83/887983/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/83/887983/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/83/887983/1"}}},"commit":{"parents":[{"commit":"956208d879ef2d49ac5a6f6c2067ff299114d193","subject":"testing: Fix and robustify archive_deleted_rows test","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/956208d879ef2d49ac5a6f6c2067ff299114d193"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-02-22 23:58:33.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-07-07 18:15:27.000000000","tz":0},"subject":"database: Archive parent and child rows \"trees\" one at a time","message":"database: Archive parent and child rows \"trees\" one at a time\n\nPreviously, we archived deleted rows in batches of max_rows parents +\ntheir child rows in a single database transaction. Doing it that way\nlimited how high a value of max_rows could be specified by the caller\nbecause of the size of the database transaction it could generate.\n\nFor example, in a large scale deployment with hundreds of thousands of\ndeleted rows and constant server creation and deletion activity, a\nvalue of max_rows\u003d1000 might exceed the database\u0027s configured maximum\npacket size or timeout due to a database deadlock, forcing the operator\nto use a much lower max_rows value like 100 or 50.\n\nAnd when the operator has e.g. 500,000 deleted instances rows (and\nmillions of deleted rows total) they are trying to archive, being\nforced to use a max_rows value several orders of magnitude lower than\nthe number of rows they need to archive was a poor user experience.\n\nThis changes the logic to archive one parent row and its foreign key\nrelated child rows one at a time in a single database transaction\nwhile limiting the total number of rows per table as soon as it reaches\n\u003e\u003d max_rows. Doing this will allow operators to choose more predictable\nvalues for max_rows and get more progress per invocation of\narchive_deleted_rows.\n\nConflicts:\n    nova/db/main/api.py\n\nNOTE(melwitt): The conflict is because change\nIc43c21038ee682f9733fbde42c6d24f8088815fc (db: Don\u0027t rely on autocommit\nbehavior) is not in Yoga.\n\nCloses-Bug: #2024258\n\nChange-Id: I2209bf1b3320901cf603ec39163cf923b25b0359\n(cherry picked from commit 697fa3c000696da559e52b664c04cbd8d261c037)\n(cherry picked from commit 75e4c86d90ae0229069fc2eb06bfb41436be7319)\n(cherry picked from commit 6972efdaa94d05952eb5b90e456b566c4c73360c)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/b555279add583e6b0cee1bddb8d5642c68ad84a6"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/b555279add583e6b0cee1bddb8d5642c68ad84a6"}]},"branch":"refs/heads/stable/yoga"}},"requirements":[],"submit_records":[],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review Priority","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{}}}]}