Description of problem: This is a copy of upstream bug: https://bugs.launchpad.net/nova/+bug/2027755 where repeated calls involving "get" of 'flavors' table records eventually raise the error: sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50 reached, connection timed out, timeout 30.00 (Background on this error at: https://sqlalche.me/e/14/3o7r) Version-Release number of selected component (if applicable): 16.x How reproducible: Always Steps to Reproduce: 1. Run 'watch -n 1 openstack flavor list --all --long' and eventually the errors will appear in the nova-api log Actual results: Eventual error of "sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50 reached, connection timed out, timeout 30.00 (Background on this error at: https://sqlalche.me/e/14/3o7r)" in nova-api log and 500 status code returned to user Expected results: No errors
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (RHOSP 17.1.4 bug fix and enhancement advisory), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2024:9974