)]}'
{"id":"openstack%2Fnova~922299","triplet_id":"openstack%2Fnova~master~I88c1e37a04a8c18490992d40526c40c63eb4ed11","project":"openstack/nova","branch":"master","hashtags":[],"change_id":"I88c1e37a04a8c18490992d40526c40c63eb4ed11","subject":"WIP: Work around deleted instances when performing data migration","status":"NEW","created":"2024-06-19 10:22:03.000000000","updated":"2024-06-19 12:36:44.000000000","submit_type":"MERGE_IF_NECESSARY","mergeable":false,"submittable":false,"total_comment_count":0,"unresolved_comment_count":0,"work_in_progress":true,"has_review_started":false,"meta_rev_id":"d6b8f1cf32f5877c2fa842989313a1ac7fbf6fe5","_number":922299,"virtual_id_number":922299,"owner":{"_account_id":31542,"name":"Andrew Bonney","email":"andrew.bonney@bbc.co.uk","username":"andrewbonney"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2024-06-19 12:30:38.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":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{"CC":[{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"reviewer_updates":[{"updated":"2024-06-19 10:33:50.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":"2024-06-19 12:30:38.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-06-19 12:36:44.000000000","updated_by":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"reviewer":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"state":"CC"}],"messages":[{"id":"f4636e349c3beb26e707689be639418d0344237d","tag":"autogenerated:gerrit:newWipPatchSet","author":{"_account_id":31542,"name":"Andrew Bonney","email":"andrew.bonney@bbc.co.uk","username":"andrewbonney"},"date":"2024-06-19 10:22:03.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"213ae85b3dc24f5b2dfc054a65c0f0cc30e4bcb9","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-06-19 10:33:50.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0a6d70c6b9474418a2775455207c3e73\n\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/377bf8d4f7644179a26a2b0aacd7d636 : SUCCESS in 10m 58s (non-voting)\n- openstack-tox-py311-arm64 https://zuul.opendev.org/t/openstack/build/5d70583241b442fabee0e29723efa9f2 : SUCCESS in 10m 09s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"72209cda626e388d25aa8e7813784b75f2ed86e6","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2024-06-19 12:30:38.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/ca3473459f4e490fb8afa3b74caf28c4\n\n- grenade-skip-level-always https://zuul.opendev.org/t/openstack/build/00ce8ac215374713a7b48ecc73bc9f86 : SUCCESS in 1h 00m 43s\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/466ace168bc84dbfb5ea2017e19d1a3d : SUCCESS in 1h 33m 04s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/ccd6344d1873420ebb002c298a09ecf8 : SUCCESS in 1h 06m 49s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/18d6709a64a6447092a68e0cdf079a56 : SUCCESS in 19m 21s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/3c81281fba154576ad257b434d03c84f : SUCCESS in 6m 50s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/f9f42b285efd43478b5d78780b3a7d87 : SUCCESS in 13m 10s\n- openstack-tox-py311 https://zuul.opendev.org/t/openstack/build/08bbab57da1148f095fa55c3a7ac69c1 : SUCCESS in 13m 34s\n- openstack-tox-py312 https://zuul.opendev.org/t/openstack/build/f7dee69e63f94c74ba3534fce8a8f0da : SUCCESS in 18m 19s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e70b04b2f70c46f3a5ca2ee18cf7e442 : SUCCESS in 10m 57s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/1126b06550ca4810b9144060769b12ba : SUCCESS in 1h 05m 27s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/cbf6e57510b148f7abb80b8db32ab6bf : SUCCESS in 1h 53m 09s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/05075df342d14d8c9318087a37da67d4 : SUCCESS in 45m 07s\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/9023b22ffb904119b49717b96a5f897e : SUCCESS in 50m 43s\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/2e301f71966e4b3d95f7b3e683939150 : SUCCESS in 2h 00m 19s\n- nova-next https://zuul.opendev.org/t/openstack/build/610308d378944dba861799c10651fe13 : SUCCESS in 1h 22m 21s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/25aab5a4fcd646b48a3a2b2314aea52d : SUCCESS in 45m 41s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/5ac58cde3d044170b8c46b0e645e1781 : SUCCESS in 5m 20s (non-voting)\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/2c27578351b44071be19565bcce7a1c8 : SUCCESS in 24m 15s\n- nova-tox-functional-py310 https://zuul.opendev.org/t/openstack/build/86220e8f83d64af893679653b115cfdf : SUCCESS in 26m 49s\n- nova-tox-functional-py312 https://zuul.opendev.org/t/openstack/build/5e653f5172bb49ceb9d719b7f002f32d : SUCCESS in 34m 13s\n- tempest-integrated-compute-enforce-scope-new-defaults https://zuul.opendev.org/t/openstack/build/e26de8ed76d04c13856511c93717aa65 : SUCCESS in 1h 32m 27s\n- tempest-integrated-compute-rbac-old-defaults https://zuul.opendev.org/t/openstack/build/034768440d1540f087e4c1e3715e297f : SUCCESS in 2h 02m 34s\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/01dbe59461ad4126a5b02e95d8cf61be : SUCCESS in 1h 19m 06s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/1439f2c05187427590e3ba60429c4638 : SUCCESS in 1h 03m 37s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/812ec5f31a454898a50b56d7b993d3c1 : SUCCESS in 26m 30s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/0af0b7ebc97d43ad9b589bc736209109 : SUCCESS in 28m 19s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"d6b8f1cf32f5877c2fa842989313a1ac7fbf6fe5","tag":"autogenerated:jenkins-gerrit-trigger","author":{"_account_id":34420,"name":"openstack lightbits","display_name":"Lightbits CI","email":"openstack@lightbitslabs.com","username":"openstack_lightbits"},"date":"2024-06-19 12:36:44.000000000","message":"Patch Set 1:\n\nBuild succeeded. log path: ${LOG_PATH}\nLeave a comment with \u0027run-Lightbits CI\u0027 to trigger a recheck. \nFor more information about CI, please see https://wiki.openstack.org/wiki/ThirdPartySystems/LightbitsLabs_CI","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"d8dd2f3ea4cadaf959be9896bc8f60f8e4d13292","revisions":{"d8dd2f3ea4cadaf959be9896bc8f60f8e4d13292":{"kind":"REWORK","_number":1,"created":"2024-06-19 10:22:03.000000000","uploader":{"_account_id":31542,"name":"Andrew Bonney","email":"andrew.bonney@bbc.co.uk","username":"andrewbonney"},"ref":"refs/changes/99/922299/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/99/922299/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/99/922299/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/99/922299/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/99/922299/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/99/922299/1"}}},"commit":{"parents":[{"commit":"7dc4b1ea627d864a0ee2745cc9de4336fc0ba7b5","subject":"Merge \"add functional repoducer for bug 2065927\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/7dc4b1ea627d864a0ee2745cc9de4336fc0ba7b5"}]}],"author":{"name":"Andrew Bonney","email":"andrew.bonney@bbc.co.uk","date":"2024-06-19 08:01:06.000000000","tz":60},"committer":{"name":"Andrew Bonney","email":"andrew.bonney@bbc.co.uk","date":"2024-06-19 08:01:06.000000000","tz":60},"subject":"WIP: Work around deleted instances when performing data migration","message":"WIP: Work around deleted instances when performing data migration\n\nWhen upgrading from 2023.1 to 2023.2 we found that compute_id\ndata migrations took a significant period of time and/or didn\u0027t\ncomplete correctly. This is due to deleted instances (without\na host/node set) could be re-evaluated in the loop every time it\nexecutes as they never gain a compute_id.\n\nI assume there is a good reason this approach wasn\u0027t used up\nfront, but having checked our databases it appears to be a valid\nworkaround in our deployments, so it is shared here in case it\nhelps others to move forwards.\n\nChange-Id: I88c1e37a04a8c18490992d40526c40c63eb4ed11\nRelated-Bug: #2065403\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/d8dd2f3ea4cadaf959be9896bc8f60f8e4d13292"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/d8dd2f3ea4cadaf959be9896bc8f60f8e4d13292"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","status":"OK","labels":[{"label":"Verified","status":"MAY","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"MAY"},{"label":"Workflow","status":"MAY"},{"label":"Review-Priority","status":"MAY"}]}],"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":{"label:Verified\u003dMAX":"","label:Verified\u003dMIN":""}}},{"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":{"label:Code-Review\u003dMAX":"","label:Code-Review\u003dMIN":""}}},{"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":{"label:Workflow\u003dMAX":"","label:Workflow\u003dMIN":""}}}]}