)]}'
{"id":"openstack%2Fnova~785074","triplet_id":"openstack%2Fnova~stable%2Ftrain~Ia225ee86536248d2540de0d7a1cd012333e708a2","project":"openstack/nova","branch":"stable/train","topic":"bug/1837995","hashtags":[],"change_id":"Ia225ee86536248d2540de0d7a1cd012333e708a2","subject":"Add functional test for bug 1837995","status":"ABANDONED","created":"2021-04-06 23:10:05.000000000","updated":"2023-09-01 17:02:48.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"10892120a0106b2abfc09f945fb0eae8bc2963ab","_number":785074,"virtual_id_number":785074,"owner":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"actions":{},"labels":{"Verified":{"disliked":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":-1,"date":"2021-04-06 23:33:22.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":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-04-06 23:33:22.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":"2021-04-07 04:35:13.000000000","updated_by":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"reviewer":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"state":"CC"}],"messages":[{"id":"f5fb8695cb152c684b69141c9040ea1f2ede54af","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-04-06 23:10:05.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"e3f7e5428f549e4bfcc532acf18e2644079eabe6","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-04-06 23:33:22.000000000","message":"Patch Set 1: Verified-1\n\nBuild failed (check pipeline).  For information on how to proceed, see\nhttps://docs.opendev.org/opendev/infra-manual/latest/developers.html#automated-testing\n\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/40faaba9749a450a829b47dc2eb67e25 : FAILURE in 16m 15s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/001e1f28b35e489caf8a593cdd19d854 : FAILURE in 16m 33s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/866a8bd82d6548cca964c73725720859 : FAILURE in 11m 37s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/d898ad63d58b4e92a9bcdfbe243653d9 : FAILURE in 13m 44s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/6a7cddd0c7694ab2ab6f9efeeb8d92a9 : FAILURE in 13m 17s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/f14c6ba7cb674e468801d435e9c9f6a6 : FAILURE in 14m 43s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ac2e966a7251472aa65d4b18fbde818f : SUCCESS in 11m 48s\n- nova-tox-functional https://zuul.opendev.org/t/openstack/build/b426be3b99a048b194ee58c5d0220980 : FAILURE in 10m 10s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/c98372760c6a47cf9dd7c7756d8e4a7b : FAILURE in 9m 37s","accounts_in_message":[],"_revision_number":1},{"id":"5cc43330703fb2629129a1fe0d9dc9f7ba5e46a8","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2021-04-07 04:35:13.000000000","message":"Patch Set 1:\n\nBuild succeeded. For checking Nova with Ceph, add a comment with run-Cloudbase Nova Ceph Hyper-V CI\n\n- nova http://cloudbase-ci.com/nova/785074/1/iscsi : SUCCESS in 2h 59m 54s","accounts_in_message":[],"_revision_number":1},{"id":"10892120a0106b2abfc09f945fb0eae8bc2963ab","tag":"autogenerated:gerrit:abandon","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2023-09-01 17:02:48.000000000","message":"Abandoned\n\nstable/train branch of nova projects\u0027 have been tagged as End of Life. All open patches have to be abandoned in order to be able to delete the branch.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"6cda0f5e31df7ef802c087cacf60974b374b852c","revisions":{"6cda0f5e31df7ef802c087cacf60974b374b852c":{"kind":"REWORK","_number":1,"created":"2021-04-06 23:10:05.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/74/785074/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/74/785074/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/74/785074/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/74/785074/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/74/785074/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/74/785074/1"}}},"commit":{"parents":[{"commit":"261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b","subject":"Centralize sqlite FK constraint enforcement","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-02-12 21:40:16.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-04-06 23:09:34.000000000","tz":0},"subject":"Add functional test for bug 1837995","message":"Add functional test for bug 1837995\n\nThis adds a functional test to reproduce the bug where when calling an\nAPI that will examine a deleted instance record (examples: GET /servers/detail\nand GET /os-simple-tenant-usage), if that instance\u0027s related records\nhave only been partially archived (example: \u0027instance_extra\u0027 record was\narchived but \u0027instances\u0027 record has not been archived yet) then the API\ncall fails with the following error:\n\n  Unexpected API Error ... \u003cclass \u0027nova.exception.OrphanedObjectError\u0027\u003e\n  (HTTP 500)\n\nRelated-Bug: #1837995\n\nChange-Id: Ia225ee86536248d2540de0d7a1cd012333e708a2\n(cherry picked from commit 3d4e53f832792cc49001f1588164e28b84c16d7a)\n(cherry picked from commit 21241b38dd4bc2c74a69aed489ada5c611395920)\n(cherry picked from commit 37cff3c74d54bf0d19abe9502e5979b81e24f918)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/6cda0f5e31df7ef802c087cacf60974b374b852c"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/6cda0f5e31df7ef802c087cacf60974b374b852c"}]},"branch":"refs/heads/stable/train"}},"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":{}}}]}