Hi James, The database_engine_option_pool_recycle worked :) although I use a different value, because I tweaked my MySQL my.conf. For the Galaxy devs: could one of you please add this option to the documentation on the Wiki or to universe_wsgi.ini.sample? Thanks! Pi On 17•Aug•2009, at 12:24 PM, James Casbon wrote:
H2009/7/30 Pieter Neerincx <pieter.neerincx@gmail.com>:
Hi,
Every morning when I come back to my lab and login to Galaxy I get the error below. I think it's the 'MySQL server has gone away' part that is the real cruel-pitand simply clicking refresh is enough to 'fix' the problem... This is not specifically a Galaxy problem. It's
Hi Pieter,
See: http://rapd.wordpress.com/2008/03/02/sqlalchemy-sqlerror-operationalerror-20...
Try setting database_engine_option_pool_recycle=7200 in universe_wsgi.ini
Cheers, James
------------------------------------------------------------- Biomolecular Mass Spectrometry and Proteomics Utrecht University Visiting address: H.R. Kruyt building room O607 Padualaan 8 3584 CH Utrecht The Netherlands Mail address: P.O. box 80.082 3508 TB Utrecht The Netherlands phone: +31 (0)6-143 66 783 email: pieter.neerincx@gmail.com skype: pieter.online ------------------------------------------------------------