)]}'
{"id":"openstack%2Fkeystone~737225","triplet_id":"openstack%2Fkeystone~master~Ife92a3c9e0982baafb4224882681c0855f573580","project":"openstack/keystone","branch":"master","topic":"bug/1754677","hashtags":[],"change_id":"Ife92a3c9e0982baafb4224882681c0855f573580","subject":"Remove an assignment from domain and project","status":"MERGED","created":"2020-06-22 07:34:44.000000000","updated":"2020-08-25 22:56:24.000000000","submitted":"2020-08-25 22:54:38.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":4,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"737225-1598396078076-9749b533","meta_rev_id":"1d914a17d65b6692ef65c28aa2f678cd5681604b","_number":737225,"virtual_id_number":737225,"owner":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2020-08-25 22:54:37.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"date":"2020-08-11 16:31:00.000000000","_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"},{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":0,"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"}],"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":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"all":[{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"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"},{"value":2,"date":"2020-08-21 13:47:03.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":2,"date":"2020-08-25 21:09:33.000000000","_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"}],"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":{"approved":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"all":[{"value":0,"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"value":0,"date":"2020-06-24 05:51:56.000000000","_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},{"value":0,"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"value":1,"date":"2020-08-25 21:09:33.000000000","_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},{"value":0,"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"}],"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":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},{"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2020-06-22 07:38:32.000000000","updated_by":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"reviewer":{"_account_id":21420,"name":"Gage Hugo","email":"gagehugo@gmail.com","username":"ghugo"},"state":"REVIEWER"},{"updated":"2020-06-22 08:04:25.000000000","updated_by":{"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"},"reviewer":{"_account_id":28691,"name":"Bo Tran","email":"ministry.96.nd@gmail.com","username":"ministry"},"state":"REVIEWER"},{"updated":"2020-06-24 05:51:56.000000000","updated_by":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"reviewer":{"_account_id":5046,"name":"Lance Bragstad","email":"lbragstad@redhat.com","username":"ldbragst"},"state":"REVIEWER"},{"updated":"2020-08-21 13:47:03.000000000","updated_by":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"reviewer":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"state":"REVIEWER"},{"updated":"2020-08-25 21:09:33.000000000","updated_by":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"reviewer":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"state":"REVIEWER"},{"updated":"2020-08-25 22:54:37.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"}],"messages":[{"id":"4eabc9c107c156f6e6c64b0bb915f2d734b99a7e","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2020-06-22 07:34:44.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"fd7766a30a0fb3d3a082915512bbb95cab730899","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-06-22 09:05:27.000000000","message":"Patch Set 1: Verified-1\n\n(1 comment)\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/6cff1f4ea30049c3940b5a0c9127ee15 : SUCCESS in 42m 24s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/0e631cbdad924bd7abf981fa75b9c4b2 : TIMED_OUT in 41m 26s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/de00e9be3b274a139b896cef94d2e459 : FAILURE in 7m 13s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/0dc91ff445be4940a3afaf918807c652 : TIMED_OUT in 41m 43s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/c25eba8291cf442ab0c3bb7f329a69b2 : SUCCESS in 41m 53s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/ed3d38e2ecdf48249c2d1802b2712c9c : SUCCESS in 14m 22s\n- grenade https://zuul.opendev.org/t/openstack/build/0c1a5baf0ded444dac4286670b512e49 : SUCCESS in 1h 26m 52s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/335887f32c8f47feb7d86af883e45e00 : SUCCESS in 1h 25m 02s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/65a530b974564e38b2a96cb2dcf953de : SUCCESS in 11m 59s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/0ca8b83265644c438f08e3dd8fc02e0f : SUCCESS in 44m 59s\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/98b371a541444dd6b95bee40694c3c98 : SUCCESS in 36m 24s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/77c97d3383124f72a532ef1eb447ae26 : SUCCESS in 43m 53s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/4264f7e2c8604484bf0911b5436ab363 : SUCCESS in 22m 53s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/07e2ae3146e54e31beeaf0cfc8dc2ef4 : SUCCESS in 50m 37s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/20bb6272824045e5aa67d8f0bb22a9c8 : SUCCESS in 58m 01s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/219fee4058494105922798df81af8989 : SUCCESS in 45m 01s","accounts_in_message":[],"_revision_number":1},{"id":"ba74877c77c5342dbc13d7ea3190880a4dcff268","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2020-06-22 09:14:16.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"18534ab19cd53de73b4d529b5308d543c7693020","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-06-22 11:08:07.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3d4ddcc632f649f8be551a3c7fc9c477 : SUCCESS in 20m 48s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/c3220f4b7d9142be816177bd781a290e : SUCCESS in 26m 03s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/58d47ce8025c45088dac831770500f77 : SUCCESS in 8m 14s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/5311e93dd474409a9ffa5ae19a9fdba8 : SUCCESS in 12m 56s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/338f6fed41c447348324b47ee1b214c7 : SUCCESS in 40m 20s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/150280abe3c445d1bdc88461806d71c2 : SUCCESS in 15m 28s\n- grenade https://zuul.opendev.org/t/openstack/build/4e472e6a80a449a2a992550b2b3b8048 : SUCCESS in 1h 02m 35s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/90ea481e044b4762a369041bac1a34f4 : SUCCESS in 1h 27m 51s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/37514e5a391346119f2b506f3387e7c2 : SUCCESS in 9m 04s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/185143e472c44297922a8ec6bef51476 : SUCCESS in 39m 11s\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/42b87e0edeac46c780eeb75f463053c2 : SUCCESS in 39m 33s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/2ebd592a76c446609268505601ce490f : SUCCESS in 45m 35s\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/2553a932a4ab4032891f1dd0205abbf0 : SUCCESS in 19m 59s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/bc01cd62b3f84bfc8a278ec419e18dba : SUCCESS in 32m 36s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/062a623ce7b9460bb16cb51f9a39fa6d : SUCCESS in 59m 26s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/49ab59ceea394e638354552696592216 : SUCCESS in 44m 09s","accounts_in_message":[],"_revision_number":2},{"id":"f08db1531c5ed591387617630f175843ce4e3fd1","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2020-08-11 12:52:17.000000000","message":"Patch Set 2: Code-Review+1\n\n(1 comment)\n\nMinor question, otherwise looks good. Thanks Vishakha!","accounts_in_message":[],"_revision_number":2},{"id":"ac56c2405e5f342caf5d5d57b60db8cb807d6dcb","author":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"date":"2020-08-11 16:31:00.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"62cb4891a32ca69d611584f9a6cc49719f13ffef","author":{"_account_id":16465,"name":"Kristi Nikolla","email":"knikolla@bu.edu","username":"knikolla"},"date":"2020-08-21 13:47:03.000000000","message":"Patch Set 2: Code-Review+2\n\nLooks good to me. Thanks Vishakha!","accounts_in_message":[],"_revision_number":2},{"id":"6ed93876fa9f9f54784b407d5c9644ae07607c38","author":{"_account_id":8482,"name":"Colleen Murphy","email":"colleen@gazlene.net","username":"krinkle"},"date":"2020-08-25 21:09:33.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"c8493e38d88305cb973fce829a182d9d05450c97","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-08-25 21:09:49.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"b757c5bc31260c6121f17d5bd5ba10d7d647be78","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-08-25 22:54:37.000000000","message":"Patch Set 2: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/12c111307e894183b65d7a2dd11fb388 : SUCCESS in 15m 40s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c9d23a17a1db49e88ebac0666a7d79f1 : SUCCESS in 4m 46s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/b301d892ed5c414fac93cdd16724148e : SUCCESS in 12m 52s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bc793b62dacd425ea222e57a675aaaa3 : SUCCESS in 12m 05s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0bfe6b316b714e698aa8b1b46f4ad5d4 : SUCCESS in 12m 16s\n- grenade https://zuul.opendev.org/t/openstack/build/1e6c77b37a71494da28c1a6274474119 : SUCCESS in 1h 15m 30s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/969bdfd081524518b7bcf20ac11b7844 : SUCCESS in 1h 42m 56s\n- build-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/b552abf42f6a4291a0a2f53023c70224 : SUCCESS in 5m 51s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/23adbfa3da10426887a4e8005564e5f9 : SUCCESS in 48m 32s\n- keystone-dsvm-py3-functional-federation-ubuntu-focal-k2k https://zuul.opendev.org/t/openstack/build/213d0dd9395642708315eb0ae3a6fd85 : SUCCESS in 35m 53s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/ad2073361c7d46a5a758de9c09c93253 : SUCCESS in 1h 16m 44s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/039a018f9aac4fb6bca89199f4a233f5 : SUCCESS in 42m 45s","accounts_in_message":[],"_revision_number":2},{"id":"2b9a0c61d9a2f3e1383558f942f6c32e3df34df5","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-08-25 22:54:38.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":2},{"id":"239021106b445172ae5febf4800441fb2444a6a5","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2020-08-25 22:56:24.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/57745e10d5ee48f4b7c958db9e845898 : SUCCESS in 1m 23s\n- promote-openstack-releasenotes https://zuul.opendev.org/t/openstack/build/e6bbcf517fed49fab74360590e89dc09 : SUCCESS in 46s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"28faa24e68467f7c10e00e433fec61914e172ca1","revisions":{"f98187f643da277743928aed2888238baf8770f1":{"kind":"REWORK","_number":1,"created":"2020-06-22 07:34:44.000000000","uploader":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"ref":"refs/changes/25/737225/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/25/737225/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/25/737225/1"}}},"commit":{"parents":[{"commit":"a0346effc851809f8c098d31a42533a6649b001a","subject":"Imported Translations from Zanata","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/a0346effc851809f8c098d31a42533a6649b001a"}]}],"author":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-06-22 07:28:00.000000000","tz":330},"committer":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-06-22 07:28:00.000000000","tz":330},"subject":"Remove an assignment from domain and project","message":"Remove an assignment from domain and project\n\nWhen you setup a user with a role assignment on a domain\nand then a role assignment on a project \"acting as a domain\",\nyou can\u0027t actually remove them. The database throws you the\nerror \"Multiple rows were found for one()\" since it gets two\nresults for \"actor_id\" with the same \"target_id\".\n\nThis patch fixes this problem by filtering the database query\nby \"type\" field to determine whether it is a user domain relation\nor a user project and then removing the assignment.\n\nChange-Id: Ife92a3c9e0982baafb4224882681c0855f573580\nCloses-Bug: #1754677\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/f98187f643da277743928aed2888238baf8770f1"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/f98187f643da277743928aed2888238baf8770f1"}]},"branch":"refs/heads/master"},"28faa24e68467f7c10e00e433fec61914e172ca1":{"kind":"REWORK","_number":2,"created":"2020-06-22 09:14:16.000000000","uploader":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"ref":"refs/changes/25/737225/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/25/737225/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/25/737225/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/25/737225/2"}}},"commit":{"parents":[{"commit":"a0346effc851809f8c098d31a42533a6649b001a","subject":"Imported Translations from Zanata","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/a0346effc851809f8c098d31a42533a6649b001a"}]}],"author":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-06-22 07:28:00.000000000","tz":330},"committer":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-06-22 09:13:22.000000000","tz":330},"subject":"Remove an assignment from domain and project","message":"Remove an assignment from domain and project\n\nWhen you setup a user with a role assignment on a domain\nand then a role assignment on a project \"acting as a domain\",\nyou can\u0027t actually remove them. The database throws you the\nerror \"Multiple rows were found for one()\" since it gets two\nresults for \"actor_id\" with the same \"target_id\".\n\nThis patch fixes this problem by filtering the database query\nby \"type\" field to determine whether it is a user domain relation\nor a user project and then removing the assignment.\n\nChange-Id: Ife92a3c9e0982baafb4224882681c0855f573580\nCloses-Bug: #1754677\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/28faa24e68467f7c10e00e433fec61914e172ca1"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/28faa24e68467f7c10e00e433fec61914e172ca1"}]},"branch":"refs/heads/master"}},"requirements":[],"submit_records":[],"submit_requirements":[]}