Bug 2222998 - [OSP17.1] "sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50 reached, connection timed out, timeout 30.00" error raised after repeated calls of Flavor.get_* methods
Summary: [OSP17.1] "sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 50...
Keywords:
Status: ON_DEV
Alias: None
Product: Red Hat OpenStack
Classification: Red Hat
Component: openstack-nova
Version: 16.2 (Train)
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: z2
: 17.1
Assignee: melanie witt
QA Contact: OSP DFG:Compute
URL:
Whiteboard:
Depends On: 2232689
Blocks:
TreeView+ depends on / blocked
 
Reported: 2023-07-14 20:05 UTC by melanie witt
Modified: 2023-08-17 22:35 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
: 2232689 (view as bug list)
Environment:
Last Closed:
Target Upstream Version:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Launchpad 2027755 0 None None None 2023-07-14 20:05:09 UTC
OpenStack gerrit 888513 0 None NEW Decorate only Flavor.get_* methods that execute queries 2023-07-14 20:05:09 UTC
Red Hat Issue Tracker OSP-26633 0 None None None 2023-07-14 20:05:43 UTC

Description melanie witt 2023-07-14 20:05:09 UTC 
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
Note You need to log in before you can comment on or make changes to this bug.