13 Apr
2010
13 Apr
'10
1:08 p.m.
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