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]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
