)]}'
{"id":"openstack%2Fplacement~808477","triplet_id":"openstack%2Fplacement~master~I0aa33ed4b131d254a4ec5b8477660990e097b77b","project":"openstack/placement","branch":"master","topic":"story/2009209","hashtags":[],"change_id":"I0aa33ed4b131d254a4ec5b8477660990e097b77b","subject":"Call Engine.execute() in func tests for oslo.db 11.0.0","status":"MERGED","created":"2021-09-10 16:36:13.000000000","updated":"2021-09-13 09:00:50.000000000","submitted":"2021-09-10 19:00:05.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"808477-story/2009209","meta_rev_id":"1e7ced8708f70290ca0e4363efbec92d60d776c9","_number":808477,"virtual_id_number":808477,"owner":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2021-09-10 19:00:04.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"}],"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":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"all":[{"value":2,"date":"2021-09-10 17:57:02.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2021-09-10 17:49:12.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"}],"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":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"all":[{"value":1,"date":"2021-09-10 17:57:02.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"}],"reviewers":{"REVIEWER":[{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-09-10 16:44:36.000000000","updated_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"},{"updated":"2021-09-10 17:34:12.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-09-10 17:49:12.000000000","updated_by":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"reviewer":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"state":"REVIEWER"},{"updated":"2021-09-10 17:57:02.000000000","updated_by":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"reviewer":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"state":"REVIEWER"}],"messages":[{"id":"0d75f45772ed55074ba96c61578d2e0cbce48be5","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-09-10 16:36:13.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"6835ad6def0688a036072f74189f10f4efc78a5c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-09-10 17:34:12.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\n\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/a4cd539b106843268f872723c68a3037 : SUCCESS in 10m 02s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/aeffe12b39314b0699658c0461bb1284 : SUCCESS in 11m 02s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c78bf226d3664991a1cd88631d6a02c7 : SUCCESS in 8m 37s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/1e6ca811eb9b480ab78482ec7024434e : SUCCESS in 8m 18s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/609a904a417f4bb2abc8ade7bb925fa7 : SUCCESS in 7m 15s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/69b706dcf37e400aa771012bc43e4ad0 : SUCCESS in 7m 41s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/abb5b79e484b462a8954a1ea9c5db619 : SUCCESS in 10m 26s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/497202d115e64749bff1b06a237fa223 : SUCCESS in 6m 54s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/8953d39bd5754c20961d002f040a5ee2 : SUCCESS in 8m 06s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/817b9673f6c94c1c872939239897b99f : SUCCESS in 8m 35s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/906abd88ca80481e95367717806945dc : SUCCESS in 9m 41s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/aa3bbdc0fb7744dabfb3bb510b2827a5 : SUCCESS in 15m 53s","accounts_in_message":[],"_revision_number":1},{"id":"1489c04d4bf593a0ea16c724941aab79b94d1613","author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"date":"2021-09-10 17:49:12.000000000","message":"Patch Set 1: Code-Review+2\n\nAppears to work","accounts_in_message":[],"_revision_number":1},{"id":"d8a8e266a2c2d7659cdb9abda18aa1f6f0b296a3","author":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"date":"2021-09-10 17:57:02.000000000","message":"Patch Set 1: Code-Review+2 Workflow+1\n\nlgtm, I remember Tacker also has to modify the queries for 11.0.0 but did not realize that it is failing here too.","accounts_in_message":[],"_revision_number":1},{"id":"f83a67a3b5834e89686608ef79a735ffa4bf280f","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-09-10 17:57:40.000000000","message":"Patch Set 1: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":1},{"id":"fc9700c771374be2cbedd725cfe94c3a1a4dd256","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2021-09-10 18:13:32.000000000","message":"Patch Set 1:\n\n\u003e Patch Set 1: Code-Review+2 Workflow+1\n\u003e \n\u003e lgtm, I remember Tacker also has to modify the queries for 11.0.0 but did not realize that it is failing here too.\n\nYeah, we don\u0027t have cross-jobs for placement in openstack/requirements. I\u0027m going to work on adding ones similar to nova.","accounts_in_message":[],"_revision_number":1},{"id":"07f88229f4dbf879c5e217e11272cbdebb9571a6","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-09-10 19:00:04.000000000","message":"Patch Set 1: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/4eb643da4b554a96b2b637728197bf56 : SUCCESS in 9m 20s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/702384da0f824409a21f6bed502ef709 : SUCCESS in 6m 09s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/1552bd5c3871491b87a3681a9de185dc : SUCCESS in 6m 14s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/56ce7c8a6f964555b728653bae85448b : SUCCESS in 8m 44s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d2e51313bd2b4a6d9eeb9c3c3bb038a7 : SUCCESS in 9m 26s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/38c287cd306947649cefd1660482c40f : SUCCESS in 5m 55s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/b01953435df745bdaebf28ac69bfe7ae : SUCCESS in 8m 56s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/34f8322f81c441389032869c85057840 : SUCCESS in 9m 27s\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/5df517752ec94ab6844cb5fcd606aae6 : SUCCESS in 14m 32s","accounts_in_message":[],"_revision_number":1},{"id":"663254b19ff233cf0cf5fb68e9e0192b3064ee2c","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-09-10 19:00:05.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":1},{"id":"97aa33cc85dd09ee2ff89b91033b9caadc896290","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-09-10 19:01:41.000000000","message":"Patch Set 1:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9c31eb1ea2c3428f87f02bc6dcad5f2a : SUCCESS in 1m 06s","accounts_in_message":[],"_revision_number":1},{"id":"1e7ced8708f70290ca0e4363efbec92d60d776c9","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2021-09-13 09:00:50.000000000","message":"Patch Set 1:\n\nthank you Melanie!","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"7d903412550b17c10c037732b00e6ad521353680","revisions":{"7d903412550b17c10c037732b00e6ad521353680":{"kind":"REWORK","_number":1,"created":"2021-09-10 16:36:13.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/77/808477/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/77/808477/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/77/808477/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/77/808477/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/77/808477/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/77/808477/1"}}},"commit":{"parents":[{"commit":"8b000867ca50ca99877fe8819785918aa6f58764","subject":"Add reproducer for Project creation race bug","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/8b000867ca50ca99877fe8819785918aa6f58764"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-09-10 16:10:58.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2021-09-10 16:35:42.000000000","tz":0},"subject":"Call Engine.execute() in func tests for oslo.db 11.0.0","message":"Call Engine.execute() in func tests for oslo.db 11.0.0\n\nSince the requirements bump of oslo.db from 10.0.0 \u003d\u003e 11.0.0, the\nfunctional test jobs are failing with errors like this:\n\n  sqlalchemy.exc.UnboundExecutionError: This Insert is not directly\n  bound to a Connection or Engine. Use the .execute() method of a\n  Connection or Engine to execute this construct.\n\nThis adjusts the insert/update statements to execute through the\nEngine.execute() method as is directed in the error message.\n\nStory: 2009209\nTask: 43268\n\nChange-Id: I0aa33ed4b131d254a4ec5b8477660990e097b77b\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7d903412550b17c10c037732b00e6ad521353680"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7d903412550b17c10c037732b00e6ad521353680"}]},"branch":"refs/heads/master"}},"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":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"}},{"label":"Review-Priority","status":"MAY"}]}],"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":{}}}]}