)]}'
{"id":"openstack%2Ftacker~836260","triplet_id":"openstack%2Ftacker~stable%2Fyoga~I90729463613e8d4768e0e466b9636967ccfa48e7","project":"openstack/tacker","branch":"stable/yoga","topic":"bug/1967700","attention_set":{},"removed_from_attention_set":{"31857":{"account":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"last_update":"2022-04-22 02:49:44.000000000","reason":"Ayumu Ueha replied on the change"},"25701":{"account":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"last_update":"2022-04-22 01:40:47.000000000","reason":"Yasufumi Ogawa replied on the change"},"32102":{"account":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"last_update":"2022-04-07 06:41:42.000000000","reason":"Manpreet Kaur replied on the change"},"17255":{"account":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"last_update":"2022-04-22 03:12:57.000000000","reason":"Change was submitted"},"33455":{"account":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"last_update":"2022-04-22 03:12:57.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I90729463613e8d4768e0e466b9636967ccfa48e7","subject":"Suppress Warnings for SQL Alchemy IN operator","status":"MERGED","created":"2022-04-04 00:00:20.000000000","updated":"2022-04-22 03:14:30.000000000","submitted":"2022-04-22 03:12:57.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":1,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"836260-bug/1967700","meta_rev_id":"d070f6c62303807ff0cf2118400d0fa3c1b833a4","_number":836260,"virtual_id_number":836260,"owner":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"value":0,"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":0,"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-04-22 03:12:57.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":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"all":[{"value":2,"date":"2022-04-22 02:49:44.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"value":2,"date":"2022-04-22 01:40:47.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":1,"date":"2022-04-07 06:41:42.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},{"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":"","default_value":0,"optional":true},"Workflow":{"approved":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"all":[{"value":1,"date":"2022-04-22 02:49:44.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"value":0,"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"value":0,"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},{"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":[{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"}],"reviewers":{"REVIEWER":[{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-04-04 03:11:20.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":"2022-04-04 07:11:17.000000000","updated_by":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"reviewer":{"_account_id":17255,"name":"Toshiaki Takahashi","email":"ts-takahashi@nec.com","username":"takahashi_ts"},"state":"REVIEWER"},{"updated":"2022-04-04 07:11:17.000000000","updated_by":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"reviewer":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"state":"REVIEWER"},{"updated":"2022-04-04 07:11:17.000000000","updated_by":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"reviewer":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"state":"REVIEWER"},{"updated":"2022-04-04 07:11:17.000000000","updated_by":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"reviewer":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"state":"REVIEWER"}],"messages":[{"id":"64a8d754a5ccb5b318c4d14bde08ef24c6ba7bc1","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"date":"2022-04-04 00:00:20.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"75490c6e502ac808186115271d94cffba17869ba","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"date":"2022-04-04 00:01:30.000000000","message":"Uploaded patch set 2: Commit message was updated.","accounts_in_message":[],"_revision_number":2},{"id":"76143a8cb520447353ba243ff91681b212a04a93","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-04 03:11:20.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d78dcbf5311144bca4c813f92573afe3 : SUCCESS in 8m 24s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/d611fff90dce41f78d84b7d7958ceee3 : SUCCESS in 18m 27s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/68ebc3be16534d3d95217e857efc4ac6 : SUCCESS in 5m 45s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/6e7ed6739cf04047b2606b2b4dbf87db : SUCCESS in 17m 07s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/359dd26d8bce4d07af262d07c234e969 : SUCCESS in 16m 35s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/f4da8d372a56405fb4338160e2927abd : SUCCESS in 8m 03s\n- tacker-functional-devstack-multinode-legacy https://zuul.opendev.org/t/openstack/build/63ec0dcbc7594c7d8fb7cedfffdfd4d1 : SUCCESS in 1h 43m 35s\n- tacker-functional-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/34882d36c2ba4ec6b201ad260832e81e : SUCCESS in 2h 17m 32s\n- tacker-functional-devstack-multinode-sol-separated-nfvo https://zuul.opendev.org/t/openstack/build/497613bb8b154dddb0184f39d89a8968 : SUCCESS in 1h 08m 46s\n- tacker-functional-devstack-multinode-sol-kubernetes https://zuul.opendev.org/t/openstack/build/7329057dac354f099109a77ae31f1a4e : SUCCESS in 1h 39m 46s\n- tacker-functional-devstack-multinode-libs-master https://zuul.opendev.org/t/openstack/build/4ad16bb556e847bbad7dfbb100bc452e : SUCCESS in 1h 42m 27s\n- tacker-functional-devstack-multinode-sol-v2 https://zuul.opendev.org/t/openstack/build/646f800dcecf45e3a2c3e6da7f5513f0 : SUCCESS in 1h 54m 39s\n- tacker-functional-devstack-multinode-sol-kubernetes-v2 https://zuul.opendev.org/t/openstack/build/cc2d51daea614d6d843ab17ba8b2dbd9 : SUCCESS in 2h 15m 19s\n- tacker-functional-devstack-multinode-sol-multi-tenant https://zuul.opendev.org/t/openstack/build/43cbfe5d3f3a41c4940011b292a6621c : SUCCESS in 1h 05m 26s\n- tacker-functional-devstack-multinode-sol-kubernetes-multi-tenant https://zuul.opendev.org/t/openstack/build/7980ace2bd3940bbae1c920c0d782c41 : SUCCESS in 1h 07m 00s\n- tacker-compliance-devstack-multinode-sol https://zuul.opendev.org/t/openstack/build/be61ee2691b54ef69902b4f4c8e06c3d : TIMED_OUT in 3h 04m 14s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"50e64f221bd25b82d839693fcb7cbd9b2877ec83","author":{"_account_id":32102,"name":"Manpreet Kaur","email":"kaurmanpreet2620@gmail.com","username":"manpreet"},"date":"2022-04-07 06:41:42.000000000","message":"Patch Set 2: Code-Review+1\n\n(1 comment)","accounts_in_message":[],"_revision_number":2},{"id":"2cb12871b8e39b092db510ea2b652f606aa756df","author":{"_account_id":25701,"name":"Yasufumi Ogawa","email":"yasufum.o@gmail.com","username":"yasufum"},"date":"2022-04-22 01:40:47.000000000","message":"Patch Set 2: Code-Review+2","accounts_in_message":[],"_revision_number":2},{"id":"e07d4fce63c947b23d460dfd1f16e6bf39ceccf8","author":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"},"date":"2022-04-22 02:49:44.000000000","message":"Patch Set 2: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":2},{"id":"4624e1e6ff21eb2abe91324f09222dcbe87e377b","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 02:50:30.000000000","message":"Patch Set 2: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":2},{"id":"a16fd13c24dea1b0e6bf8ef08c2876ae029d84bf","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 03:12:57.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/b1c929e89b2a4e03b6252803d96a8d73 : SUCCESS in 17m 42s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/2033382f9d1a45b7bf3b906dc47f1006 : SUCCESS in 7m 21s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/3e6beb49df944027b943c308c1f6acbf : SUCCESS in 18m 27s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2084ad0015a849aeabac869808f7cc27 : SUCCESS in 17m 56s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e1e6ee00d25343bf942c7f2a768a5cdc : SUCCESS in 9m 13s","accounts_in_message":[],"_revision_number":2},{"id":"5cf4a2c296978948b1202a72c6c6623e8f24d548","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 03:12:57.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":2},{"id":"d070f6c62303807ff0cf2118400d0fa3c1b833a4","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-22 03:14:30.000000000","message":"Patch Set 2:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/69edc72bec7b47cfb2d8bc8f19a9cbfe : SUCCESS in 1m 09s","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"d06426d1e21cd8f9f0a52251fd44496c5ab727b9","revisions":{"de528a1f9b861e330bad2984fadf408c12e1f173":{"kind":"REWORK","_number":1,"created":"2022-04-04 00:00:20.000000000","uploader":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"ref":"refs/changes/60/836260/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/836260/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/836260/1"}}},"commit":{"parents":[{"commit":"4bc3b13584bb09c723f3afa1ce1f6fae2258af00","subject":"Merge \"Fix failure of testing privsep\" into stable/yoga","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/4bc3b13584bb09c723f3afa1ce1f6fae2258af00"}]}],"author":{"name":"Hiromu Asahina","email":"hiromu.asahina.az@hco.ntt.co.jp","date":"2022-04-03 14:34:40.000000000","tz":540},"committer":{"name":"Hiromu Asahina","email":"hiromu.asahina.az@hco.ntt.co.jp","date":"2022-04-03 23:59:48.000000000","tz":540},"subject":"Suppress Warnings for SQL Alchemy","message":"Suppress Warnings for SQL Alchemy\n\nThe `in_` operator of SQL Alchemy emits a warning when it coerces a\nSubquery object into a select() implicitly [1].\n\nThis patch suppresses the warnings by explicitly coercing a Subquery\nobject to select() as shown in [2].\n\n[1] https://github.com/sqlalchemy/sqlalchemy/commit/3d99ee28ed368c3bdbeaf872ef65b0c9a7c0da33\n[2] https://github.com/sqlalchemy/sqlalchemy/blob/605d0d905855684bfe4409532af98f336ae38f82/test/sql/test_operators.py#L3295-L3319\n\nCloses-Bug: #1967700\nChange-Id: I90729463613e8d4768e0e466b9636967ccfa48e7\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/de528a1f9b861e330bad2984fadf408c12e1f173"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/de528a1f9b861e330bad2984fadf408c12e1f173"}]},"branch":"refs/heads/stable/yoga"},"d06426d1e21cd8f9f0a52251fd44496c5ab727b9":{"kind":"NO_CODE_CHANGE","_number":2,"created":"2022-04-04 00:01:30.000000000","uploader":{"_account_id":33455,"name":"Hiromu Asahina","email":"hiromu.a5a@gmail.com","username":"h_asahina"},"ref":"refs/changes/60/836260/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/tacker","ref":"refs/changes/60/836260/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/tacker refs/changes/60/836260/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/tacker refs/changes/60/836260/2"}}},"commit":{"parents":[{"commit":"4bc3b13584bb09c723f3afa1ce1f6fae2258af00","subject":"Merge \"Fix failure of testing privsep\" into stable/yoga","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/4bc3b13584bb09c723f3afa1ce1f6fae2258af00"}]}],"author":{"name":"Hiromu Asahina","email":"hiromu.asahina.az@hco.ntt.co.jp","date":"2022-04-03 14:34:40.000000000","tz":540},"committer":{"name":"Hiromu Asahina","email":"hiromu.asahina.az@hco.ntt.co.jp","date":"2022-04-04 00:00:50.000000000","tz":540},"subject":"Suppress Warnings for SQL Alchemy IN operator","message":"Suppress Warnings for SQL Alchemy IN operator\n\nThe `in_` operator of SQL Alchemy emits a warning when it coerces a\nSubquery object into a select() implicitly [1].\n\nThis patch suppresses the warnings by explicitly coercing a Subquery\nobject to select() as shown in [2].\n\n[1] https://github.com/sqlalchemy/sqlalchemy/commit/3d99ee28ed368c3bdbeaf872ef65b0c9a7c0da33\n[2] https://github.com/sqlalchemy/sqlalchemy/blob/605d0d905855684bfe4409532af98f336ae38f82/test/sql/test_operators.py#L3295-L3319\n\nCloses-Bug: #1967700\nChange-Id: I90729463613e8d4768e0e466b9636967ccfa48e7\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/d06426d1e21cd8f9f0a52251fd44496c5ab727b9"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/tacker/commit/d06426d1e21cd8f9f0a52251fd44496c5ab727b9"}]},"branch":"refs/heads/stable/yoga"}},"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":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":31857,"name":"Ayumu Ueha","email":"ueha.ayumu@fujitsu.com","username":"ueha"}}]}],"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":{}}}]}