Brad, Thanks, that took care if it. Rgds, Roy W. On Apr 13, 2010, at 8:08 AM, Brad Chapman <chapmanb@50mail.com> wrote:
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