)]}'
{"id":"openstack%2Fnova~900822","triplet_id":"openstack%2Fnova~stable%2Fxena~I4bf83d1642b62ab103716aff6dae7438646e2b31","project":"openstack/nova","branch":"stable/xena","topic":"bug/2027755","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":"2024-03-05 19:12:15.000000000","reason":"Change was abandoned"}},"hashtags":[],"change_id":"I4bf83d1642b62ab103716aff6dae7438646e2b31","subject":"Decorate only Flavor.get_* methods that execute queries","status":"ABANDONED","created":"2023-11-13 19:25:14.000000000","updated":"2024-03-05 19:12:15.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"cbab77aa93a126fb6fd71278f14cfe52ceec9cd2","_number":900822,"virtual_id_number":900822,"owner":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"actions":{},"labels":{"Verified":{"recommended":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"all":[{"tag":"autogenerated:zuul:check","value":1,"date":"2023-11-14 00:47:14.000000000","permitted_voting_range":{"min":-2,"max":2},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","value":1,"default_value":0,"optional":true},"Code-Review":{"recommended":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"all":[{"value":0,"permitted_voting_range":{"min":-1,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":1,"date":"2023-11-24 04:54:10.000000000","permitted_voting_range":{"min":-1,"max":1},"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"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":"","value":1,"default_value":0,"optional":true},"Workflow":{"all":[{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"all":[{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},{"value":0,"permitted_voting_range":{"min":0,"max":1},"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"}],"values":{" 0":"Default Priority","+1":"Contributor Review Promise","+2":"Core Review Promise"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{"REVIEWER":[{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]}],"CC":[{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"}]},"pending_reviewers":{},"reviewer_updates":[{"updated":"2023-11-13 19:41:10.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":"CC"},{"updated":"2023-11-13 20:48:15.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":"2023-11-24 04:54:10.000000000","updated_by":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"reviewer":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"state":"REVIEWER"},{"updated":"2024-03-05 19:12:15.000000000","updated_by":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"reviewer":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"state":"CC"}],"messages":[{"id":"6e7a4f0747fb0bc54ea51324fb928a6b785ef0a7","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-11-13 19:25:14.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"737a87140314308267527fd66cd9708e69f06968","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-13 19:41:10.000000000","message":"Patch Set 1:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/e1efea1272694c85b414fa0be2b7bcf5\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/a527345923d644a7960d89ffbcb019c7 : SUCCESS in 8m 47s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/cdff55c7e7444fc4882a7a5b2f6b46ab : SUCCESS in 14m 59s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"264b36a70d8c04e322a51690a53b412bd82ce3c4","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-13 20:48:15.000000000","message":"Patch Set 1: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/0c39ca98aa434eb287d4b7a443ae908b\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/97499441d5c64a0cb716572f0bacf3b1 : SUCCESS in 52m 56s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/0e071638edda442282860fe0f55b195f : FAILURE in 41m 21s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/88b532a4b73a44aca5d5d93f161e5d56 : SUCCESS in 45m 50s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/96552166960649e0acde263743aae58f : SUCCESS in 12m 31s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/99b91ceeb1464488aecc2ff3d5a93b3f : SUCCESS in 7m 35s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/30a42753a4c948d29f66f30172c2b408 : SUCCESS in 12m 06s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/aff86252775c4806b0b8db087f2d9752 : SUCCESS in 13m 06s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/faf190b561b2420abf5de54f02ee5c9c : SUCCESS in 13m 22s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/0212216d3d44434c91b4bff173526ebc : SUCCESS in 9m 02s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/12835bcf205f43f29b631ff82712a99e : SUCCESS in 1h 07m 14s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/9ca5d321cdad4cf99538eccc94e93618 : SUCCESS in 1h 12m 57s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/b734b7af84ef4f6ead323310b9394503 : SUCCESS in 50m 52s (non-voting)\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/ea384c65b7b64ed9995b7b44527c642f : SUCCESS in 43m 13s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/504bda8506494a45af6bdad3814c7519 : SUCCESS in 59m 54s\n- nova-next https://zuul.opendev.org/t/openstack/build/4fad24ce4fe34f35a6cfe86efc79aec3 : SUCCESS in 1h 04m 39s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/a04c3b42f7e7485caa5703dabd284c38 : SUCCESS in 38m 30s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/8512621070f24fbd9e63cbbdfa453b28 : FAILURE in 5m 21s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/605302f5743241cd9fabce20ac6b698d : SUCCESS in 23m 25s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/a3986781bd204580883773657fdb1517 : SUCCESS in 17m 39s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/ec3cbee7bad9475d91714beef956a969 : SUCCESS in 20m 21s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/4e0b4876158240c0adeb5c269291a7fc : SUCCESS in 1h 16m 52s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/d13ec6a31bda4a8eb149e362b6e0e201 : SUCCESS in 55m 38s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/5b0aa8ac510c4ad892aa7565f3b1385f : SUCCESS in 34m 07s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/f3c7811a0406400692b70a22dc82741a : FAILURE in 34m 14s (non-voting)","accounts_in_message":[],"_revision_number":1},{"id":"b0ddf5e1e91a5db30b69e4e00afafcdad7acf6d4","tag":"autogenerated:gerrit:newPatchSet","author":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"date":"2023-11-13 23:05:31.000000000","message":"Uploaded patch set 2.\n\nOutdated Votes:\n* Verified+1\n","accounts_in_message":[],"_revision_number":2},{"id":"07879cd433746d75f93dfe8e530f3c8ac8ed893c","tag":"autogenerated:zuul:check-arm64","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-13 23:41:59.000000000","message":"Patch Set 2:\n\nBuild succeeded (ARM64 pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/d5e703de3e8648c7a2b27d8f5670754c\n\n- openstack-tox-py38-arm64 https://zuul.opendev.org/t/openstack/build/dedd903ba5ff4109a97f5971baad4333 : SUCCESS in 33m 40s (non-voting)\n- openstack-tox-py39-arm64 https://zuul.opendev.org/t/openstack/build/100764ef31d84c0fb23cd9ec3c7276b0 : SUCCESS in 15m 34s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"222e701514d993440b19965031f7189c0e4a3560","tag":"autogenerated:zuul:check","author":{"_account_id":22348,"name":"Zuul","username":"zuul","tags":["SERVICE_USER"]},"date":"2023-11-14 00:47:14.000000000","message":"Patch Set 2: Verified+1\n\nBuild succeeded (check pipeline).\nhttps://zuul.opendev.org/t/openstack/buildset/9710c13baf4d49b1b1c482d44968dc4b\n\n- tempest-integrated-compute https://zuul.opendev.org/t/openstack/build/5db5584a57234605a7995f6eae2e16a0 : SUCCESS in 1h 00m 07s\n- tempest-integrated-compute-centos-8-stream https://zuul.opendev.org/t/openstack/build/911e262f3da94b90bd98e84f3d0b1730 : FAILURE in 24m 26s (non-voting)\n- openstacksdk-functional-devstack https://zuul.opendev.org/t/openstack/build/137f5aa6085b4e8aa035682b56085f4c : SUCCESS in 34m 23s\n- openstack-tox-cover https://zuul.opendev.org/t/openstack/build/813ccf4e81d74595b6f65076e37920f6 : SUCCESS in 14m 56s\n- openstack-tox-pep8 https://zuul.opendev.org/t/openstack/build/4f885185287d4b76bfc46a8ad57b5a5d : SUCCESS in 8m 06s\n- openstack-tox-py36 https://zuul.opendev.org/t/openstack/build/00570efc668e43c9981747cb2de09305 : SUCCESS in 13m 09s\n- openstack-tox-py38 https://zuul.opendev.org/t/openstack/build/9eda2439d5484e6f92d21ec161e615f1 : SUCCESS in 10m 18s\n- openstack-tox-py39 https://zuul.opendev.org/t/openstack/build/7467f4600c734528b0893fc24444c4af : SUCCESS in 11m 22s (non-voting)\n- openstack-tox-docs https://zuul.opendev.org/t/openstack/build/02a64b29c48a4a5a83e4b61189c67ecd : SUCCESS in 8m 33s\n- ironic-tempest-ipa-wholedisk-bios-agent_ipmitool-tinyipa https://zuul.opendev.org/t/openstack/build/5c5ccd5a56ed4514891ac44906106665 : SUCCESS in 1h 05m 41s (non-voting)\n- nova-ceph-multistore https://zuul.opendev.org/t/openstack/build/7293bd79bd294cf698967708de294659 : SUCCESS in 56m 40s\n- nova-live-migration https://zuul.opendev.org/t/openstack/build/ce307956f4394d0a87b7473b9b936b31 : SUCCESS in 49m 31s (non-voting)\n- nova-live-migration-ceph https://zuul.opendev.org/t/openstack/build/d56b603991034720910f93100bc6f634 : SUCCESS in 36m 50s (non-voting)\n- nova-multi-cell https://zuul.opendev.org/t/openstack/build/cc4a09b04b2c4c369eb454d2ccd9779b : SUCCESS in 1h 03m 34s\n- nova-next https://zuul.opendev.org/t/openstack/build/832ffc0be6274834b809c2f37000baab : SUCCESS in 1h 06m 49s\n- nova-ovs-hybrid-plug https://zuul.opendev.org/t/openstack/build/ac07e92c52384f39b9f1251ef6eab491 : SUCCESS in 53m 44s\n- nova-tox-validate-backport https://zuul.opendev.org/t/openstack/build/f68e55dcc64147c0b67565eda0e949ef : FAILURE in 5m 06s (non-voting)\n- nova-tox-functional-centos8-py36 https://zuul.opendev.org/t/openstack/build/47bdd78774e74f4287bcf03e7dce009e : SUCCESS in 19m 31s (non-voting)\n- nova-tox-functional-py38 https://zuul.opendev.org/t/openstack/build/94c140bc69c84cf59af5d08f76be2253 : SUCCESS in 20m 05s\n- nova-tox-functional-py39 https://zuul.opendev.org/t/openstack/build/b33b5d12bba34d3fa51c64e75066c983 : SUCCESS in 21m 40s (non-voting)\n- nova-grenade-multinode https://zuul.opendev.org/t/openstack/build/ce56950e47bd42fc810622493a00fea1 : SUCCESS in 55m 29s\n- tempest-ipv6-only https://zuul.opendev.org/t/openstack/build/29cdff422a8a4a2c8b8917f6db2c6bb2 : SUCCESS in 51m 15s\n- cyborg-tempest https://zuul.opendev.org/t/openstack/build/2532551384f540fa939014fff6817bf4 : SUCCESS in 35m 05s (non-voting)\n- barbican-tempest-plugin-simple-crypto https://zuul.opendev.org/t/openstack/build/07a37003ff8b42229a616e0301c0a1d4 : FAILURE in 26m 46s (non-voting)","accounts_in_message":[],"_revision_number":2},{"id":"c06ac33af1780b6d3f3a97d4f587f02cb538592d","author":{"_account_id":20733,"name":"Rajesh Tailor","email":"ratailor@redhat.com","username":"rajesht"},"date":"2023-11-24 04:54:10.000000000","message":"Patch Set 2: Code-Review+1","accounts_in_message":[],"_revision_number":2},{"id":"cbab77aa93a126fb6fd71278f14cfe52ceec9cd2","tag":"autogenerated:gerrit:abandon","author":{"_account_id":17685,"name":"Elod Illes","email":"elod.illes@est.tech","username":"elod.illes"},"date":"2024-03-05 19:12:15.000000000","message":"Abandoned\n\nstable/xena branch of openstack/nova is about to be deleted. To be able to do that, all open patches need to be abandoned. Please cherry pick the patch to unmaintained/xena if you want to further work on this patch.","accounts_in_message":[],"_revision_number":2}],"current_revision_number":2,"current_revision":"47f9606e00d78a7ef8fd5115eada1959b3773c75","revisions":{"fb164c3a813c3c8833ce5b127ca0ae1ac6ef9170":{"kind":"REWORK","_number":1,"created":"2023-11-13 19:25:14.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/22/900822/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/22/900822/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/22/900822/1"}}},"commit":{"parents":[{"commit":"a3e1707eaf460373065bd5fcb81460bbb06ccfb7","subject":"Merge \"Have host look for CPU controller of cgroupsv2 location.\" into stable/xena","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/a3e1707eaf460373065bd5fcb81460bbb06ccfb7"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-07-14 02:23:23.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-11-13 19:24:51.000000000","tz":0},"subject":"Decorate only Flavor.get_* methods that execute queries","message":"Decorate only Flavor.get_* methods that execute queries\n\nThe get_* methods on the Flavor object use a common helper method to\nbuild a query object to execute later.\n\nCurrently, the @api_db_api.context_manager.reader decorator which\nmanages the session is located on the helper method instead of on the\nmethods that actually execute the database queries. Part of the context\nmanager\u0027s job is to close the session after the query is executed.\nBecause the decorator is not on the methods that actually execute the\nqueries, those database connections are not being closed and it will\neventually lead to errors like:\n\n  sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50\n  reached, connection timed out, timeout 30.00 (Background on this\n  error at: https://sqlalche.me/e/14/3o7r)\n\nwhich means the connection pool size plus the overflow size has been\nreached and the pool will block for a fixed period of time before\ntiming out and raising this error.\n\nThis removes the @api_db_api.context_manager.reader decorator from the\nquery build helper method and adds it to the Flavor.get_* methods that\nexecute the database queries.\n\nCloses-Bug: #2027755\n\nChange-Id: I4bf83d1642b62ab103716aff6dae7438646e2b31\n(cherry picked from commit 9ae6240c92e212b2fa96d5163f68ef1b30ee03b7)\n(cherry picked from commit 4f4f27be27cb202be6a8fb949ad21021a5cd735d)\n(cherry picked from commit 53e3afe3a6024be6ead35132230dc468dd808850)\n(cherry picked from commit 251ba720a1aed9a2444406238d352e9db1e5bce1)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/fb164c3a813c3c8833ce5b127ca0ae1ac6ef9170"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/fb164c3a813c3c8833ce5b127ca0ae1ac6ef9170"}]},"branch":"refs/heads/stable/xena"},"47f9606e00d78a7ef8fd5115eada1959b3773c75":{"kind":"REWORK","_number":2,"created":"2023-11-13 23:05:31.000000000","uploader":{"_account_id":4690,"name":"melanie witt","display_name":"melwitt","email":"melwittt@gmail.com","username":"melwitt"},"ref":"refs/changes/22/900822/2","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/nova","ref":"refs/changes/22/900822/2","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/2 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/2 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/nova refs/changes/22/900822/2 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/nova refs/changes/22/900822/2"}}},"commit":{"parents":[{"commit":"a3e1707eaf460373065bd5fcb81460bbb06ccfb7","subject":"Merge \"Have host look for CPU controller of cgroupsv2 location.\" into stable/xena","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/a3e1707eaf460373065bd5fcb81460bbb06ccfb7"}]}],"author":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-07-14 02:23:23.000000000","tz":0},"committer":{"name":"melanie witt","email":"melwittt@gmail.com","date":"2023-11-13 23:05:04.000000000","tz":0},"subject":"Decorate only Flavor.get_* methods that execute queries","message":"Decorate only Flavor.get_* methods that execute queries\n\nThe get_* methods on the Flavor object use a common helper method to\nbuild a query object to execute later.\n\nCurrently, the @api_db_api.context_manager.reader decorator which\nmanages the session is located on the helper method instead of on the\nmethods that actually execute the database queries. Part of the context\nmanager\u0027s job is to close the session after the query is executed.\nBecause the decorator is not on the methods that actually execute the\nqueries, those database connections are not being closed and it will\neventually lead to errors like:\n\n  sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50\n  reached, connection timed out, timeout 30.00 (Background on this\n  error at: https://sqlalche.me/e/14/3o7r)\n\nwhich means the connection pool size plus the overflow size has been\nreached and the pool will block for a fixed period of time before\ntiming out and raising this error.\n\nThis removes the @api_db_api.context_manager.reader decorator from the\nquery build helper method and adds it to the Flavor.get_* methods that\nexecute the database queries.\n\nCloses-Bug: #2027755\n\nChange-Id: I4bf83d1642b62ab103716aff6dae7438646e2b31\n(cherry picked from commit 9ae6240c92e212b2fa96d5163f68ef1b30ee03b7)\n(cherry picked from commit 4f4f27be27cb202be6a8fb949ad21021a5cd735d)\n(cherry picked from commit 53e3afe3a6024be6ead35132230dc468dd808850)\n(cherry picked from commit 5f1f22c07a00021cacf97d74031c1033916f9b44)\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/47f9606e00d78a7ef8fd5115eada1959b3773c75"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/nova/commit/47f9606e00d78a7ef8fd5115eada1959b3773c75"}]},"branch":"refs/heads/stable/xena"}},"requirements":[],"submit_records":[],"submit_requirements":[{"name":"Verified","description":"Verified in gate by CI","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Verified\u003dMAX AND -label:Verified\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Verified\u003dMAX","label:Verified\u003dMIN"],"atom_explanations":{}}},{"name":"Code-Review","description":"Code reviewed by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Code-Review\u003dMAX AND -label:Code-Review\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Code-Review\u003dMAX","label:Code-Review\u003dMIN"],"atom_explanations":{}}},{"name":"Review-Priority","description":"Review Priority","status":"NOT_APPLICABLE","is_legacy":false,"applicability_expression_result":{"fulfilled":false,"status":"FAIL"},"submittability_expression_result":{"expression":"is:true","fulfilled":true,"status":"NOT_EVALUATED","passing_atoms":[],"failing_atoms":[],"atom_explanations":{}}},{"name":"Workflow","description":"Approved for gate by core reviewer","status":"UNSATISFIED","is_legacy":false,"submittability_expression_result":{"expression":"label:Workflow\u003dMAX AND -label:Workflow\u003dMIN","fulfilled":false,"status":"FAIL","passing_atoms":[],"failing_atoms":["label:Workflow\u003dMAX","label:Workflow\u003dMIN"],"atom_explanations":{}}}]}