use the pool_recycle argument as described here: http://www.sqlalchemy.org/trac/wiki/ FAQ#MySQLserverhasgoneawaypsycopg.InterfaceError:connectionalreadyclosed
On Jul 14, 2007, at 8:15 PM, SamDonaldson wrote: > > Hello group, > > I'm having an issue with my site where I get the following error if I > don't use the site for a while, even just a few hours, like 2-3 hours > results in: > > Error - sqlalchemy.exceptions.SQLError: (OperationalError) (2006, > 'MySQL server has gone away') 'SELECT .......' {...} > > Does anybody know what this is about? Is there some setting in mysql > that needs to be set like wait_timeout? Is this a sqlalchemy issue > and is there something that needs to get set while getting a > connection in sqlalchemy? > > Any help would be appreciated. > > Thanks, > > Sam. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---