Re: [galaxy-dev] MySQL Operational Error

Roy;

I have a galaxy installation on OSX with a MySQL backend and galaxy running as a daemon. After extended periods of non-use, I get the following error when trying to access my galaxy installation via the web browser:

[...]

*OperationalError: (OperationalError) (2006, 'MySQL server has gone away')

MySQL will close database connections after 8 hours, which results in this error. You want to look in your universe_wsgi.ini file for these lines and uncomment database_engine_option_pool_recycle:

# If using MySQL, see: # http://rapd.wordpress.com/2008/03/02/sqlalchemy-sqlerror-operationalerror-20... # To handle this issue, try the following setting: #database_engine_option_pool_recycle = 7200

Brad