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

2014-06-10 Thread Glyph
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

2014-06-10 Thread Dustin J. Mitchell
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

2014-06-10 Thread Phil Mayers
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

2014-06-10 Thread Jonathan Vanasco
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