We are running many NGS workflows at the same time on our local instance 
of Galaxy. They are crashing with the following error

 Error - <class 'sqlalchemy.exc.TimeoutError'>: QueuePool limit of size 5 
overflow 10 reached, connection timed out, timeout 30

In  the universe_wsgi.ini we made the following adjustments:

# If the server logs errors about not having enough database pool 
# you will want to increase these values, or consider running more Galaxy
# processes.
database_engine_option_pool_size = 50   # this used to be 5
database_engine_option_max_overflow = 100 # this used to be 100

Those numbers were pulled out of a hat so I wanted to make sure what we 
were doing was correct. Is there a limit on the values? It doesn't appear 
to be crashing anymore but I still want to make sure.

Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:


Reply via email to