)]}'
{"id":"openstack%2Ftrove~883737","triplet_id":"openstack%2Ftrove~stable%2Fzed~Iac875bcdff5e598326531b0fcf0e988a387dc3a5","project":"openstack/trove","branch":"stable/zed","attention_set":{},"removed_from_attention_set":{"31737":{"account":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"last_update":"2024-04-29 11:37:14.000000000","reason":"Change was abandoned"},"30941":{"account":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"last_update":"2024-04-29 11:37:14.000000000","reason":"Change was abandoned"},"26285":{"account":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"last_update":"2023-06-25 06:24:35.000000000","reason":"\u003cGERRIT_ACCOUNT_26285\u003e replied on the change","reason_account":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"}}},"hashtags":[],"change_id":"Iac875bcdff5e598326531b0fcf0e988a387dc3a5","subject":"Remove use \"with\" when start new connection in postgres datastore.","status":"ABANDONED","created":"2023-05-20 04:14:59.000000000","updated":"2024-04-29 11:37:14.000000000","total_comment_count":11,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"eed9991af77930ac1e49311172984cdf0cb20e71","_number":883737,"virtual_id_number":883737,"owner":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},{"tag":"autogenerated:zuul:check","value":1,"date":"2023-05-22 19:02:19.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"}],"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":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"all":[{"value":1,"date":"2023-06-14 19:04:10.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},{"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":-2,"max":2},"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"}],"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":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Backport-Candidate":{"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"}],"values":{"-1":"Not A Backport Candidate"," 0":"Backport Review Needed","+1":"Proposed Backport"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"}],"CC":[{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-05-20 05:26:50.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":"2023-05-22 11:33:57.000000000","updated_by":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"reviewer":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"state":"REVIEWER"},{"updated":"2023-06-14 19:04:01.000000000","updated_by":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"reviewer":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"state":"CC"},{"updated":"2023-06-14 19:04:10.000000000","updated_by":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"reviewer":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"state":"REVIEWER"},{"updated":"2024-04-29 11:37:14.000000000","updated_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"CC"}],"messages":[{"id":"7eb9986c3547fce17777c291edee3505f1c290bb","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-05-20 04:14:59.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"a625bfa4a1ff7bfe20da510f179744410f525db6","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-20 05:26:50.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/9bc41ee4079e49faa7e32a95105c0323\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/a3fd068868ef4000ba22a01d004acdd8 : FAILURE in 5m 39s (non-voting)\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/7d4d3f0e14664317b4357ea53323ad2a : SUCCESS in 4m 49s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/686f3575785f424cb9c6bb41137f504a : SUCCESS in 5m 14s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/bf37a31a19ab4bc7be9f37be09398d8c : SUCCESS in 5m 54s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/001a0266054f4f0fa3fb190cb24ed356 : SUCCESS in 5m 51s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/61c164750e3f48fc86f1d66c14be2443 : SUCCESS in 4m 56s\n- trove-tox-bandit-baseline https://zuul.opendev.org/t/openstack/build/0fc079d0f54b4e0a93c7da2d93fe0840 : SUCCESS in 4m 54s (non-voting)\n- trove-tempest https://zuul.opendev.org/t/openstack/build/6de34641d3804adb87adff95cbf6fc03 : SUCCESS in 1h 10m 51s (non-voting)\n- trove-tempest-postgres https://zuul.opendev.org/t/openstack/build/317fac68ddf04903a8f4ca4fa0b4f95c : FAILURE in 25m 23s (non-voting)\n- trove-tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/7d1730e356fc4f56b37ba3bba9004588 : FAILURE in 25m 46s (non-voting)\n- trove-functional-mysql https://zuul.opendev.org/t/openstack/build/d0eb5189531649a9b78f596c8829b0f3 : FAILURE in 26m 45s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"569c040688ce53612e057a7c433043f62d12a9d0","author":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"date":"2023-05-22 11:33:57.000000000","message":"Patch Set 1: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":1},{"id":"78793a72116130aae1e4e6327d1b8943d88fbfff","author":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"date":"2023-05-22 11:37:58.000000000","message":"Patch Set 1: Code-Review-1\n\n(2 comments)","accounts_in_message":[],"_revision_number":1},{"id":"ff9b2213f8c6c84947eaa39df005f81f56e14864","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-05-22 17:51:06.000000000","message":"Patch Set 2: Commit message was updated.\n\nOutdated Votes:\n* Code-Review-1 (copy condition: \"changekind:TRIVIAL_REBASE OR is:MIN\")\n* Verified+1\n","accounts_in_message":[],"_revision_number":2},{"id":"5dd08549e981617c5c2314c9c3d3fc0139edf9d0","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-05-22 17:55:04.000000000","message":"Patch Set 2:\n\n(2 comments)","accounts_in_message":[],"_revision_number":2},{"id":"fc40f6b1001b72cf86d4c2ba9f3274bc0023b21c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-05-22 19:02:19.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/da580fc8829a4a94ac2cb110f893c6c8\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/3e2d478fd57b4e7dbaf2c20434a1390b : FAILURE in 5m 43s (non-voting)\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c3fff933103c45208e2d37312b7f8d6b : SUCCESS in 6m 15s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/5a0382386fd144f2aeee1ae45dc5c516 : SUCCESS in 7m 05s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/1f2d46bb7e2a434a8e7e881827c435c1 : SUCCESS in 6m 33s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/b8698e22c3ab40c9be38a2238b2b472e : SUCCESS in 5m 39s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2bb06990396c4fee8053dbd89447ec9d : SUCCESS in 5m 32s\n- trove-tox-bandit-baseline https://zuul.opendev.org/t/openstack/build/14cf4b9987c44cf896b10176edeff087 : SUCCESS in 6m 44s (non-voting)\n- trove-tempest https://zuul.opendev.org/t/openstack/build/5c08117fe5db487fac9c727aedfe75d6 : SUCCESS in 1h 09m 52s (non-voting)\n- trove-tempest-postgres https://zuul.opendev.org/t/openstack/build/192853c57516457ba43a5d6a931533ae : SUCCESS in 1h 09m 53s (non-voting)\n- trove-tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/3f9280f99a1f4ab3a0539980360172a7 : FAILURE in 47m 07s (non-voting)\n- trove-functional-mysql https://zuul.opendev.org/t/openstack/build/efb024f542e547658f9e36db5f2f2563 : FAILURE in 31m 24s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"c7c4a4b7df54cc72b692db1fe047f4eff77caaa4","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-05-30 02:23:14.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"718c7eae3e2c5b7393b82e30ab9799499d84a63d","author":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"date":"2023-06-14 13:50:26.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"093e62e746dc9995e9d29f24dd06c31d7d984769","author":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"date":"2023-06-14 19:04:01.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"122876908ec98c97ccda69082de05c4b99c4a347","author":{"_account_id":31737,"name":"Hirotaka Wakabayashi","email":"hiwkby@yahoo.com","username":"hiwkby"},"date":"2023-06-14 19:04:10.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"420e5209f639a192b5616df0be479678f4622d45","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-06-15 07:53:27.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"e231bf5338f1ab59ae963b3ec6e7a3fe0bcdb740","author":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"date":"2023-06-15 07:54:07.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"7c2507d90d0dea530b12e9176adc7ec056be3c4c","author":{"_account_id":26285,"name":"wu.chunyang","email":"wchy1001@gmail.com","username":"wu.chunyang"},"date":"2023-06-25 06:24:35.000000000","message":"Patch Set 2:\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"eed9991af77930ac1e49311172984cdf0cb20e71","tag":"autogenerated:gerrit:abandon","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2024-04-29 11:37:14.000000000","message":"Abandoned\n\nstable/zed branch of openstack/trove is about to be deleted. To be able to do that, all open patches need to be abandoned. Please cherry pick the patch to unmaintained/zed if you want to further work on this patch.","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"6749ad7123ca505a27dc5b5c1a64ea92cfb15e9f","revisions":{"17d3804df45c840becd529a3bef5a9f0a041c9bd":{"kind":"REWORK","_number":1,"created":"2023-05-20 04:14:59.000000000","uploader":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"ref":"refs/changes/37/883737/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/trove","ref":"refs/changes/37/883737/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/trove refs/changes/37/883737/1"}}},"commit":{"parents":[{"commit":"7c8b90531402e8cd6ae879ab636fd636c123ebe5","subject":"Fixes permission problem when restoring backup","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/7c8b90531402e8cd6ae879ab636fd636c123ebe5"}]}],"author":{"name":"Hung, Nguyen Trong","email":"sudo.nguyenhung@gmail.com","date":"2023-05-20 04:14:30.000000000","tz":420},"committer":{"name":"Hung, Nguyen Trong","email":"sudo.nguyenhung@gmail.com","date":"2023-05-20 04:14:37.000000000","tz":420},"subject":"Remove use \"with\" when start new connection in postgres datastore. Due to bug in psycopg2 version 2.9.3, make \"CREATE DATABASE cannot run inside a transaction block\" in postgres datastore","message":"Remove use \"with\" when start new connection in postgres datastore.\nDue to bug in psycopg2 version 2.9.3, make \"CREATE DATABASE cannot run inside a transaction block\" in postgres datastore\n\nStory: #2010761\nTask: #48059\nChange-Id: Iac875bcdff5e598326531b0fcf0e988a387dc3a5\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/17d3804df45c840becd529a3bef5a9f0a041c9bd"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/17d3804df45c840becd529a3bef5a9f0a041c9bd"}]},"branch":"refs/heads/stable/zed"},"6749ad7123ca505a27dc5b5c1a64ea92cfb15e9f":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2023-05-22 17:51:06.000000000","uploader":{"_account_id":30941,"name":"Hung, Nguyen Trong","display_name":"hungnt1","email":"sudo.nguyenhung@gmail.com","username":"hungnt1"},"ref":"refs/changes/37/883737/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/trove","ref":"refs/changes/37/883737/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/trove refs/changes/37/883737/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/trove refs/changes/37/883737/2"}}},"commit":{"parents":[{"commit":"7c8b90531402e8cd6ae879ab636fd636c123ebe5","subject":"Fixes permission problem when restoring backup","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/7c8b90531402e8cd6ae879ab636fd636c123ebe5"}]}],"author":{"name":"Hung, Nguyen Trong","email":"sudo.nguyenhung@gmail.com","date":"2023-05-20 04:14:30.000000000","tz":420},"committer":{"name":"Hung, Nguyen Trong","email":"sudo.nguyenhung@gmail.com","date":"2023-05-22 17:51:06.000000000","tz":0},"subject":"Remove use \"with\" when start new connection in postgres datastore.","message":"Remove use \"with\" when start new connection in postgres datastore.\n\nDue to bug in psycopg2 version 2.9.3, make \"CREATE DATABASE cannot run inside a transaction block\" in postgres datastore\n\nStory: #2010761\nTask: #48059\nChange-Id: Iac875bcdff5e598326531b0fcf0e988a387dc3a5\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/6749ad7123ca505a27dc5b5c1a64ea92cfb15e9f"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/trove/commit/6749ad7123ca505a27dc5b5c1a64ea92cfb15e9f"}]},"branch":"refs/heads/stable/zed","description":"Edit commit message"}},"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":{}}}]}