On Sep 20, 2014, at 10:50 AM, Michael Bayer <mike...@zzzcomputing.com> wrote:
> > On Sep 19, 2014, at 8:43 PM, Iain Duncan <iainduncanli...@gmail.com> wrote: > >> So can anyone tell me what exactly happens with NullPool, I'm not clear from >> the docs. Does that mean a fresh connection will be made on a new hit, and >> we'll never get the "gone away", but at the expense of slower connections? > > with the important caveat that your app returns connections to the pool when > its idle. If you check out a connection and just hold onto it somewhere for > hours (which you shouldn't), you can still get that error. I bring this up because, pool_timeout is all you need otherwise. if you are still getting that error with a low pool_timeout, you may want to look into connections being released. > > >> >> Is is terribly slower? >> >> thanks! >> Iain >> >> >> On Fri, Sep 19, 2014 at 2:27 PM, Iain Duncan <iainduncanli...@gmail.com> >> wrote: >> Thanks guys! >> >> Iain >> >> On Fri, Sep 19, 2014 at 12:41 PM, Jonathan Vanasco <jvana...@gmail.com> >> wrote: >> Just to add to jeff's response, I had a similar situation with Postgres >> under a twisted app a while back. >> >> Someone else on the twisted list was using Mysql + Twisted + Sqlalchemy and >> pointed to some pessimistic reconnect code they used in buildbot : >> >> >> http://twistedmatrix.com/pipermail/twisted-python/2014-June/028410.html >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. >> >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.