Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

On Jun 12, 2014, at 11:35 AM, Jonathan Vanasco wrote: > this looks like the package I want in the future -- i'm just uneasy about > what might/might not be supported, on top of the migration work. This is understandable; alchimia is definitely a bit raw. I'd just encourage you to actuall

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

On Jun 12, 2014, at 1:13 AM, Glyph wrote: > alchimia is not a re-implementation or a separate sqlalchemy package. It > *is* sqlalchemy; it's just a slight extension for integration sqlalchemy > operations with the Twisted main loop. Yeah, I get that. I'm really excited for it. I use the dec

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

On Jun 11, 2014, at 10:21 AM, Jonathan Vanasco wrote: > > On Jun 11, 2014, at 1:23 AM, Glyph wrote: > >> You might want to just try using SQLAlchemy via >> if you don't want to do your own >> thread-pool management as buildbot appears to be. > > thank

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

On Jun 11, 2014, at 1:23 AM, Glyph wrote: > You might want to just try using SQLAlchemy via > if you don't want to do your own > thread-pool management as buildbot appears to be. thanks. i think we might need to go the buildbot route. we mainly use Sql

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

You might want to just try using SQLAlchemy via if you don't want to do your own thread-pool management as buildbot appears to be. -glyph On Jun 10, 2014, at 6:02 PM, Dustin J. Mitchell wrote: > SQLAlchemy makes this kind of pessimistic reconnection pre

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

SQLAlchemy makes this kind of pessimistic reconnection pretty easy; we do it for MySQL in https://github.com/buildbot/buildbot/blob/master/master/buildbot/db/enginestrategy.py I'm not sure why we don't do it for Postgres, but we've never heard a complaint from a postgres user, so perhaps other l

Re: [Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

On 10/06/2014 19:24, Jonathan Vanasco wrote: I had to restart postgresql , and that triggered some endless errors in my logs. i don't have anything that can handle a suddenly dropped / resumed connection. does anyone have a recommendation for trying to reconnect or handle this in general fro

[Twisted-Python] adbapi.ConnectionPool - reconnecting to postgresql

I had to restart postgresql , and that triggered some endless errors in my logs. i don't have anything that can handle a suddenly dropped / resumed connection. does anyone have a recommendation for trying to reconnect or handle this in general from what I can tell from my logs... When I catch