On Jun 2, 2008, at 5:11 AM, arashf wrote:
> > that sounds perfect. unfortunately, I tried this in production and am > getting sporadic exceptions that looks like this (i've never gotten > these before): > > WebApp Error: <class 'sqlalchemy.exceptions.OperationalError'>: > (OperationalError) (2013, 'Lost connection to MySQL server during > query') > > WebApp Error: <class 'sqlalchemy.exceptions.ProgrammingError'>: > (ProgrammingError) (2014, "Commands out of sync; you can't run this > command now") > > WebApp Error: <class 'sqlalchemy.exceptions.InvalidRequestError'>: > This Connection is closed > > any ideas? my initial guess is that you're sharing a connection between threads. what specifically is "this" ? the recipe in the Pylons tutorial ? or the threadlocal pool ? I really think you should go with what the pylons tutorial has to say. SingletonThreadPool is not widely used with MySQL so I'm not sure if there are caveats surrounding its usage in that regard (though it has been used successfully). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" 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/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
