We are getting the following error during high traffic times. Any ideas?
sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached
Thanks
Search Forums
4 posts Started 10 months ago by handan123 Latest reply from handan123
We are getting the following error during high traffic times. Any ideas?
sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached
Thanks
I'd recommend that you reduce your number of python threads per process to a maximum of 15 and increase the number of processes instead. Python threads don't perform that great, so you'll probably be able to serve more requests per second this way.
Alternately, to simply fix this error, SQLAlchemy's connection pool can be configured to be larger by editing your deployment.ini file. You can add this line below the line that starts with "sqlalchemy.url = ...":
sqlalchemy.pool_size = 20We had the same issue recently. The default setting of QueuePool limit of size 5 with maximum 10 overflow is the root cause. Could we just simply set the max_overflow to -1 to solve this problem?
It's evolved.
QueuePool limit of size 20 overflow 10 reached
Same error with different numbers.
Any idea how to change the overflow limit?
Thanks
You must log in to post.