)]}'
{"id":"openstack%2Fnova~785073","triplet_id":"openstack%2Fnova~stable%2Ftrain~Idcf026d020e63e4e6ece1db46e4cdc7b7742b76f","project":"openstack/nova","branch":"stable/train","topic":"bug/1837995","hashtags":[],"change_id":"Idcf026d020e63e4e6ece1db46e4cdc7b7742b76f","subject":"Centralize sqlite FK constraint enforcement","status":"ABANDONED","created":"2021-04-06 23:10:05.000000000","updated":"2023-09-01 17:02:42.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"7c18af0fbb9da2bf75e7d198eda88d50aa610b20","_number":785073,"virtual_id_number":785073,"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:29:29.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":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"}],"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-04-06 23:29:29.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 01:07:20.000000000","updated_by":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"reviewer":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"state":"CC"},{"updated":"2021-04-07 03:53:10.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":"237c2b1b73c7c68bb564e29d8e7466e7f566a059","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":"5736a933add1cd0fe6d1f45d6f52caa76be5cbcb","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-04-06 23:29:29.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/add25895778f40e9bef5a0cbfa624524 : FAILURE in 14m 59s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/6570822527a149078f322036eeee526e : FAILURE in 14m 50s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/172902fd1b1b4e83bb1b13facd24a5f4 : FAILURE in 11m 14s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/863d55c38c574864b5782a1b84b7a236 : FAILURE in 14m 47s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/8ac29fc02d0f43dcbaa8bcb63e99a271 : FAILURE in 13m 04s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/5720b04a4a0a447c8a09461aeb3c8f37 : FAILURE in 13m 12s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/31de44313f434ac2a03d0162f66643dc : SUCCESS in 11m 28s\n- nova-tox-functional https://zuul.opendev.org/t/openstack/build/bad0db03c84240f4aea76d6a4480895c : FAILURE in 9m 20s\n- nova-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/97fe58f127ba4970b18088cb0ccdf784 : FAILURE in 8m 38s","accounts_in_message":[],"_revision_number":1},{"id":"54b3ce492f235ee4271585251b355df0450011ef","author":{"_account_id":10118,"name":"IBM PowerKVM CI","email":"kvmpower@linux.vnet.ibm.com","username":"powerkvm","tags":["SERVICE_USER"]},"date":"2021-04-07 01:07:20.000000000","message":"Patch Set 1:\n\nBuild succeeded. Test completed on IBM PowerKVM platform. For rechecking only on the IBM PowerKVM CI, add a review comment with pkvm- recheck. For contact and more information, see https://wiki.openstack.org/wiki/PowerKVM\n\n- tempest-dsvm-full-bionic-py3 https://oplab9.parqtec.unicamp.br/pub/ppc64el/openstack/nova/73/785073/1/check/tempest-dsvm-full-bionic-py3/99e171f/ : SUCCESS in 1h 40m 16s","accounts_in_message":[],"_revision_number":1},{"id":"328189b80f3007ab2ee06923016a8445479d6d0f","author":{"_account_id":26515,"name":"Cloudbase Nova Hyper-V CI","email":"nova_hyperv_ci@cloudbasesolutions.com","username":"nova_hyperv_ci"},"date":"2021-04-07 03:53:10.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/785073/1/iscsi : SUCCESS in 2h 26m 41s","accounts_in_message":[],"_revision_number":1},{"id":"7c18af0fbb9da2bf75e7d198eda88d50aa610b20","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:42.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":"261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b","revisions":{"261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b":{"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/73/785073/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/73/785073/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/73/785073/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/73/785073/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/73/785073/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/73/785073/1"}}},"commit":{"parents":[{"commit":"04298cfb3e087efd4b3be20e8a5565a9d08da418","subject":"Merge \"Test for disabling greendns\" into stable/train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/04298cfb3e087efd4b3be20e8a5565a9d08da418"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-01-29 23:42:23.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-04-06 23:07:49.000000000","tz":0},"subject":"Centralize sqlite FK constraint enforcement","message":"Centralize sqlite FK constraint enforcement\n\nThere\u0027s a TODO in the code to centralize foreign key constraint\nenforcement for sqlite for unit and functional tests and we\u0027re missing\nenforcement of FK constraints in a couple of test classes that should\nhave it.\n\nThis resolves the TODO and turns on FK constraint enforcement where it\nis missing. Do this to enhance testing in preparation for a proposed\nchange to the database archiving logic later in this patch series.\n\nConflicts:\n    nova/test.py\n\nNOTE(melwitt): The conflicts are because the following changes are\nnot in Train:\n\n  * Ia33ec2604b2fc2d3b6830b596cac669cc3ad6c96 (nova-net: Kill it)\n  * I33d8ac0a1cae0b2d275a21287d5e44c008a68122 (func tests: move\n    _run_periodics() into base class)\n\nChange-Id: Idcf026d020e63e4e6ece1db46e4cdc7b7742b76f\n(cherry picked from commit 172024db7174bdac05a3d3172c645b0db83ae41e)\n(cherry picked from commit 382d64ea36e5cf3b47929fee0b93539d2f126975)\n(cherry picked from commit a8624cdaa292591db616b9ab17d27f2cd0bb00a7)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/261f4f614e4b0e7ea7dcb3dddbe2a34bd0deea4b"}]},"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":{}}}]}