On Sat, 2007-03-02 at 20:53 -0500, Mike Bernson wrote: > Mysql has a timeout idle connection. You might be running into this. I > think it defaults to 8 hours It sounds like you are running into the > idle timeout. > > dischdennis wrote: > > Hi I am using sqlalchemy with zope and when I have the server running > > a while (> 6 hours) without interaction, I cannot access any site, > > (OperationalError) (2013, 'Lost connection to MySQL server during > > query'), > > and have to restart the server.
yeah, this is a total freaking pain with MySQL. One of recommended deployment hacks is to put a cron job on your server to make a pointless hit on the db server in question once an hour or whatever. Seems ridiculous but at least it works. I suppose in the case of a web app the cron job could even be on any old server using wget. Iain --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---