)]}'
{"id":"openstack%2Fkeystone~760613","triplet_id":"openstack%2Fkeystone~stable%2Fvictoria~I4df19c45c870ff3fb78578ca1fb7dd0d35da3c82","project":"openstack/keystone","branch":"stable/victoria","topic":"bug/1878938","hashtags":[],"change_id":"I4df19c45c870ff3fb78578ca1fb7dd0d35da3c82","subject":"Delete system role assignments from system_assignment table","status":"MERGED","created":"2020-10-30 16:02:41.000000000","updated":"2021-01-26 17:15:51.000000000","submitted":"2021-01-26 17:00:50.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"760613-bug/1878938","meta_rev_id":"5662b02f11014aa3e23c5c1d20a21f8062688de7","_number":760613,"virtual_id_number":760613,"owner":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},{"value":0,"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2021-01-26 17:00:46.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":"","default_value":0,"optional":true},"Code-Review":{"approved":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"recommended":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":1,"date":"2021-01-26 15:14:30.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},{"value":2,"date":"2021-01-25 17:27:34.000000000","_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":2,"date":"2021-01-26 14:12:32.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"value":0,"_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":"","value":1,"default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"all":[{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"date":"2020-10-30 16:02:41.000000000","_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},{"value":0,"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"date":"2020-10-30 16:02:41.000000000","_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":1,"date":"2021-01-26 15:16:54.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"value":0,"_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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-10-30 16:02:41.000000000","updated_by":{"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},"reviewer":{"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true},"state":"REVIEWER"},{"updated":"2020-10-30 16:02:41.000000000","updated_by":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"reviewer":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"state":"REVIEWER"},{"updated":"2020-10-31 00:22:49.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-01-22 18:53:17.000000000","updated_by":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"reviewer":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"state":"REVIEWER"},{"updated":"2021-01-22 18:53:17.000000000","updated_by":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"reviewer":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"state":"REVIEWER"}],"messages":[{"id":"1851b239070c598a68fb0982ebe8801c8a6e48d5","author":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"date":"2020-10-30 16:02:41.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"2e9442b638bc2cb366e671fcd0d6a28bf6eebe7d","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-31 00:22:49.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/a17cd9e5b94e41e49feddc57010f21fe : SUCCESS in 18m 57s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/20cba8a2ef86423ebe414fd90de25340 : SUCCESS in 12m 42s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/0342ca27fea54ab1bbbe716220814a2a : SUCCESS in 8m 25s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/3ca555eca8df4251ae778efebcbc52f7 : SUCCESS in 13m 30s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/92406a7c0462462e8a83848cac9cabbf : SUCCESS in 16m 02s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ff33e108a770403a953c57c15ccf5009 : SUCCESS in 12m 57s\n- grenade https://zuul.opendev.org/t/openstack/build/a66497d6b7c749deb5d2a104284374d0 : SUCCESS in 1h 03m 56s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/87191645f3ab40beb480b78bf407fff8 : SUCCESS in 1h 33m 25s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/00a7b18038144a5fb55b36f7aaf90660 : SUCCESS in 8m 20s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/50cf9054fee04d7b8718a54b0e6dbdbb : SUCCESS in 33m 25s\n- keystone-dsvm-py3-functional-federation-ubuntu-focal https://zuul.opendev.org/t/openstack/build/0a4e4e3336bc4b68b9f4861d45bb5228 : SUCCESS in 27m 53s (non-voting)\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/70991bc31fd24730bd4c4d96d0e45e70 : SUCCESS in 30m 10s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/0a69b189ecbf40c38dfa703db1b44f04 : SUCCESS in 17m 53s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/fa4975c4f1a9483ab615c974a840ab90 : FAILURE in 14m 40s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/50f7417c104e433caed76ca8293153a9 : SUCCESS in 59m 02s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/1084d8d34f69460db387616affe309bf : SUCCESS in 34m 56s","accounts_in_message":[],"_revision_number":1},{"id":"8b4ba1b9c1401b77455054d2519e946a07a6e0b6","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2021-01-25 17:27:34.000000000","message":"Patch Set 1: Code-Review+2","accounts_in_message":[],"_revision_number":1},{"id":"94b197042e797429b7c657801e4285bda50aabd1","author":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"date":"2021-01-26 14:12:32.000000000","message":"Patch Set 1: Code-Review+2\n\nI\u0027ll wait for Kristi to give his +1 before kicking this through.","accounts_in_message":[],"_revision_number":1},{"id":"3ee9bd3c3a373631367c504f27c99b330163f9e2","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2021-01-26 15:14:30.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"48bb5a497f0591cbf528ebcdd9c1d0cc78b60213","author":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"date":"2021-01-26 15:16:54.000000000","message":"Patch Set 1: Workflow+1","accounts_in_message":[],"_revision_number":1},{"id":"1c9eb55cc3cdf4f92fb694ade726cf25450ac913","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-01-26 15:17:26.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"a9cd5a5425f1301012aa243039c17cc1c035e91b","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-01-26 17:00:46.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c8eb728b58ac4dbf88e9e5c0691a9efb : SUCCESS in 9m 56s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/6cafd2f1a7da47c8892dd3bdec6178a5 : SUCCESS in 15m 01s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/678856cfac7a4d97bf39b9607125f0cd : SUCCESS in 19m 04s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/36be0bb34fff43a9a74eab05218d8553 : SUCCESS in 12m 46s\n- grenade https://zuul.opendev.org/t/openstack/build/ce092daede9743a59a337b0b12dd34d3 : SUCCESS in 1h 08m 46s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/3337eb8fb8c54fe8b02f3832aac0e06f : SUCCESS in 1h 22m 50s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/fce275dffe064b9caba26c34e28e0c44 : SUCCESS in 5m 59s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/dc184ed954484c748b0eded7a9bf5fc9 : SUCCESS in 30m 38s\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/99d026ee1ebf42ec8e6ef3b7fa5f612f : SUCCESS in 35m 14s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/d395a86b9cf84a74b8ba1ca7e10c57fc : SUCCESS in 1h 33m 30s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/86e4c22556a74aa5812195d11438c148 : SUCCESS in 24m 16s","accounts_in_message":[],"_revision_number":1},{"id":"8ef4967f8790426ee685a6698f22cb9770a417ea","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-01-26 17:00:50.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1},{"id":"5662b02f11014aa3e23c5c1d20a21f8062688de7","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-01-26 17:15:51.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c5e3cb26d8754f9bac4b98724aaa5658 : SUCCESS in 1m 51s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/e4ccae7177cc4e8eb751e9fbaa2da81e : SUCCESS in 1m 28s","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"6f93063ff95f3c65af106a09281427e411d01850","revisions":{"6f93063ff95f3c65af106a09281427e411d01850":{"kind":"REWORK","_number":1,"created":"2020-10-30 16:02:41.000000000","uploader":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"ref":"refs/changes/13/760613/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/13/760613/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/13/760613/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/13/760613/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/13/760613/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/13/760613/1"}}},"commit":{"parents":[{"commit":"a26a40d441e7f211fd68e0c1b9c779d965c19dea","subject":"Implement more robust connection handling for asynchronous LDAP calls","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/a26a40d441e7f211fd68e0c1b9c779d965c19dea"}]}],"author":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-05-27 06:38:41.000000000","tz":330},"committer":{"name":"Lance Bragstad","email":"lbragstad@gmail.com","date":"2020-10-30 16:01:45.000000000","tz":0},"subject":"Delete system role assignments from system_assignment table","message":"Delete system role assignments from system_assignment table\n\nThis patch ensures to delete the system role assignments from\nall the assignment tables in keystone after deleting the role\nuser has over the system.\n\nThis also make sure of deleting stale role assignments before\ndeleting role for the deployments that are already in this state.\n\nCloses-Bug: #1878938\n\nChange-Id: I4df19c45c870ff3fb78578ca1fb7dd0d35da3c82\n(cherry picked from commit c1dcbb05b4488f1fa3e7af4d9171d11702d94119)\n(cherry picked from commit b83170a386ba8da2195c7494d04d832ce9b6d7b0)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/6f93063ff95f3c65af106a09281427e411d01850"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/6f93063ff95f3c65af106a09281427e411d01850"}]},"branch":"refs/heads/stable/victoria"}},"requirements":[],"submit_records":[{"status":"CLOSED","labels":[{"label":"Verified","status":"OK","applied_by":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}},{"label":"Code-Review","status":"OK","applied_by":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"}}]}],"submit_requirements":[{"name":"Verified","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Verified\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Verified\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Workflow\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Workflow\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}},{"name":"Code-Review","status":"SATISFIED","is_legacy":true,"submittability_expression_result":{"expression":"label:Code-Review\u003dCustom-Rule","fulfilled":true,"status":"PASS","passing_atoms":["label:Code-Review\u003dCustom-Rule"],"failing_atoms":[],"atom_explanations":{}}}]}