)]}'
{"id":"openstack%2Fplacement~800910","triplet_id":"openstack%2Fplacement~master~I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf","project":"openstack/placement","branch":"master","topic":"sqlalchemy-20","attention_set":{},"removed_from_attention_set":{"15334":{"account":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"last_update":"2022-04-14 10:18:22.000000000","reason":"Change was submitted"},"9816":{"account":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"last_update":"2022-04-07 15:22:21.000000000","reason":"Sylvain Bauza replied on the change"}},"hashtags":[],"change_id":"I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf","subject":"db: Replace implicit conversion of SELECT into FROM","status":"MERGED","created":"2021-07-15 10:43:54.000000000","updated":"2022-04-14 10:21:12.000000000","submitted":"2022-04-14 10:18:22.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":2,"unresolved_comment_count":0,"has_review_started":true,"submission_id":"800910-sqlalchemy-20","meta_rev_id":"7f9eae59daedd39d22a3790be39869aeccd9c2e7","_number":800910,"virtual_id_number":800910,"owner":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-04-14 10:18:22.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":2,"date":"2022-04-14 09:02:28.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2022-04-14 08:56:50.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"all":[{"value":1,"date":"2022-04-14 09:02:28.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":0,"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"recommended":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"all":[{"value":0,"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"value":1,"date":"2022-04-07 15:22:21.000000000","permitted_voting_range":{"min":1,"max":2},"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","value":1,"default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-07-15 11:47:35.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-02-08 12:01:08.000000000","updated_by":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"},{"updated":"2022-04-07 15:22:21.000000000","updated_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"reviewer":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"state":"REVIEWER"},{"updated":"2022-04-14 09:02:28.000000000","updated_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"reviewer":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"state":"REVIEWER"}],"messages":[{"id":"26bf77c03f519e4c32d5e367bc8546bff5d0ed34","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-15 10:43:54.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"3a6ad6fb3c8095dbec50fc5c21063ce736d04a42","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-15 11:47:35.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\n\n- grenade https://zuul.opendev.org/t/openstack/build/8792c8c9229d4d88a0b1260cdd4437cf : SUCCESS in 49m 33s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/01bae2bfed1f4380a0a128122659d5ab : SUCCESS in 1h 02m 07s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/a98f274be570423387289375e0333557 : SUCCESS in 10m 23s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/9e2beff81649420b916f0119e02f4f0f : FAILURE in 7m 59s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/abb640a3aac441738c0954bf66ee51a8 : SUCCESS in 6m 23s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/df9a248478a24313bce966cd76f363a3 : SUCCESS in 9m 04s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/638cd5f1727046a1b5fad7d5fce4270e : SUCCESS in 6m 59s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/df27e73901124ac0a0777524cddd7b85 : SUCCESS in 8m 42s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/c595deec28614ba1b81ab4f8d28cc297 : SUCCESS in 10m 57s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/0453917ae7c04f01b734907fb5d39471 : SUCCESS in 6m 18s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/cb2864fade8d4076b0a842c081121600 : SUCCESS in 6m 54s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/abc53b7dd4654fa7a1ce86f241bcb611 : SUCCESS in 6m 49s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/57a3a663aca34f0b9f53d53a739d6c6b : SUCCESS in 6m 57s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/174705685c9a4f758f0cbcc4c1fe43a9 : SUCCESS in 14m 56s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/ab6bcda0af6a490ab9056422f3195e29 : SUCCESS in 21m 33s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/d8ca29d338dc4ad08c3f7067241a87df : SUCCESS in 9m 15s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/8b8f2a5c72fa4dfa9a92d32d83bfa829 : SUCCESS in 44m 07s","accounts_in_message":[],"_revision_number":1},{"id":"7cc0f578763dcee4f1fd81941e37dc4ec4cf6eca","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-16 16:50:39.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"0783b968ef7e9b03cadaf1a366f4583a1c44818e","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-16 18:03:08.000000000","message":"Patch Set 2: 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\n\n- grenade https://zuul.opendev.org/t/openstack/build/d73551064e094f62ae101eab7f567151 : SUCCESS in 1h 01m 11s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/d80e7b4cdc464920bbd382f68081329d : SUCCESS in 1h 07m 15s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/385fb4fdb3af4ec59ca4cb6e8a8d26e0 : FAILURE in 7m 23s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/66866351830445edb0be8373db1b6baf : FAILURE in 8m 37s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/b1554ebc9de44db98e833b3985ea098e : SUCCESS in 6m 25s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f08d4c110e6f44e6848de709a4793a78 : SUCCESS in 8m 03s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/abe10b4a1b904da8a583426237259f50 : SUCCESS in 6m 39s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/3f3da1fb1966409086ee2ce21462c470 : SUCCESS in 8m 07s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/e9d1032df84a4c34b2bc152ea8381ea9 : SUCCESS in 9m 15s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/f77040bf31ac4b11b135fd6bc1860afa : FAILURE in 6m 32s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/4208052e382149e59951f14544d6a175 : FAILURE in 6m 57s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/f9ec90958b844de9b7393d2877ddacdf : FAILURE in 6m 52s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/b278e9d02eda4610961c19bdb27de273 : FAILURE in 7m 26s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/91b111fea08546348f98bdf18d9772ea : SUCCESS in 14m 56s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/480a00ccaa8141d7b4a02c7df65bce47 : SUCCESS in 23m 45s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/e8b1af6444024d4b967da034e1e40cf3 : SUCCESS in 9m 44s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/d03593c1f4bb42ad8adf4b7300a0db64 : SUCCESS in 46m 12s","accounts_in_message":[],"_revision_number":2},{"id":"675e62b8662269486ef38138bce3bae10e8db8d6","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-27 17:28:35.000000000","message":"Uploaded patch set 3: Patch Set 2 was rebased.","accounts_in_message":[],"_revision_number":3},{"id":"b5dacc8460e0e85d8caabd0faa0bd2b387ef757c","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-27 19:04:45.000000000","message":"Patch Set 3: 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\n\n- grenade https://zuul.opendev.org/t/openstack/build/90077a2b8753415ea79521c562bd50a5 : SUCCESS in 1h 03m 21s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/af4926ab468a4e4ea82c8b10b84f5845 : SUCCESS in 1h 09m 53s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/575ba71f902c44d2a092c1f4ea81ec33 : SUCCESS in 7m 31s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/1ad0bed5300b4355a1c14d664a8cb456 : FAILURE in 6m 54s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/62f530d8a2b54d0ab4983e1e1909b91e : SUCCESS in 5m 38s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/1301371212644a5c8c767c3d41bb4115 : SUCCESS in 5m 32s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/cff88e30061443d582bad51e24535d98 : SUCCESS in 5m 55s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/4958031b02494284ab625e209d09d7a8 : SUCCESS in 6m 45s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/74b205bb57ae4eab9bed4485aa061a32 : SUCCESS in 9m 16s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/2b5a721491ee472b8dfd77f6ae601f41 : SUCCESS in 6m 35s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/11a0e1fb66c44877bf29d979948d3abe : SUCCESS in 6m 28s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/5c1ccefa2ae34212a528812a40573d4e : SUCCESS in 9m 13s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/58ee5dd7e0a04d96b0d94978d79766cf : SUCCESS in 8m 16s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/65f62216cdb449b792231a4092d6304c : SUCCESS in 15m 31s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/54d8af3a374b4bf3bafe4910e886655a : SUCCESS in 23m 38s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/e3c565f9008e4875a3a4f6ad88c08369 : SUCCESS in 13m 11s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/8a9f0fa0b6da4d468f3c36050a8ca4e5 : SUCCESS in 51m 50s","accounts_in_message":[],"_revision_number":3},{"id":"5d2e2a1e32b5bf33c294d6797460be3bfc2145f8","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-28 09:44:06.000000000","message":"Uploaded patch set 4.","accounts_in_message":[],"_revision_number":4},{"id":"1f318b542c0fb03d0e8a8cf6f2f3e9982c9fa880","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-28 10:57:13.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/49bcf4d87d1a46c8a3ae225e8a07b0fd : SUCCESS in 4m 23s\n- grenade https://zuul.opendev.org/t/openstack/build/46dfff786425409b82791b5c29549b5b : SUCCESS in 56m 54s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/cb972a3f6e58495da76fe39c85f9b1df : SUCCESS in 1h 06m 50s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/ce18d091d2e24f6283a55287b7828da1 : SUCCESS in 7m 28s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/07b7fc5e41414b9fb8fb419bb8c6a650 : SUCCESS in 6m 56s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/075448ee6e554f56a14f5a908caba653 : SUCCESS in 6m 35s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/cb5a42c6ce254ec4bed0f9ff7c207ae5 : SUCCESS in 6m 10s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/c5f5f2246096405ba89c88bc3c057ece : SUCCESS in 7m 13s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/a2e901b17c5546cda9f1a9cafb831c7e : SUCCESS in 6m 52s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/81e21fd7d96a4d9ca631b296fd058bff : SUCCESS in 9m 10s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/b772c01b1f174f698c54f9365c189787 : SUCCESS in 6m 31s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/479cc6ef25774e429160f69e4bcb9367 : SUCCESS in 6m 21s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1a109e65279741c8bbd214683d348e51 : SUCCESS in 6m 39s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/b20b1ad9b92f46ad83534c564da58359 : SUCCESS in 6m 23s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/86f8d6a86b394d81a2c5bb268589f28f : SUCCESS in 15m 04s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/0aa51a68b2734dd5ab0aeaa69a6a3e00 : SUCCESS in 20m 10s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/088f5a6779eb4ddf9317d24c64eb345a : SUCCESS in 9m 59s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/531adb63eadc4d0aa0c429461d290edb : SUCCESS in 53m 17s","accounts_in_message":[],"_revision_number":4},{"id":"d38355f24aee93c518fd26f61a83c51982428f5b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"date":"2022-02-05 16:54:17.000000000","message":"Patch Set 5: Patch Set 4 was rebased","accounts_in_message":[],"_revision_number":5},{"id":"9ffd43fab11b8980af569b64b35d1d47339c4c6b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"date":"2022-02-05 17:00:57.000000000","message":"Uploaded patch set 6: Patch Set 5 was rebased.","accounts_in_message":[],"_revision_number":6},{"id":"5fdcb76d90f3fa989150d023dff9856f0e050076","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-02-05 18:26:25.000000000","message":"Patch Set 6: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/cdafdd778a204b9388b598729dcef364 : SUCCESS in 4m 33s\n- grenade https://zuul.opendev.org/t/openstack/build/85f47e7d922c4860a1984273451e630e : SUCCESS in 56m 30s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/c53a94f828ab452bad7e292e37174939 : SUCCESS in 1h 22m 45s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/5a788d34bc7445d4b36762ecc2dc994e : SUCCESS in 47m 31s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/e0edc43e67b04864a482b32cabdfcd76 : SUCCESS in 6m 50s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/c2090d5af48f428fb6d5d8da980424c8 : SUCCESS in 6m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/e462cb66e0d645bba72f6bb54b53461c : SUCCESS in 6m 26s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/b84271ff13f54acfb63d699d2215d082 : SUCCESS in 4m 43s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/5003ac68304b4f31ba7ead0a2cf5e044 : SUCCESS in 6m 15s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/8ebc68fc44f64b4a9e84b159a19db354 : SUCCESS in 7m 18s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/8b2107bf42be49cc9ab1e43cfab7bfa8 : SUCCESS in 5m 47s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/b8b6672b08de4454883d6cac4490ef89 : SUCCESS in 6m 01s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/b6d3be77ab154c4699b038e8c83b3379 : SUCCESS in 7m 16s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/fa3f6b1df9584ad09c553566d53ce928 : SUCCESS in 6m 02s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/56589f633e42480b93e680bbbd35a28e : SUCCESS in 17m 15s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/0b24f096d4fe4ac68b668cc17231353c : SUCCESS in 30m 04s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/802f20f0c8384418aa8ca21559c123b2 : SUCCESS in 8m 07s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/e94a043bc22343568bef2d53aca5e4ac : SUCCESS in 1h 00m 43s","accounts_in_message":[],"_revision_number":6},{"id":"a479f2a58125beeaf94c68a30b98663d16207e61","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-02-08 12:01:08.000000000","message":"Patch Set 6: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":6},{"id":"67087ce2b36ee266a82c64ddd02834e1913a0ffd","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-03-24 15:54:52.000000000","message":"Uploaded patch set 7.","accounts_in_message":[],"_revision_number":7},{"id":"87098ac43fdaf604a51245875af48ca2d20b6ae8","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-03-24 17:34:21.000000000","message":"Patch Set 7: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/bc35d99732d243ee8eaf2ae36dc8eae2 : SUCCESS in 6m 12s\n- grenade https://zuul.opendev.org/t/openstack/build/2788f336538e4d828d55012598329148 : SUCCESS in 56m 43s\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/4614e00985154a4f95989246536269af : SUCCESS in 1h 29m 21s (non-voting)\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/96279f06d441433db3af4ff9f3470951 : SUCCESS in 1h 16m 13s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/0577d2f033f142f483296dd56d32a147 : SUCCESS in 52m 28s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/99ea7714f30b4b57b34764c5a1c9fd5e : SUCCESS in 8m 43s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/486be95e760946f685a4fba8cf8ca0ce : SUCCESS in 8m 39s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/504f7b1122e24ab8984f298d9c4c835e : SUCCESS in 7m 45s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/806e1a5491ff42eea83c89a690613447 : SUCCESS in 7m 35s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/bcbae9a165a14ef280dc8edafffefa73 : SUCCESS in 7m 41s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/0371e30ed76344afa59fde4dc28bb166 : RETRY_LIMIT in 7m 02s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/cab0d12dac4e48439a438b6a9a6150ad : SUCCESS in 9m 55s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/9128e5f2be234803ba81bbcbdd4e1ad5 : SUCCESS in 7m 28s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/b585bba6c74d4c90b0ae3460da32c8ea : SUCCESS in 7m 41s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/91cb1630be3a4ae082f31b06fc9d7502 : SUCCESS in 7m 56s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/27aab4732c8f4eb4bc97a1b88794ae0f : SUCCESS in 8m 39s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/ec0a2b22da7f463c8ba5642452583bb9 : SUCCESS in 19m 15s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/e783a334fd644a208ae7fedbd1cbbe8b : SUCCESS in 39m 52s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/3affb41a14c74d47b8187a7e35e5ff30 : SUCCESS in 11m 15s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a774917c9ea34fb68e5d2712d4c7062d : SUCCESS in 54m 05s","accounts_in_message":[],"_revision_number":7},{"id":"a027f46fc52c1614b9288e2b994bfb3859309e0f","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-04-07 14:40:56.000000000","message":"Uploaded patch set 8: Patch Set 7 was rebased.","accounts_in_message":[],"_revision_number":8},{"id":"c93956ec3d7a30300d63c1ebcaf18ed9f25f5141","author":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"},"date":"2022-04-07 15:22:21.000000000","message":"Patch Set 8: Review-Priority+1","accounts_in_message":[],"_revision_number":8},{"id":"907b6d20776a5d0d3b1c8a1450ec6e9988d58d38","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-07 16:08:20.000000000","message":"Patch Set 8: Verified+1\n\nBuild succeeded (check pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/bf2460895a9e404eb3f3f0abe4376e63 : SUCCESS in 4m 26s\n- grenade https://zuul.opendev.org/t/openstack/build/40a1e9633f56486d81b59347aaf647e4 : SUCCESS in 1h 09m 44s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/aea39c02ae364f95a6871657cc8d8036 : SUCCESS in 1h 22m 09s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/58aff8aa0dee46c2a3a8342f5001d465 : SUCCESS in 51m 58s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/07675b6e81604afb840c0ae381c4ccfc : SUCCESS in 6m 38s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/91a027b506264503b9e2c12b599a0237 : SUCCESS in 7m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/6d13c5b213e244618fe2ce833c801cef : SUCCESS in 5m 27s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/b15fc5822baf44e88811dfdd77338dbc : SUCCESS in 6m 38s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/fbf42b9e41a444d6853d4d4142fd933f : SUCCESS in 6m 25s\n- openstack-tox-py310 https://zuul.opendev.org/t/openstack/build/c7a1559d353e4790861aa50680bc3c2f : RETRY_LIMIT in 4m 52s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/f2c7b32e26934082aa2ccc3501ad0c03 : SUCCESS in 7m 45s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/0b2dbd60e69c45a7beb1e0a517365055 : SUCCESS in 6m 06s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/4993106454e84997aaeb2979d57ad680 : SUCCESS in 6m 04s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1d256a2163ba44f5ab7f777d464a6043 : SUCCESS in 5m 48s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/92a16726dd6b459097f4371aa08d5a5a : SUCCESS in 6m 27s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/a1bea521d5a6426a8f5f0e34d5aad497 : SUCCESS in 18m 00s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/750fa621b54c4d1f9e8c8ef2c38ea51f : SUCCESS in 30m 18s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/0ca7192afc4049cb940542575c898187 : SUCCESS in 15m 07s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/76b2ed3a7daa40c88c34b64f5af30627 : SUCCESS in 53m 50s","accounts_in_message":[],"_revision_number":8},{"id":"34a598504036825344ae215befcc7230b5b4c19b","author":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"date":"2022-04-14 08:56:50.000000000","message":"Patch Set 8: Code-Review+2\n\n(1 comment)","accounts_in_message":[],"_revision_number":8},{"id":"8acb10df49c64e1078c4f9858fbb31eee35de5ce","author":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"},"date":"2022-04-14 09:02:28.000000000","message":"Patch Set 8: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":8},{"id":"394ed732e92ac3182499e8b43e316e124e8c4e0e","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 09:03:34.000000000","message":"Patch Set 8: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":8},{"id":"fdcb8e7bfed027b2cfef525af74d47ad4c0876c6","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:18:22.000000000","message":"Patch Set 8: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- requirements-check https://zuul.opendev.org/t/openstack/build/2ccad058873e4a31a168ef68eacf5d97 : SUCCESS in 5m 26s\n- grenade https://zuul.opendev.org/t/openstack/build/fec196b0317e4eb9a11614f20836f20b : SUCCESS in 1h 06m 30s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/af5b3c9f95254aa4be4187f50907f00c : SUCCESS in 1h 12m 24s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/63782364096643cdbc0d8f0bf2b3a977 : SUCCESS in 48m 45s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/69eb85eac3c14f088cc742afe28ec2b4 : SUCCESS in 7m 59s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/27127aca82fd4e0a9de38a910d7ed40a : SUCCESS in 6m 35s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/1cd9b5654b584d90bf748491f49be4f8 : SUCCESS in 7m 08s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/2724b0edcfa04eb0a85677aa4dbdfc31 : SUCCESS in 6m 45s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/977b67677b8c4ac4818a9bbb3a048567 : SUCCESS in 9m 24s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/29ce461041d74542b6a64b1a7cdb96a8 : SUCCESS in 7m 09s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/09873473673d45ea83d096938466eba8 : SUCCESS in 7m 16s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/b1ae333c10d84ecca10affcd8157d3b1 : SUCCESS in 7m 11s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/f8ed8abec40c440a9bcf7a20e37e64d1 : SUCCESS in 7m 17s\n- placement-nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/96c0ce8d1da24e73aa4812e4907204cc : SUCCESS in 16m 39s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/102a7e2c6f4d4494a94fd1db1b5956ed : SUCCESS in 58m 00s","accounts_in_message":[],"_revision_number":8},{"id":"273df241a6c59e2e5f20bbb67caafcab67fbc540","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:18:22.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":8},{"id":"7f9eae59daedd39d22a3790be39869aeccd9c2e7","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-04-14 10:21:12.000000000","message":"Patch Set 8:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/01d4396cae4f4c52ab1fc32a7b6db4a9 : SUCCESS in 1m 01s","accounts_in_message":[],"_revision_number":8}],"current_revision_number":8,"current_revision":"5a97e855f595bd0f2d4b1d493e06b1124b81757e","revisions":{"811961454fbf694fbfd8d36483ba741da3f10966":{"kind":"REWORK","_number":1,"created":"2021-07-15 10:43:54.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/1"}}},"commit":{"parents":[{"commit":"5a3bc370176d3c445899813dbbad896e68d6ee36","subject":"Fix oslo policy DeprecatedRule warnings","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5a3bc370176d3c445899813dbbad896e68d6ee36"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:42:26.000000000","tz":60},"subject":"objects: Replace implicit conversion of SELECT into FROM","message":"objects: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n    usage \u003d sa.alias(usage, name\u003d\u0027usage\u0027)\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/811961454fbf694fbfd8d36483ba741da3f10966"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/811961454fbf694fbfd8d36483ba741da3f10966"}]},"branch":"refs/heads/master"},"97d5249b786cbbad57c13efdb08a453e1153dc53":{"kind":"TRIVIAL_REBASE_WITH_MESSAGE_UPDATE","_number":2,"created":"2021-07-16 16:50:39.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/2"}}},"commit":{"parents":[{"commit":"4fa74c24e7d58f192ca9fb165243f0b1fc56491e","subject":"Move placement specs from nova","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/4fa74c24e7d58f192ca9fb165243f0b1fc56491e"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-16 16:35:48.000000000","tz":60},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/97d5249b786cbbad57c13efdb08a453e1153dc53"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/97d5249b786cbbad57c13efdb08a453e1153dc53"}]},"branch":"refs/heads/master"},"092dd108b880acc8d272b66d1a1c58e06ebf02cf":{"kind":"TRIVIAL_REBASE","_number":3,"created":"2021-07-27 17:28:35.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/3"}}},"commit":{"parents":[{"commit":"e7a99b93cf995e837694439d27feb5547cbb6d9c","subject":"setup: Replace dashes with underscores","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e7a99b93cf995e837694439d27feb5547cbb6d9c"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-27 17:19:41.000000000","tz":60},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/092dd108b880acc8d272b66d1a1c58e06ebf02cf"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/092dd108b880acc8d272b66d1a1c58e06ebf02cf"}]},"branch":"refs/heads/master"},"ee5f08b1a0d2b22abf56cdfdbd91517f8cc31c88":{"kind":"REWORK","_number":4,"created":"2021-07-28 09:44:06.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/4"}}},"commit":{"parents":[{"commit":"e7a99b93cf995e837694439d27feb5547cbb6d9c","subject":"setup: Replace dashes with underscores","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e7a99b93cf995e837694439d27feb5547cbb6d9c"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-28 09:42:14.000000000","tz":60},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nThis change requires bumping SQLAlchemy to 1.4.0, which is the first\nversion to introduce the selectable \u0027.subquery()\u0027 method. We must also\nbump oslo.db to 8.6.0, which is the first version to support SQLAlchemy\n1.4.x. The alternative would be to introduce a switch based on\nSQLAlchemy versions, but that\u0027s tech debt that\u0027ll have to be cleaned up.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/ee5f08b1a0d2b22abf56cdfdbd91517f8cc31c88"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/ee5f08b1a0d2b22abf56cdfdbd91517f8cc31c88"}]},"branch":"refs/heads/master"},"a3200cae7812a788d1564254b61db390ae723098":{"kind":"TRIVIAL_REBASE","_number":5,"created":"2022-02-05 16:54:17.000000000","uploader":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"ref":"refs/changes/10/800910/5","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/5","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/5 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/5 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/5 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/5"}}},"commit":{"parents":[{"commit":"0db3b11d19ffaf289886444f5dc7900cc95f609e","subject":"setup: Replace dashes with underscores","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/0db3b11d19ffaf289886444f5dc7900cc95f609e"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Takashi Kajinami","email":"tkajinam@redhat.com","date":"2022-02-05 16:54:17.000000000","tz":0},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nThis change requires bumping SQLAlchemy to 1.4.0, which is the first\nversion to introduce the selectable \u0027.subquery()\u0027 method. We must also\nbump oslo.db to 8.6.0, which is the first version to support SQLAlchemy\n1.4.x. The alternative would be to introduce a switch based on\nSQLAlchemy versions, but that\u0027s tech debt that\u0027ll have to be cleaned up.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/a3200cae7812a788d1564254b61db390ae723098"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/a3200cae7812a788d1564254b61db390ae723098"}]},"branch":"refs/heads/master","description":"Rebase"},"c492f9cc52337884390edd663d38cf1ad1da8ff4":{"kind":"TRIVIAL_REBASE","_number":6,"created":"2022-02-05 17:00:57.000000000","uploader":{"_account_id":9816,"name":"Takashi Kajinami","email":"kajinamit@oss.nttdata.com","username":"kajinamit"},"ref":"refs/changes/10/800910/6","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/6","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/6 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/6 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/6 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/6"}}},"commit":{"parents":[{"commit":"079e55fd1be124c8b6cd3c8653f798c4a0cb64f7","subject":"setup: Replace dashes with underscores","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/079e55fd1be124c8b6cd3c8653f798c4a0cb64f7"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Takashi Kajinami","email":"tkajinam@redhat.com","date":"2022-02-05 17:00:06.000000000","tz":540},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nThis change requires bumping SQLAlchemy to 1.4.0, which is the first\nversion to introduce the selectable \u0027.subquery()\u0027 method. We must also\nbump oslo.db to 8.6.0, which is the first version to support SQLAlchemy\n1.4.x. The alternative would be to introduce a switch based on\nSQLAlchemy versions, but that\u0027s tech debt that\u0027ll have to be cleaned up.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/c492f9cc52337884390edd663d38cf1ad1da8ff4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/c492f9cc52337884390edd663d38cf1ad1da8ff4"}]},"branch":"refs/heads/master"},"e130eea3827bb48cd35c115f5fb3026b266848c7":{"kind":"REWORK","_number":7,"created":"2022-03-24 15:54:52.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/7","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/7","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/7 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/7 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/7 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/7"}}},"commit":{"parents":[{"commit":"17545aa2f77e0a2fad5b4f147293950d2d484007","subject":"Merge \"setup: Replace dashes with underscores\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/17545aa2f77e0a2fad5b4f147293950d2d484007"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2022-03-24 15:41:40.000000000","tz":0},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nThis change requires bumping SQLAlchemy to 1.4.0, which is the first\nversion to introduce the selectable \u0027.subquery()\u0027 method. We must also\nbump oslo.db to 8.6.0, which is the first version to support SQLAlchemy\n1.4.x. The alternative would be to introduce a switch based on\nSQLAlchemy versions, but that\u0027s tech debt that\u0027ll have to be cleaned up.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e130eea3827bb48cd35c115f5fb3026b266848c7"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e130eea3827bb48cd35c115f5fb3026b266848c7"}]},"branch":"refs/heads/master"},"5a97e855f595bd0f2d4b1d493e06b1124b81757e":{"kind":"TRIVIAL_REBASE","_number":8,"created":"2022-04-07 14:40:56.000000000","uploader":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"ref":"refs/changes/10/800910/8","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/10/800910/8","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/8 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/8 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/10/800910/8 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/10/800910/8"}}},"commit":{"parents":[{"commit":"49d22d8291bc82c81fa133ee01e3ad7c58333a61","subject":"Merge \"Fix perfload jobs after consumer_types\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/49d22d8291bc82c81fa133ee01e3ad7c58333a61"}]}],"author":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2021-07-15 10:21:08.000000000","tz":60},"committer":{"name":"Stephen Finucane","email":"stephenfin@redhat.com","date":"2022-04-07 14:31:53.000000000","tz":60},"subject":"db: Replace implicit conversion of SELECT into FROM","message":"db: Replace implicit conversion of SELECT into FROM\n\nResolve the following warnings issued in recent versions of SQLAlchemy:\n\n  SADeprecationWarning: Implicit coercion of SELECT and textual SELECT\n  constructs into FROM clauses is deprecated; please call .subquery() on\n  any Core select or ORM Query object in order to produce a subquery\n  object.\n\nThe resolution is simple: instead of using \u0027FromClause.alias\u0027, use\n\u0027Query.subquery\u0027. A warning filter is included to prevent us\nreintroducing this issue in the future. It can be dropped once we start\nusing SQLAlchemy 2.0 where this behavior will be removed.\n\nThis change requires bumping SQLAlchemy to 1.4.0, which is the first\nversion to introduce the selectable \u0027.subquery()\u0027 method. We must also\nbump oslo.db to 8.6.0, which is the first version to support SQLAlchemy\n1.4.x. The alternative would be to introduce a switch based on\nSQLAlchemy versions, but that\u0027s tech debt that\u0027ll have to be cleaned up.\n\nChange-Id: I6300be962dc3ce391f70d7c7e8af7cb4d6ce9baf\nSigned-off-by: Stephen Finucane \u003cstephenfin@redhat.com\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5a97e855f595bd0f2d4b1d493e06b1124b81757e"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/5a97e855f595bd0f2d4b1d493e06b1124b81757e"}]},"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":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":11604,"name":"sean mooney","email":"smooney@redhat.com","username":"sean-k-mooney"}},{"label":"Review-Priority","status":"MAY","applied_by":{"_account_id":7166,"name":"Sylvain Bauza","email":"sbauza@redhat.com","username":"sbauza"}}]}],"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":{}}}]}