)]}'
{"id":"openstack%2Fplacement~840702","triplet_id":"openstack%2Fplacement~stable%2Fvictoria~I569043dd9f1c964faf7d4fcbb901a93f9569bf3d","project":"openstack/placement","branch":"stable/victoria","topic":"bug/1780799","attention_set":{},"removed_from_attention_set":{"4690":{"account":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"last_update":"2022-12-20 16:25:25.000000000","reason":"Change was submitted"}},"hashtags":[],"change_id":"I569043dd9f1c964faf7d4fcbb901a93f9569bf3d","subject":"placement-status: check only consumers in allocation table","status":"MERGED","created":"2022-05-05 16:29:50.000000000","updated":"2023-01-05 02:11:20.000000000","submitted":"2022-12-20 16:25:25.000000000","submitter":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"total_comment_count":3,"unresolved_comment_count":1,"has_review_started":true,"submission_id":"840702-bug/1780799","meta_rev_id":"f0dcd967860aeb2d26f5ad7f7857f82f34141432","_number":840702,"virtual_id_number":840702,"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":[{"tag":"autogenerated:zuul:gate","value":2,"date":"2022-12-20 16:25:25.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"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":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":2,"date":"2022-12-20 13:14:03.000000000","permitted_voting_range":{"min":2,"max":2},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"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":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2022-12-20 13:14:03.000000000","permitted_voting_range":{"min":1,"max":1},"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"CC":[{"_account_id":21813,"name":"Andrey Volkov","email":"m@amadev.ru","username":"avolkov"}],"REVIEWER":[{"_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"]}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2022-05-05 16:29:50.000000000","updated_by":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"reviewer":{"_account_id":21813,"name":"Andrey Volkov","email":"m@amadev.ru","username":"avolkov"},"state":"CC"},{"updated":"2022-05-05 17:40:41.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-12-20 13:14:03.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":"ca8696c75fd3e538edeee5c6e3703e26b896c720","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-05-05 16:29:50.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"e87edf116a6c9ffdbe2bb3fbf0ef268a704552e6","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-05-05 17:40:41.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/06a0189db239462e8b807fdb28f73627 : SUCCESS in 1h 04m 03s\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/5c1bb8c496174378bb7b34cfaa23aef1 : FAILURE in 47m 17s (non-voting)\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/f3851d601e504adc9ceaa68afec85edb : SUCCESS in 1h 08m 41s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/7e51bf59569446ca9fc7e12356a77d1b : SUCCESS in 51m 49s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/f8b8cf99669d4d76b38deabb731c443f : SUCCESS in 6m 06s\n- openstack-tox-lower-constraints https://zuul.opendev.org/t/openstack/build/75c05007f6784046b90cc52055cbc11e : FAILURE in 5m 23s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/d4ef48c92fdf45dca5f426dea5f81875 : SUCCESS in 5m 16s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e0df05a5c602407e9683b6b9874fc219 : SUCCESS in 5m 35s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/70f98dcf978e4fa1a4bce316affe64ae : SUCCESS in 5m 59s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/978f70556d2b41b089dd3fd8c131ef8e : SUCCESS in 8m 23s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/6f511df1580d489bad78fcac4ea070cd : SUCCESS in 5m 51s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/950fcb5e3b9441bcb708d73d21a2173e : SUCCESS in 6m 51s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/60199b89124247088ac4739b65f7893b : SUCCESS in 22m 06s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/eb7ff75843004067b393828fc4c972b4 : SUCCESS in 9m 38s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/d3111fc8bb3946c986f39b33dcdc0666 : SUCCESS in 59m 02s","accounts_in_message":[],"_revision_number":1},{"id":"0074e2087b600bbd09b229583c27f1e22b466e9b","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-05-05 22:04:00.000000000","message":"Uploaded patch set 2: Patch Set 1 was rebased.","accounts_in_message":[],"_revision_number":2},{"id":"ffa6b882c0dd943b425d5179d0ee131c04688776","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-05-05 22:08:56.000000000","message":"Uploaded patch set 3: New patch set was added with same tree, parent, and commit message as Patch Set 2.","accounts_in_message":[],"_revision_number":3},{"id":"b7d96412c40138fd7740b2d5d4a38c5819d56ce7","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-05-05 23:23:23.000000000","message":"Patch Set 3: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/c19bd4eeeb954359ac8de531aac17ab9 : SUCCESS in 53m 11s\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/bbc1b32bd0e841749cb3ac8aed9ed038 : FAILURE in 37m 11s (non-voting)\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/4e981b02545f40bd93ef0aa41e456bae : SUCCESS in 1h 12m 47s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/564464f7241e4f2988379678add1800c : SUCCESS in 1h 00m 47s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/1663f31251e444f2bd19c77b1337d91f : SUCCESS in 6m 33s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/01fa0d67cf434edd90072b9c1caea040 : SUCCESS in 5m 13s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/7b6c457ae65e484ca7dd2c9482f7e8a9 : SUCCESS in 4m 24s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/58fcd51ece944ca39d82988dde615525 : SUCCESS in 6m 35s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/a76ae2e6abda42f7a21dcf147f4efadb : SUCCESS in 7m 38s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/4d07925fabf54bd4b4f84eaffcf67596 : SUCCESS in 4m 40s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/daf52cdf821c4b859bb6dda74895162c : SUCCESS in 5m 22s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/d08a5ab71d744628a903f894563e393c : SUCCESS in 17m 09s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/87e565fb270e415fafd34dfd3bdba13d : SUCCESS in 8m 57s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/0fb6f6e5a0e04bc9b27f3a6663c3a52a : SUCCESS in 54m 41s","accounts_in_message":[],"_revision_number":3},{"id":"4c5ea334161f727bf3a6ebcc3b81b9468fa6dcd3","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2022-05-13 20:03:59.000000000","message":"Uploaded patch set 4: Commit message was updated.","accounts_in_message":[],"_revision_number":4},{"id":"a26d321ebf11252c53583b575692c69d41374f58","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-05-13 21:19:48.000000000","message":"Patch Set 4: Verified+1\n\nBuild succeeded (check pipeline).\n\n- grenade https://zuul.opendev.org/t/openstack/build/3ce932b53ce44eba878e8df207150649 : SUCCESS in 1h 02m 55s\n- grenade-skip-level https://zuul.opendev.org/t/openstack/build/61da95cab6fc403b80ddc5f4d1474d98 : FAILURE in 49m 57s (non-voting)\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/a841f88d7b6a49b89369e9af32d40725 : SUCCESS in 1h 14m 28s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/61e3e79494d54902ad2e8436185d863e : SUCCESS in 57m 08s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/d27c3ab254b7476f93c6886c4689e19b : SUCCESS in 6m 07s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/9b2dd79bd4174dec9331093a3b61c7f5 : SUCCESS in 5m 03s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/f83dfd1d503c460da95fcb1dbdfe8ddb : SUCCESS in 4m 58s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/5f5eac90ab8c4d268afef61195a882be : SUCCESS in 5m 25s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/d2af85335cb3413995f53b7baf7a9d35 : SUCCESS in 7m 28s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/cec47c1c379844bc92fcc06a6756828a : SUCCESS in 5m 10s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/c208f61c59e44a119cbc96ffdcfb9d86 : SUCCESS in 6m 06s\n- placement-nested-perfload https://zuul.opendev.org/t/openstack/build/3ea534bbc1944458b9f03b9732cb66d8 : SUCCESS in 22m 20s (non-voting)\n- placement-perfload https://zuul.opendev.org/t/openstack/build/cded6fb3ad24405b9b75f516e444da6f : SUCCESS in 8m 27s (non-voting)\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/b7fd9771ba2f46929f8311977d7050c6 : SUCCESS in 52m 28s","accounts_in_message":[],"_revision_number":4},{"id":"27d5e6d54728926e9114935fe049c9d5ed466596","author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"date":"2022-12-20 13:14:03.000000000","message":"Patch Set 4: Code-Review+2 Workflow+1\n\n(2 comments)","accounts_in_message":[],"_revision_number":4},{"id":"738b721b7e5227b9434fc03ac0f2f7154c7f2b93","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-20 13:21:50.000000000","message":"Patch Set 4: -Verified\n\nStarting gate jobs.","accounts_in_message":[],"_revision_number":4},{"id":"35522265ce134d8138c88d543ec3bdb258920b3c","tag":"autogenerated:zuul:gate","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-20 16:25:25.000000000","message":"Patch Set 4: Verified+2\n\nBuild succeeded (gate pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/f1bf3697db1347b1b6829f3a88be65a5\n\n- grenade https://zuul.opendev.org/t/openstack/build/01afd51d211f40d9b7de8ff99cba6f6e : SUCCESS in 1h 02m 25s\n- tempest-integrated-placement https://zuul.opendev.org/t/openstack/build/91eabb54aa054fe3ab76b692ce658a5f : SUCCESS in 58m 38s\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/7be3624bf06d4f13aa4cb42dabe68e2f : SUCCESS in 51m 20s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/419fd19ebcce4dd6926a882ed5c754e6 : SUCCESS in 8m 01s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/e1af31c5cd054943b7afbf27e0acd05a : SUCCESS in 5m 50s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/bd141b7ea36b48e1aa2e7dbb67c85c07 : SUCCESS in 8m 24s\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/9ec422bb450a4aa4ad6f3ddc6b7d4d4e : SUCCESS in 8m 23s\n- openstack-tox-functional-py36 https://zuul.opendev.org/t/openstack/build/39df72155ef64a1da4ba763f9c0aaafe : SUCCESS in 5m 08s\n- openstack-tox-functional-py37 https://zuul.opendev.org/t/openstack/build/b8f5111de09e45758cc2ca9a33dd7987 : SUCCESS in 6m 36s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/e369525430b54441b81f2116833571aa : SUCCESS in 47m 19s","accounts_in_message":[],"_revision_number":4},{"id":"b32df72d83a17a2afdbc0873058dfd83d5b340fe","tag":"autogenerated:gerrit:merged","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-20 16:25:25.000000000","message":"Change has been successfully merged","accounts_in_message":[],"_revision_number":4},{"id":"21d9561b1195fe11fc48a8974a2a046358f4853b","tag":"autogenerated:zuul:promote","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2022-12-20 16:27:22.000000000","message":"Patch Set 4:\n\nBuild succeeded (promote pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/e3193a9f732a4a0dbbb6824e7039dfd2\n\n- promote-openstack-tox-docs https://zuul.opendev.org/t/openstack/build/00dbb5dbd1cf482fa46b907748f96d00 : SUCCESS in 46s","accounts_in_message":[],"_revision_number":4},{"id":"f0dcd967860aeb2d26f5ad7f7857f82f34141432","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-01-05 02:11:20.000000000","message":"Patch Set 4:\n\n(1 comment)","accounts_in_message":[],"_revision_number":4}],"current_revision_number":4,"current_revision":"93bd7f23ad6e993185e32f038db90bb81e8746e2","revisions":{"abbec22662a8ea949f252acee4eb5f8f4d2242a4":{"kind":"REWORK","_number":1,"created":"2022-05-05 16:29:50.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/02/840702/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/02/840702/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/02/840702/1"}}},"commit":{"parents":[{"commit":"dfaa1a0f0089c420dc77a48e35efe32f0f3e84f3","subject":"Update TOX_CONSTRAINTS_FILE for stable/victoria","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/dfaa1a0f0089c420dc77a48e35efe32f0f3e84f3"}]}],"author":{"name":"Andrey Volkov","email":"avolkov@mirantis.com","date":"2020-11-17 08:19:44.000000000","tz":180},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2022-05-05 16:29:31.000000000","tz":0},"subject":"placement-status: check only consumers in allocation table","message":"placement-status: check only consumers in allocation table\n\nInitially, _check_incomplete_consumers was intended to find the case\nwhen consumers are mentioned in allocation but do not exist in the\nconsumer table. Due to a bug it\u0027s possible to have rows in the\nconsumer table those are not in the allocation table. The second case\nit seems was not expected and it can be tricky to automate a cleanup\nwith zero touch upgrade.\n\nThis patch modifies the check such way it counts only consumers\npresented in the allocation table.\n\nRelated-bug: #1780799\nChange-Id: I569043dd9f1c964faf7d4fcbb901a93f9569bf3d\n(cherry picked from commit 3253e2efc05836b0b5cefafbf2b2656e9e1a50c7)\n(cherry picked from commit 69a0fb8bae4bc2538df266d8cbd788ac2ad61094)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/abbec22662a8ea949f252acee4eb5f8f4d2242a4"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/abbec22662a8ea949f252acee4eb5f8f4d2242a4"}]},"branch":"refs/heads/stable/victoria"},"4c393122279ddf69ae0035d1de15b95674618d32":{"kind":"TRIVIAL_REBASE","_number":2,"created":"2022-05-05 22:04:00.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/02/840702/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/02/840702/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/02/840702/2"}}},"commit":{"parents":[{"commit":"e3333ab1c9fedda926218e8f8f3504bae80f4e76","subject":"Use \u0027functional-without-sample-db-tests\u0027 tox env for placement nova job","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/e3333ab1c9fedda926218e8f8f3504bae80f4e76"}]}],"author":{"name":"Andrey Volkov","email":"avolkov@mirantis.com","date":"2020-11-17 08:19:44.000000000","tz":180},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2022-05-05 22:03:42.000000000","tz":0},"subject":"placement-status: check only consumers in allocation table","message":"placement-status: check only consumers in allocation table\n\nInitially, _check_incomplete_consumers was intended to find the case\nwhen consumers are mentioned in allocation but do not exist in the\nconsumer table. Due to a bug it\u0027s possible to have rows in the\nconsumer table those are not in the allocation table. The second case\nit seems was not expected and it can be tricky to automate a cleanup\nwith zero touch upgrade.\n\nThis patch modifies the check such way it counts only consumers\npresented in the allocation table.\n\nRelated-bug: #1780799\nChange-Id: I569043dd9f1c964faf7d4fcbb901a93f9569bf3d\n(cherry picked from commit 3253e2efc05836b0b5cefafbf2b2656e9e1a50c7)\n(cherry picked from commit 69a0fb8bae4bc2538df266d8cbd788ac2ad61094)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/4c393122279ddf69ae0035d1de15b95674618d32"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/4c393122279ddf69ae0035d1de15b95674618d32"}]},"branch":"refs/heads/stable/victoria"},"d11a12e51562e43906deedcb8493dc16353120f2":{"kind":"NO_CHANGE","_number":3,"created":"2022-05-05 22:08:56.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/02/840702/3","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/02/840702/3","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/3 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/3 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/3 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/02/840702/3"}}},"commit":{"parents":[{"commit":"503b1f27cefeadf127d3f9f274901eba52f67c01","subject":"Use \u0027functional-without-sample-db-tests\u0027 tox env for placement nova job","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/503b1f27cefeadf127d3f9f274901eba52f67c01"}]}],"author":{"name":"Andrey Volkov","email":"avolkov@mirantis.com","date":"2020-11-17 08:19:44.000000000","tz":180},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2022-05-05 22:08:41.000000000","tz":0},"subject":"placement-status: check only consumers in allocation table","message":"placement-status: check only consumers in allocation table\n\nInitially, _check_incomplete_consumers was intended to find the case\nwhen consumers are mentioned in allocation but do not exist in the\nconsumer table. Due to a bug it\u0027s possible to have rows in the\nconsumer table those are not in the allocation table. The second case\nit seems was not expected and it can be tricky to automate a cleanup\nwith zero touch upgrade.\n\nThis patch modifies the check such way it counts only consumers\npresented in the allocation table.\n\nRelated-bug: #1780799\nChange-Id: I569043dd9f1c964faf7d4fcbb901a93f9569bf3d\n(cherry picked from commit 3253e2efc05836b0b5cefafbf2b2656e9e1a50c7)\n(cherry picked from commit 69a0fb8bae4bc2538df266d8cbd788ac2ad61094)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/d11a12e51562e43906deedcb8493dc16353120f2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/d11a12e51562e43906deedcb8493dc16353120f2"}]},"branch":"refs/heads/stable/victoria"},"93bd7f23ad6e993185e32f038db90bb81e8746e2":{"kind":"NO_CODE_CHANGE","_number":4,"created":"2022-05-13 20:03:59.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/02/840702/4","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/placement","ref":"refs/changes/02/840702/4","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/4 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/4 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/placement refs/changes/02/840702/4 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/placement refs/changes/02/840702/4"}}},"commit":{"parents":[{"commit":"503b1f27cefeadf127d3f9f274901eba52f67c01","subject":"Use \u0027functional-without-sample-db-tests\u0027 tox env for placement nova job","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/503b1f27cefeadf127d3f9f274901eba52f67c01"}]}],"author":{"name":"Andrey Volkov","email":"avolkov@mirantis.com","date":"2020-11-17 08:19:44.000000000","tz":180},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2022-05-13 20:03:31.000000000","tz":0},"subject":"placement-status: check only consumers in allocation table","message":"placement-status: check only consumers in allocation table\n\nInitially, _check_incomplete_consumers was intended to find the case\nwhen consumers are mentioned in allocation but do not exist in the\nconsumer table. Due to a bug it\u0027s possible to have rows in the\nconsumer table those are not in the allocation table. The second case\nit seems was not expected and it can be tricky to automate a cleanup\nwith zero touch upgrade.\n\nThis patch modifies the check such way it counts only consumers\npresented in the allocation table.\n\nConflicts:\n    placement/cmd/status.py\n\nNOTE(melwitt): The conflict is because change\nIe0bee79c1ee185c0f68fa170c668395d9058c56d (Fix SQL query counting the\nnumber of individual consumers having allocations by only selecting the\naggregated consumer_id column.) is not in Wallaby.\n\nRelated-bug: #1780799\nChange-Id: I569043dd9f1c964faf7d4fcbb901a93f9569bf3d\n(cherry picked from commit 3253e2efc05836b0b5cefafbf2b2656e9e1a50c7)\n(cherry picked from commit 7f66845b6382513ae291914ea02787e9776505a0)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/93bd7f23ad6e993185e32f038db90bb81e8746e2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/placement/commit/93bd7f23ad6e993185e32f038db90bb81e8746e2"}]},"branch":"refs/heads/stable/victoria"}},"requirements":[],"submit_records":[{"rule_name":"gerrit~DefaultSubmitRule","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":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}},{"label":"Workflow","status":"OK","applied_by":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"}},{"label":"Review-Priority","status":"MAY"}]}],"submit_requirements":[]}