Community Forums

1. 

   handan123
   Member
   Posted 10 months ago

   We are getting the following error during high traffic times. Any ideas?

   sqlalchemy.exc.TimeoutError: QueuePool limit of size 5 overflow 10 reached

   Thanks
2. 

   Nathan Wright
   Maintainer
   Posted 10 months ago

   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 = 20
3. 

   wesley.miao
   Member
   Posted 10 months ago

   We 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?
4. 

   handan123
   Member
   Posted 10 months ago

   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

RSS feed for this topic

Reply

You must log in to post.