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 thanks -Charlie -- Charlie Meyer 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.
