sql server timeout

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

sql server timeout

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/
Reply | Threaded
Open this post in threaded view
|

Re: sql server timeout

Dannon Baker-2
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 <[hidden email]> 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/