Not to ask to many questions here but isn't there a standard value for this? I mean, who would want their db connections to close unexpectedly like this, especially on a live site? Is there a value you recommend because this is just happening way too frequently.
Thanks, Sam. On Jul 14, 8:14 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---