also, I can't think/find anywhere where connections may be getting shared between threads.
On Jun 2, 5:34 pm, arashf <[EMAIL PROTECTED]> wrote: > I tried the example in the pylons docs. I'll post my base.py, model.py > code here:http://pastebin.com/m1b47b4aa > > thanks again for your help. also, is there a lower latency way I can > catch a hold of you today? irc perhaps? :) > > On Jun 2, 7:49 am, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > 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 -~----------~----~----~----~------~----~------~--~---
