iain duncan wrote: > On Mon, 2007-12-03 at 09:14 +0000, Daniel Haus wrote: >> Hi all! >> >> After trying out every suggested option, I found out that mod_rewrite >> in combination with supervisor2 works best for my needs (productions >> system with lots of vhosts). So far it's working pretty flawlessly, >> except for one issue. >> >> After a couple of hours of inactivity the first request always gets a >> "500 Internal error, [...], Powered by CherryPy 2.2.1". If I then hit >> reload, it's all fine again. I can see nothing in the log files and I >> can't reproduce this error anyhow else than waiting a couple of hours >> and try again. > > Are you on mysql? If so, this is probably the annoying mysql time out > thing. It's a pain, but is actually a mysql cherry-py > semi-incompatibility not a gears bug. Because cherrypy is a long running > process and doesn't make a new connection on every load, it fails on a > request to the mysql server which has gone to sleep thinking the > connection has timed out. ( I _think_ that's the right description, I'm > no expert! ) > > I use a cron job on the server that wgets a page once an hour to hit the > db. That seems to do the trick fine. Apparently you can use the tg > scheduler too, but cron seemed really easy for me and I like the fact > that it is external. I've been meaning to do something smart like have > cron run a script to check on all the sites and text message my phone if > they're down! =) > > Hope that helps! > Iain > > ( PS to doc admins, should we perhaps find away to make this issue more > noticeable in the deployment docs? Still seems to bite a lot of people > and crop up frequently. ) > >
Since I've also seen this question pop up frequently I went ahead and added it to the FAQ (using your answer here as the starting point for the answer there). If any of the Doc people want to check it, feel free to change or remove it if you feel it's not needed or incorrect. Janzert --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
