Re: [galaxy-dev] sql server timeout

2014-08-08 Thread Dannon Baker
Hi Don,

Haven't seen this before myself, but I did a little digging here:
http://docs.sqlalchemy.org/en/rel_0_8/faq.html#mysql-server-has-gone-away

So, to differentiate between those two issues, does this happen very
frequently or only after a long idle?

-Dannon


On Wed, Aug 6, 2014 at 3:15 PM, Shrum, Donald C dcsh...@admin.fsu.edu
wrote:

 On occasion I'm getting and 'Internal Server error' on login with my
 production galaxy server.
 If I refresh the page I'm able to login just fine.

 This instance of galaxy has an apache frontend and a mysql server on the
 back end.   If I look at my log files I see:

 OperationalError: (OperationalError) (2006, 'MySQL server has gone away')
 'SELECT galaxy_session.id AS galaxy_session_id.

 It looks like perhaps galaxy is trying to use a stale session or something
 like that.  Has anyone else seen this problem and is there an easy solution
 aside from having users refresh the page?

 Thanks,
 Don
 FSU Research Computing Center


 ___
 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:
   http://lists.bx.psu.edu/

 To search Galaxy mailing lists use the unified search at:
   http://galaxyproject.org/search/mailinglists/

___
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:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/

[galaxy-dev] sql server timeout

2014-08-06 Thread Shrum, Donald C
On occasion I'm getting and 'Internal Server error' on login with my production 
galaxy server.
If I refresh the page I'm able to login just fine.

This instance of galaxy has an apache frontend and a mysql server on the back 
end.   If I look at my log files I see:

OperationalError: (OperationalError) (2006, 'MySQL server has gone away') 
'SELECT galaxy_session.id AS galaxy_session_id.

It looks like perhaps galaxy is trying to use a stale session or something like 
that.  Has anyone else seen this problem and is there an easy solution aside 
from having users refresh the page?

Thanks,
Don
FSU Research Computing Center


___
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:
  http://lists.bx.psu.edu/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/