Well, the timeout is part of mysql. I think most people are agreed that the postgresql and mysql python modules should have an "auto-reconnect" feature, which would solve this for all database mappers and all situations. Patches have been submitted for this, but apparently none has been accepted yet. In the meantime, most of us are just using the TG Scheduler to do a "SELECT 1" from the database every minute. It's not the ugliest hack I've ever had to do.
http://trac.turbogears.org/turbogears/ticket/872 http://trac.turbogears.org/turbogears/ticket/781 -ian On Dec 2, 1:49 am, iain duncan <[EMAIL PROTECTED]> wrote: > On Fri, 2006-01-12 at 21:56 -0800, fumanchu wrote: > > iain duncan wrote: > > > I noticed a mention of this by Remi ( of the pie ) but not many other > > > comments on it. Is this something that still happens and what is the > > > crustimony proceedcake for keeping mysql awake? It was happening on my > > > dev box a bit. > > > Got a pointer to that comment? > >http://forum.webfaction.com/viewtopic.php?id=51perhaps?That was the one. > >Just wondered if there were any fixes floating around > aside from the mentioned "ugly hack". > > > > I have also followed the instructions on waking up cherrypy with a cgi > > > script. I'm curious though, what would make CherryPy conk out? Does it > > > happen often? > > > I can't recall any talk about CP hanging, just MySQL.That's good to know. I > > was curious because cron was mentioned in the > book as a way to keep Cherrypy up too. > > Iain --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
