On 3 May 2010 20: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.
I had this exact same problem a few years ago. The only solution I could find was to put a try: except: early on in my line of execution (like in BaseController.__call__) and run the query again. >From the extensive scouring of the Internet, it seems to be a known problem. -- Raoul Snyman B.Tech Information Technology (Software Engineering) E-Mail: [email protected] Web: http://www.saturnlaboratories.co.za/ Blog: http://blog.saturnlaboratories.co.za/ Mobile: 082 550 3754 Registered Linux User #333298 (http://counter.li.org) -- 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.
