On Apr 9, 2012, at 3:11 AM, Federico De Masi wrote:
Derar all,
I have recently moved from galaxy-central to galaxy-dist and all seems to work fine except that everytime I start a new session (ie: I go to my galaxy with my browser), I get the error below. I just need to reload the page and all is fine again. I would mention that while the whole 'dist' is original, the ./database/ directory is a mere copy (and updated) of the one I had in galaxy-central. Needless to say that the MySQL engine is never down :)
Any help is most than welcome
Thanks a million!
Here's the error I get.
… OperationalError: (OperationalError) (2006, 'MySQL server has gone away') u'SELECT galaxy_session.id AS galaxy_session_id, galaxy_session.create_time AS galaxy_session_create_time, galaxy_session.update_time AS galaxy_session_update_time, galaxy_session.user_id AS galaxy_session_user_id, galaxy_session.remote_host AS galaxy_session_remote_host, galaxy_session.remote_addr AS galaxy_session_remote_addr, galaxy_session.referer AS galaxy_session_referer, galaxy_session.current_history_id AS galaxy_session_current_history_id, galaxy_session.session_key AS galaxy_session_session_key, galaxy_session.is_valid AS galaxy_session_is_valid, galaxy_session.prev_session_id AS galaxy_session_prev_session_id, galaxy_session.disk_usage AS galaxy_session_disk_usage \nFROM galaxy_session \nWHERE galaxy_session.session_key = %s AND galaxy_session.is_valid = %s \n LIMIT 0, 1' ['ac609feb8dfe0f5669378398dde80af3', 1]
Hi Federico, Try setting the following config option: # If using MySQL and the server logs the error "MySQL server has gone away", # you will want to set this to some positive value (7200 should work). #database_engine_option_pool_recycle = -1 --nate
-- Federico De Masi, PhD, Assistant Professor The Technical University of Denmark - DTU Center for Biological Sequence Analysis - CBS Kemitorvet 208/002 DK-2800 KGS. LYNGBY, DENMARK Telephone: (+45) 45 25 24 21 Fax: (+45) 45 93 15 85 http://rg.cbs.dtu.dk ___________________________________________________________ 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: