)]}'
{"id":"openstack%2Fplacement~801419","triplet_id":"openstack%2Fplacement~master~Ie0bee79c1ee185c0f68fa170c668395d9058c56d","project":"openstack/placement","branch":"master","topic":"fixsqlinstatus","hashtags":[],"change_id":"Ie0bee79c1ee185c0f68fa170c668395d9058c56d","subject":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.","status":"MERGED","created":"2021-07-20 07:17:10.000000000","updated":"2021-07-29 11:11:37.000000000","submitted":"2021-07-29 11:07:41.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":"801419-fixsqlinstatus","meta_rev_id":"90c39b6b8da0d0eeb164219c322a6bc6c6a0030b","_number":801419,"virtual_id_number":801419,"owner":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"actions":{},"labels":{"Verified":{"approved":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"tag":"autogenerated:zuul:gate","value":2,"date":"2021-07-29 11:07:41.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}],"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":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"all":[{"value":2,"date":"2021-07-23 14:08:47.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2021-07-29 09:49:34.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}],"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":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"all":[{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2021-07-29 09:49:34.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"}],"reviewers":{"REVIEWER":[{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"},{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":32823,"name":"Hannes von Haugwitz","display_name":"hvhaugwitz","email":"hannes@vonhaugwitz.com","username":"hvhaugwitz"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2021-07-20 07:22:10.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"state":"REVIEWER"},{"updated":"2021-07-20 07:22:10.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":9708,"name":"Balazs Gibizer","display_name":"gibi","email":"gibizer@gmail.com","username":"gibi"},"state":"REVIEWER"},{"updated":"2021-07-20 07:22:10.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":9373,"name":"Vlad Gusev","email":"vlad.esten@gmail.com","username":"s10"},"state":"REVIEWER"},{"updated":"2021-07-20 07:22:10.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"state":"REVIEWER"},{"updated":"2021-07-20 07:22:18.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":32823,"name":"Hannes von Haugwitz","display_name":"hvhaugwitz","email":"hannes@vonhaugwitz.com","username":"hvhaugwitz"},"state":"CC"},{"updated":"2021-07-20 08:18:54.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-07-23 09:26:48.000000000","updated_by":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"reviewer":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"state":"REVIEWER"},{"updated":"2021-07-23 14:08:47.000000000","updated_by":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"reviewer":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"state":"REVIEWER"}],"messages":[{"id":"3c2cd4f6dc1de68c85068b37078585d328b6f099","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-20 07:17:10.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"a7a2809b1b748199cbfc27b2e9c2879f1e0317e4","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-20 07:22:10.000000000","message":"Patch Set 1:\n\nCurrently the whole model, therefore all columns, are selected in the SQL query.\nThis patch only selects the column actually aggregated on / grouped by and should fix the linked issue.","accounts_in_message":[],"_revision_number":1},{"id":"c89414088236bf5db3725c052eab1d3ecc34d2a7","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-20 08:18:54.000000000","message":"Patch Set 1: Verified-1\n\n(1 comment)\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/55cd79c17fd04400aacc56540d52a839 : SUCCESS in 58m 08s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/a2ae6cf8ee8d49a79dabc9de3bd476a0 : SUCCESS in 1h 00m 10s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/2b1d307f5c2e4d59afee72dc190fcda7 : FAILURE in 7m 01s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/ccb7fdb756254c478f14db6a28c7a50f : SUCCESS in 7m 24s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/c5a12df1518f426e9af9573c0a67aba4 : FAILURE in 6m 13s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/9726cadf582943d6b739b88f5e0258a7 : SUCCESS in 5m 59s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/7ba039065c8443f481d0edbb5bb860ee : SUCCESS in 6m 30s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/a21b3371d41340d786ac940b2e56976d : SUCCESS in 6m 45s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d222ab78f8174d7abca786d8c3a0615b : SUCCESS in 8m 40s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/b55a204c969d4334b343b01613909824 : FAILURE in 6m 25s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/0becb22326af490dbf53044f8b3ea785 : FAILURE in 6m 40s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/8f255d57a3724fd4abdb003069593f1d : FAILURE in 6m 54s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/d655f9635b0e46a39edffe1841f53d76 : FAILURE in 7m 10s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/d81d11573959462c903ea0f7a08818b5 : SUCCESS in 13m 56s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/74bdf63ccc374295a9fac00d7a2cf241 : SUCCESS in 16m 49s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/20cfc89ebf254cdfaf5972eba59ec679 : SUCCESS in 10m 10s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/8a355f014ac84860803081314b1f9c07 : SUCCESS in 42m 21s","accounts_in_message":[],"_revision_number":1},{"id":"0ea78fd60edd81c6f17833fee3f818b9dcd7ada6","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-20 11:15:34.000000000","message":"Uploaded patch set 2.","accounts_in_message":[],"_revision_number":2},{"id":"58f006fe2b25146742a1a495d2f8207e2eb94433","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-20 12:14:52.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/2469b1cc6fcb4422ad6bee19dd63fd4a : SUCCESS in 56m 44s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/358ddc9929664db68d535ba1579fbab6 : SUCCESS in 57m 51s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/b1d9277e98364e469d06bf49bd6781da : FAILURE in 7m 29s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/a0451bdf7add4e13bb56dc726c633f6e : SUCCESS in 7m 36s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/143bd315e9304685a18a26a5d70412dc : SUCCESS in 6m 19s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e4eed13f47ef45239cc182b43856f7a5 : SUCCESS in 5m 58s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/a0d095c0e0ae40e88ec2868c21868452 : SUCCESS in 6m 11s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/27048de0372745378685b3ef130bb79d : SUCCESS in 7m 10s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/5b2ac5c086e14fd7b6153a4e99db4aeb : SUCCESS in 8m 49s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/7f3275dee96f44eb9615fc1de6fb47c0 : FAILURE in 5m 58s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/d11735cf82ab4517a4adcb8596c5d381 : FAILURE in 5m 58s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/62404cc50f7a4bcab0ba8b72154645f3 : FAILURE in 6m 54s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/9f00f3ff8a4b41288f0cd26c0edb8ebd : FAILURE in 7m 28s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/12d0824b90c9453e884096020e0ed607 : SUCCESS in 13m 57s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/c2e3446c4cc7489fa8dcbfb32aa84a25 : SUCCESS in 21m 14s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/6f5babf19b6e4d8ea8826633c7ed95e9 : SUCCESS in 10m 31s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/efced2a48a52471694fa7a3a45124007 : SUCCESS in 46m 29s","accounts_in_message":[],"_revision_number":2},{"id":"fc65c8825000962146d93027ae542636b0e3d88f","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-23 09:25:22.000000000","message":"Patch Set 2:\n\nrecheck","accounts_in_message":[],"_revision_number":2},{"id":"bb79c912574cbc93b21ab992c6aa68fde4105129","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-23 09:27:45.000000000","message":"Patch Set 3: Patch Set 2 was rebased","accounts_in_message":[],"_revision_number":3},{"id":"288ebec8cff824dc088d1d6203ddee624b197159","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-23 10:44:44.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/3b88658536b14e23a9cef04f7c69b7f0 : SUCCESS in 1h 10m 54s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/4e217ac5d26c40369cc22785fe400344 : SUCCESS in 1h 00m 58s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/360388f4640f41adb3f5ab567256ae4d : SUCCESS in 7m 07s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/12fd8d901fbf4a34b7e318edcef235bb : SUCCESS in 7m 30s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/b1430b0f19c54ed4b18850c15b63a17b : SUCCESS in 6m 35s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/7d026c555de0403d9186de64c29cd7bf : SUCCESS in 7m 51s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/016a38a418414ae9b6b6d80b7b7bc4e8 : SUCCESS in 5m 36s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/44ecae655cc6493295894b8ecc992b00 : SUCCESS in 8m 14s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/2d20fec0a1714a7ba15bb63432557fb2 : SUCCESS in 8m 59s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/d6ad9b95c39c413ea88d607ff6409924 : SUCCESS in 6m 30s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/9a9df8f94b24426a9ba2c707d78d8a7d : SUCCESS in 8m 44s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/1615796c3ca54a32ab9e43f6a8e72e38 : SUCCESS in 8m 00s\n- openstack-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/adaf8d73bdfa485aac80c5a65badd230 : SUCCESS in 7m 58s (non-voting)\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/fe6161f2e83345068276b8fb7a02f7b7 : SUCCESS in 15m 21s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/be4640393a9b4e05beaa6c2f4de055f8 : SUCCESS in 23m 56s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/60e601951fa648288e43083132ada325 : SUCCESS in 9m 57s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/bdf4244a107445438d636659b2f76723 : SUCCESS in 52m 31s","accounts_in_message":[],"_revision_number":3},{"id":"df272fbafa10201e5219788df474cd31bfb68e7e","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2021-07-23 14:08:47.000000000","message":"Patch Set 3: Code-Review+2\n\nI suspect it\u0027s SQLAlchemy that\u0027s at fault here, since its ORM is generating invalid SQL for Postgres, but the alternative proposed here should do the trick just fine so...","accounts_in_message":[],"_revision_number":3},{"id":"a6dfc51d5222e9bf0ee6daa0dc02568fdc127b32","author":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"date":"2021-07-29 09:26:51.000000000","message":"Patch Set 3:\n\n\u003e Patch Set 3: Code-Review+2\n\u003e \n\u003e I suspect it\u0027s SQLAlchemy that\u0027s at fault here, since its ORM is generating invalid SQL for Postgres, but the alternative proposed here should do the trick just fine so...\n\nThanks @stephenfin for your review and the +2.\nCan we get anybody else to have a look at this and get it merged?\n\nCause I\u0027d like to then send in backports as this is usually something used prior to upgrading one\u0027s OpenStack release, so the fix is doing more good in Ussuri / Victoria then in Wallaby or master currently.","accounts_in_message":[],"_revision_number":3},{"id":"094eab83489fb7407e151493436100a4656d6518","author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"date":"2021-07-29 09:49:34.000000000","message":"Patch Set 3: Code-Review+2 Workflow+1","accounts_in_message":[],"_revision_number":3},{"id":"e2ae733ee0e6b226e5526b10758e781c7c92cdb6","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-29 09:50:12.000000000","message":"Patch Set 3: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":3},{"id":"ce8d15a653d0c9b41a8938f162f50f6bfa123c13","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-29 11:07:41.000000000","message":"Patch Set 3: Verified+2\n\nBuild succeeded (gate pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/b97f7122dc3c44099d3c5155b8743bde : SUCCESS in 1h 01m 41s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/76c43edfd9d94c4383206d088ced1fb2 : SUCCESS in 1h 06m 35s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/c35d487e5fea489194b29b565a530784 : SUCCESS in 8m 33s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/adcf3c42ae76472f896e886f3840a598 : SUCCESS in 5m 49s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/a4c42d38924e4b76a08afa84de7a6438 : SUCCESS in 5m 23s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/90f830b3e68243b5a70ec37d78e88aba : SUCCESS in 7m 19s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/7434624181b9474d9f50fe9cf996b35e : SUCCESS in 9m 47s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/56ece53837064bf3b56b2a76d772f71c : SUCCESS in 8m 02s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/491300f961ca4339872f319dfd495679 : SUCCESS in 6m 23s\n- openstack-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/cdccd1b1c6f94985b7525843607a02b8 : SUCCESS in 7m 47s\n- placement-nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/14bc787d529e4d96bd6197e7e7b6d115 : SUCCESS in 14m 32s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/a07d8d2390634245bfbb547e5912f458 : SUCCESS in 52m 34s","accounts_in_message":[],"_revision_number":3},{"id":"198147f1acf212c394470f228a8afaf79b75ab75","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-29 11:07:41.000000000","message":"Change has been successfully merged by Zuul","accounts_in_message":[],"_revision_number":3},{"id":"90c39b6b8da0d0eeb164219c322a6bc6c6a0030b","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2021-07-29 11:11:37.000000000","message":"Patch Set 3:\n\nBuild succeeded (promote pipeline).\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/da0bd559533c43cf9ae5aa361ae970c9 : SUCCESS in 1m 43s","accounts_in_message":[],"_revision_number":3}],"current_revision_number":3,"current_revision":"616208914ab7adf5b68619e6fda26f5eda666a90","revisions":{"fd0239e444bec17d498e8a8e1bf7097b01421b33":{"kind":"REWORK","_number":1,"created":"2021-07-20 07:17:10.000000000","uploader":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"ref":"refs/changes/19/801419/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/19/801419/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/19/801419/1"}}},"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":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-20 07:11:37.000000000","tz":120},"committer":{"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-20 07:11:37.000000000","tz":120},"subject":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.","message":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.\n\nStory: 2006904\nTask: 37546\nChange-Id: Ie0bee79c1ee185c0f68fa170c668395d9058c56d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/fd0239e444bec17d498e8a8e1bf7097b01421b33"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/fd0239e444bec17d498e8a8e1bf7097b01421b33"}]},"branch":"refs/heads/master"},"7cca0749e3f1e7926d371753247179798ceed1bf":{"kind":"REWORK","_number":2,"created":"2021-07-20 11:15:34.000000000","uploader":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"ref":"refs/changes/19/801419/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/19/801419/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/19/801419/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":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-20 07:11:37.000000000","tz":120},"committer":{"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-20 11:15:28.000000000","tz":120},"subject":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.","message":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.\n\nStory: 2006904\nTask: 37546\nChange-Id: Ie0bee79c1ee185c0f68fa170c668395d9058c56d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7cca0749e3f1e7926d371753247179798ceed1bf"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/7cca0749e3f1e7926d371753247179798ceed1bf"}]},"branch":"refs/heads/master"},"616208914ab7adf5b68619e6fda26f5eda666a90":{"kind":"TRIVIAL_REBASE","_number":3,"created":"2021-07-23 09:27:45.000000000","uploader":{"_account_id":32755,"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","username":"frittentheke"},"ref":"refs/changes/19/801419/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/19/801419/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/19/801419/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/19/801419/3"}}},"commit":{"parents":[{"commit":"8d4c1c20f3a10f13bd1e1bbf818982456c42928e","subject":"Merge \"Bump os-resource-classes requirements\"","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/8d4c1c20f3a10f13bd1e1bbf818982456c42928e"}]}],"author":{"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-20 07:11:37.000000000","tz":120},"committer":{"name":"Christian Rohmann","email":"christian.rohmann@inovex.de","date":"2021-07-23 09:27:45.000000000","tz":0},"subject":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.","message":"Fix SQL query counting the number of individual consumers having allocations by only selecting the aggregated consumer_id column.\n\nStory: 2006904\nTask: 37546\nChange-Id: Ie0bee79c1ee185c0f68fa170c668395d9058c56d\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/616208914ab7adf5b68619e6fda26f5eda666a90"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/616208914ab7adf5b68619e6fda26f5eda666a90"}]},"branch":"refs/heads/master","description":"Rebase"}},"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":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"}}]}],"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":{}}}]}