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 -~----------~----~----~----~------~----~------~--~---
