)]}'
{"id":"openstack%2Fkeystone~760623","triplet_id":"openstack%2Fkeystone~stable%2Fqueens~I4df19c45c870ff3fb78578ca1fb7dd0d35da3c82","project":"openstack/keystone","branch":"stable/queens","topic":"bug/1878938","hashtags":[],"change_id":"I4df19c45c870ff3fb78578ca1fb7dd0d35da3c82","subject":"Delete system role assignments from system_assignment table","status":"ABANDONED","created":"2020-10-30 16:10:19.000000000","updated":"2022-07-15 16:50:07.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"2b047d988c86b561a57997f0ebb9c3f50db991a4","_number":760623,"virtual_id_number":760623,"owner":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2020-11-12 22:03:42.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"date":"2021-01-22 18:55:25.000000000","_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true}],"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":{"recommended":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"permitted_voting_range":{"min":-2,"max":2},"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"value":1,"date":"2021-01-26 16:04:11.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true}],"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":{"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"date":"2020-10-30 16:10:19.000000000","_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"date":"2020-10-30 16:10:19.000000000","_account_id":9954,"name":"Lance Bragstad","username":"lbragstad","inactive":true}],"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:10:19.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:10:19.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-11-12 22:03:42.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:55:25.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"},{"updated":"2021-01-22 18:55:25.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"}],"messages":[{"id":"1ac6994d9f6af00d8c5227fb92d53c932ab4b33e","author":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"date":"2020-10-30 16:10:19.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"55ad4adef4a458e1dedd67c8cdc5ce7c004c432c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-10-31 03:57:51.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-pep8 https://zuul.opendev.org/t/openstack/build/90c3ddc46862495893e857d0f3af37e5 : SUCCESS in 6m 03s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/66f8be60c0aa4804acbe05bf83c36c48 : SUCCESS in 13m 24s\n- openstack-tox-py35 https://zuul.opendev.org/t/openstack/build/5eebdc5cced44021b5d667bee67312b9 : SUCCESS in 13m 22s\n- build-openstack-sphinx-docs https://zuul.opendev.org/t/openstack/build/ca5d4f645c564b2aa7a314d2d9c9218e : SUCCESS in 11m 34s\n- tempest-full https://zuul.opendev.org/t/openstack/build/e63f8c3908db4a0c9dd70e6f03110eb5 : SUCCESS in 1h 19m 14s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/09c4eac1b1c14ada89ef5c2641467006 : TIMED_OUT in 4h 05m 32s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/8a91d69d84aa403f90e4f8381a18ebc2 : SUCCESS in 1h 15m 46s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/9720e87c8117405a9a1152df0cec3bc3 : SUCCESS in 8m 09s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/be09018be7f74d679baa681a8fedd6db : SUCCESS in 33m 49s\n- keystone-dsvm-functional-v3-only https://zuul.opendev.org/t/openstack/build/efacaea66f014ca59ffb3852e235cc65 : FAILURE in 31m 11s (non-voting)\n- keystone-dsvm-py35-functional-v3-only https://zuul.opendev.org/t/openstack/build/ae0966c9b1214dc9a08d15fdcc18c245 : FAILURE in 32m 13s (non-voting)\n- openstack-ansible-keystone-rolling-upgrade https://zuul.opendev.org/t/openstack/build/90729e597abe4c7292ef3739be6a518c : FAILURE in 4m 19s (non-voting)\n- legacy-keystoneclient-dsvm-functional https://zuul.opendev.org/t/openstack/build/60f7cd77eb414c8aabfe05aa66636e75 : FAILURE in 23m 50s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/358dcb7e256e4bbf9f3236b781815d1c : SUCCESS in 14m 10s\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/16363c2704f440fb98c180328eeb620f : SUCCESS in 42m 14s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"9302ff0522a5e202cc41891008395be9bd2ed10c","author":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"date":"2020-11-12 16:12:41.000000000","message":"Patch Set 1:\n\nrecheck","accounts_in_message":[],"_revision_number":1},{"id":"bd774d922dd82eb426dfe3debbfdd562a29040b9","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-11-12 22:03:42.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/6d4ea9c70b094dbe9c7f9d37aea95a06 : SUCCESS in 6m 43s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/69a52445772e49148f225b2271691d58 : SUCCESS in 17m 50s\n- openstack-tox-py35 https://zuul.opendev.org/t/openstack/build/eefd4ffb5c2e4741a288f273ae6c0224 : SUCCESS in 13m 28s\n- build-openstack-sphinx-docs https://zuul.opendev.org/t/openstack/build/118b1f5dd88f4e3c8b70282909f1634a : SUCCESS in 9m 27s\n- tempest-full https://zuul.opendev.org/t/openstack/build/ed60e15cb41b45ee9dbf2e1e761dbc52 : SUCCESS in 1h 25m 11s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/237d8d80f2da4057bf5c522e7cccdc82 : SUCCESS in 49m 07s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/500bb379013f4857a4683bd16d4938d7 : SUCCESS in 1h 30m 03s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/ed8f9546b2b4431f9de665de99260eb6 : SUCCESS in 7m 23s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/786afb98fbeb426db47ac1cb62f914d3 : SUCCESS in 29m 43s\n- keystone-dsvm-functional-v3-only https://zuul.opendev.org/t/openstack/build/7829bd0e52904582a7f50902de0abab8 : FAILURE in 25m 30s (non-voting)\n- keystone-dsvm-py35-functional-v3-only https://zuul.opendev.org/t/openstack/build/9bd5904baf254edcb73c744a182d7747 : FAILURE in 33m 52s (non-voting)\n- openstack-ansible-keystone-rolling-upgrade https://zuul.opendev.org/t/openstack/build/1ca3aea145114468be5aabb682520731 : FAILURE in 3m 47s (non-voting)\n- legacy-keystoneclient-dsvm-functional https://zuul.opendev.org/t/openstack/build/49c188ea0b0e49058305ffecb2f5b2eb : FAILURE in 33m 12s (non-voting)\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/e568a274f3264bf7bf1b6b71ee339e58 : SUCCESS in 16m 25s\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/d833e152ffa14153bc474925aa9e25ac : SUCCESS in 45m 40s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"5bdc4b54286594f7dfcffcf74473228f89399953","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2021-01-26 16:04:11.000000000","message":"Patch Set 1: Code-Review+1","accounts_in_message":[],"_revision_number":1},{"id":"2b047d988c86b561a57997f0ebb9c3f50db991a4","tag":"autogenerated:gerrit:abandon","author":{"_account_id":7973,"name":"Douglas Mendizábal","email":"dmendiza@redhat.com","username":"dougmendizabal"},"date":"2022-07-15 16:50:07.000000000","message":"Abandoned\n\nAbandoning unmerged stable/queens changes.","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"0d3b80fe55931e4fa874e9381d7c8041b59b1b3a","revisions":{"0d3b80fe55931e4fa874e9381d7c8041b59b1b3a":{"kind":"REWORK","_number":1,"created":"2020-10-30 16:10:19.000000000","uploader":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"ref":"refs/changes/23/760623/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/23/760623/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/23/760623/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/23/760623/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/23/760623/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/23/760623/1"}}},"commit":{"parents":[{"commit":"654dd5ee47d0b2a38506cd76f91faf1497a19f14","subject":"Add cadf auditing to credentials","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/654dd5ee47d0b2a38506cd76f91faf1497a19f14"}]}],"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:09:58.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(cherry picked from commit 6f93063ff95f3c65af106a09281427e411d01850)\n(cherry picked from commit 7ac0891375656d156f1a9601e3520052dddb39d0)\n(cherry picked from commit e8b477847cabe449be4d3b8a21d8236ddbd84064)\n(cherry picked from commit e4e43d75d56083ca5a05daba1f3a95eb61346f69)\n(cherry picked from commit 226fdb34c18cdec2c69f62b00f3b620c26cf0542)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0d3b80fe55931e4fa874e9381d7c8041b59b1b3a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/0d3b80fe55931e4fa874e9381d7c8041b59b1b3a"}]},"branch":"refs/heads/stable/queens"}},"requirements":[],"submit_records":[],"submit_requirements":[]}