Thanks Martin, that seems to have solved the problem -Charlie
On Mon, May 3, 2010 at 1:57 PM, Martin Marrese <[email protected]> wrote: > On Mon, May 3, 2010 at 15:46, Charlie Meyer <[email protected]> wrote: > > I have deployed a pylons application using mod_wsgi on Apache and > everything > > seems to work ok, but after a few hours (18-24ish), the app crashes on > every > > request with the error "WebApp Error: sqlalchemy.exc.OperationalError: > > (OperationalError) (2006, 'MySQL server has gone away')". It is confusing > > because the MySQL server is definitely still live (I can login to it > using > > the cmd line with no issues), and restarting it does not fix the problem. > > Only restarting apache resolves the issue. The logs don't provide any > > further insight into what is going on, so I am a bit perplexed as to what > > the problem could be. I'm debating switching my production setup to have > > apache proxy to a paste server, but I would rather fix what is broken > than > > change my entire setup. > > > > any thoughts or advice as to how to begin to tackle this problem would be > > appreciated > > I think that you should add the pool_recycle config option in the config > file. > > Something like: > sqlalchemy.pool_recycle = 1800 > > LInk > http://pylonshq.com/docs/en/0.9.7/models/#for-mysql > > -- > Atte. > MartÃn Marrese > -- > JID: kyheo at lugmen.org.ar > MSN: martin at marrese.com.ar > GTalk: marrese at gmail.com > Skype: kyheo_ (with the _) > -- > Ha estado usted razonando fuera del recipiente. > (LL) > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<pylons-discuss%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/pylons-discuss?hl=en. > > -- Charlie Meyer [email protected] http://www.charliemeyer.net Department of Computer Science University of Illinois at Urbana-Champaign -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
