)]}'
{"id":"openstack%2Fkeystone~877027","triplet_id":"openstack%2Fkeystone~stable%2Ftrain~I86d10729cfc7c02f12df611b56f6e263969dfe4b","project":"openstack/keystone","branch":"stable/train","attention_set":{},"removed_from_attention_set":{"34980":{"account":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"last_update":"2023-03-13 11:49:56.000000000","reason":"Change was abandoned"}},"hashtags":[],"change_id":"I86d10729cfc7c02f12df611b56f6e263969dfe4b","subject":"Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)","status":"ABANDONED","created":"2023-03-13 08:11:10.000000000","updated":"2023-03-13 11:49:56.000000000","total_comment_count":1,"unresolved_comment_count":0,"has_review_started":true,"cherry_pick_of_change":746451,"cherry_pick_of_patch_set":1,"meta_rev_id":"1d9dce49ee84d17fb61ac9ce3c4a1d019cfa0205","_number":877027,"virtual_id_number":877027,"owner":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"actions":{},"labels":{"Verified":{"all":[{"value":0,"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":{"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}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-03-13 08:11:10.000000000","updated_by":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"reviewer":{"_account_id":27621,"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","username":"Vishakha"},"state":"CC"},{"updated":"2023-03-13 10:01:34.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":"b3ae9ae85efd522c4e338e65b4cfa6a81a131016","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"date":"2023-03-13 08:11:10.000000000","message":"Patch Set 1: Cherry Picked from branch master.","accounts_in_message":[],"_revision_number":1},{"id":"4d9dd8ec431412bb4f2ab22c0341d80cbc3bd966","author":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"date":"2023-03-13 08:11:38.000000000","message":"Patch Set 1:\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"1b87d4217401b87b23fa0bd233f0198732838b97","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-03-13 10:01:34.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\nhttps://zuul.opendev.org/t/openstack/buildset/d067414ec2ce4181ac5cfffa8ff566b9\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/b7e8612fd2da4706bdc42072bb1602f7 : FAILURE in 15m 51s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/53555fc3b19c4693876c9f1d9ec9dda7 : SUCCESS in 6m 12s\n- openstack-tox-py27 https://zuul.opendev.org/t/openstack/build/aeb41bee24f244efaf8c4c2ee775db9b : SUCCESS in 14m 16s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/fbd4aae30517428fa874f1b17f538196 : SUCCESS in 15m 29s\n- openstack-tox-py37 https://zuul.opendev.org/t/openstack/build/96c52cf5f2e3417a884102eb8214102a : SUCCESS in 13m 39s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0b8ad10f6d28404e9dcf760bec290c20 : SUCCESS in 13m 36s\n- tempest-full https://zuul.opendev.org/t/openstack/build/385a5d644f4940bd828eb4ee98ffb91f : SUCCESS in 1h 49m 40s\n- neutron-grenade https://zuul.opendev.org/t/openstack/build/235008585ddb45c7971f1043de2ca093 : SUCCESS in 1h 11m 20s\n- grenade https://zuul.opendev.org/t/openstack/build/08cfc8220fae4841877ab23dda28e1f8 : SUCCESS in 1h 30m 58s\n- tempest-full-py3 https://zuul.opendev.org/t/openstack/build/3a03a48477b440f5aaeef396f41340f1 : SUCCESS in 1h 43m 41s\n- keystone-dsvm-functional https://zuul.opendev.org/t/openstack/build/7a37667fa42149fd9093760903dd7b95 : SUCCESS in 50m 29s\n- keystone-dsvm-py3-functional https://zuul.opendev.org/t/openstack/build/ba17fc6397424986bb248c8ebd6d3d73 : SUCCESS in 31m 38s\n- keystone-dsvm-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/74a5bce5a0eb4590858d26696c71e4f6 : FAILURE in 17m 02s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15 https://zuul.opendev.org/t/openstack/build/aa0e6e6acdd6409fb56b37582d7d99c4 : FAILURE in 17m 53s (non-voting)\n- keystone-dsvm-py3-functional-federation-opensuse15-k2k https://zuul.opendev.org/t/openstack/build/58e2434da9394db9baf64a97c5b60e2f : FAILURE in 20m 18s (non-voting)\n- keystoneclient-devstack-functional https://zuul.opendev.org/t/openstack/build/e3281027a05c41c0ad24e093fbd68870 : SUCCESS in 13m 24s (non-voting)\n- keystone-dsvm-ldap-domain-specific-driver https://zuul.opendev.org/t/openstack/build/d92b1dd93b5b4047b2c24ba5110fc92f : SUCCESS in 57m 25s (non-voting)\n- grenade-py3 https://zuul.opendev.org/t/openstack/build/d86792656ebc4c28898907271b9d7351 : SUCCESS in 57m 49s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/5846d88bd41f422f97f0aac9f56c30be : SUCCESS in 50m 23s\n- keystone-tox-protection https://zuul.opendev.org/t/openstack/build/6e42315caf494536a2d6e58dfaa215e8 : SUCCESS in 42m 32s","accounts_in_message":[],"_revision_number":1},{"id":"2e781dff0aa6c028cb843169ff0ec4d59b8aa2ee","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"date":"2023-03-13 10:07:03.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"1d9dce49ee84d17fb61ac9ce3c4a1d019cfa0205","tag":"autogenerated:gerrit:abandon","author":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"date":"2023-03-13 11:49:56.000000000","message":"Abandoned","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"dd92bf9abefed7c478e49e1bccf8299859badb2a","revisions":{"4fa55613b1480d1535ed91a24f78fb62ff3fe04b":{"kind":"REWORK","_number":1,"created":"2023-03-13 08:11:10.000000000","uploader":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"ref":"refs/changes/27/877027/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/27/877027/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/27/877027/1"}}},"commit":{"parents":[{"commit":"236be80331d6885fb5926d320fc670a863ac5ee6","subject":"Merge \"Fix host:port handling\" into stable/train","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/236be80331d6885fb5926d320fc670a863ac5ee6"}]}],"author":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-08-17 08:07:48.000000000","tz":330},"committer":{"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","date":"2023-03-13 08:11:10.000000000","tz":0},"subject":"Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)","message":"Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)\n\nIn Ubuntu Bionic (18.04) mysql 5.7 version used to create\nthe user implicitly when using using the GRANT.\n\nUbuntu Focal (20.04) has mysql 8.0 and with mysql 8.0 there\nis no implicit user creation with GRANT. We need to\ncreate the user first before using GRANT command.\n\nThis patch updates tools/test-setup.sh so that keystone supports\nubuntu focal.\n\nStory: #2007865\nTask: #40190\n\nChange-Id: I86d10729cfc7c02f12df611b56f6e263969dfe4b\nCloses-Bug: #1885825\n(cherry picked from commit b54839f382b046b7ec8b9633fbea763d31d9949c)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/4fa55613b1480d1535ed91a24f78fb62ff3fe04b"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/4fa55613b1480d1535ed91a24f78fb62ff3fe04b"}]},"branch":"refs/heads/stable/train"},"dd92bf9abefed7c478e49e1bccf8299859badb2a":{"kind":"TRIVIAL_REBASE_WITH_MESSAGE_UPDATE","_number":2,"created":"2023-03-13 10:07:03.000000000","uploader":{"_account_id":34980,"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","username":"mustafakemalgilor"},"ref":"refs/changes/27/877027/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/keystone","ref":"refs/changes/27/877027/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/keystone refs/changes/27/877027/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/keystone refs/changes/27/877027/2"}}},"commit":{"parents":[{"commit":"8a383cbff91b2cc39b15e50ef0361b6875d4b847","subject":"[PooledLDAPHandler] Ensure result3() invokes message.clean()","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/8a383cbff91b2cc39b15e50ef0361b6875d4b847"}]}],"author":{"name":"Vishakha Agarwal","email":"agarwalvishakha18@gmail.com","date":"2020-08-17 08:07:48.000000000","tz":330},"committer":{"name":"Mustafa Kemal Gilor","email":"mustafa.gilor@canonical.com","date":"2023-03-13 10:05:39.000000000","tz":180},"subject":"Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)","message":"Fix user creation with GRANT in MySQL 8.0(Ubuntu Focal)\n\nIn Ubuntu Bionic (18.04) mysql 5.7 version used to create\nthe user implicitly when using using the GRANT.\n\nUbuntu Focal (20.04) has mysql 8.0 and with mysql 8.0 there\nis no implicit user creation with GRANT. We need to\ncreate the user first before using GRANT command.\n\nThis patch updates tools/test-setup.sh so that keystone supports\nubuntu focal.\n\nStory: #2007865\nTask: #40190\n\nChange-Id: I86d10729cfc7c02f12df611b56f6e263969dfe4b\nCloses-Bug: #1885825\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/dd92bf9abefed7c478e49e1bccf8299859badb2a"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/keystone/commit/dd92bf9abefed7c478e49e1bccf8299859badb2a"}]},"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":"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":{}}}]}