Simon Taylor wrote:

Hi,

What exactly are the two options database_engine_option_pool_size and database_engine_option_max_overflow in universe_wsgi.ini?

Hi Simon, These are explained in the SQLAlchemy documentation: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/pooling.html

Occasionally I have a problem with galaxy timing out with an exception such as: TimeoutError: QueuePool limit of size 30 overflow 40 reached, connection timed out, timeout 30

Checking the process list I don't see more than a couple of galaxy jobs running so wouldn't expect 30+ connections to the db. The timeout doesn't seem to resolve itself either and the only way to get the site back is to kill and restart the process.

Two things could help here: 1. Enable database_engine_option_strategy = threadlocal 2. Run additional Galaxy processes

Are there plans to handle the exception in any way and maybe reset the db connection, or at least display a user friendly error message?

It's probably possible to recover, although it's rarely a long term problem. Most people simply up the overflow or start an extra server and this fixes it. --nate

Thanks, Simon | | Systems utvikler | Centre for Integrative Genetics (CIGENE) | UNIVERSITETET FOR MILJØ- OG BIOVITENSKAP

___________________________________________________________ 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:

http://lists.bx.psu.edu/