[Twisted-Python] reconnecting ConnectionPools

Itamar Shtull-Trauring itamar at itamarst.org
Sun Jul 25 15:41:59 EDT 2004

On Sun, 2004-07-25 at 13:28, Christopher Armstrong wrote:

> I've been trying to think of a way to at least work around this on a 
> per-app basis -- mine is using psycopg. It just raises either a 
> ProgrammingError or an OperationalError on cursor.execute. The brightest 
> idea we've come up with is to reconnect after N (~ 3) consecutive errors.
> Any other ideas?

Upon errors, test a command that will always work ("SELECT 1"), if that
fails reconnect.

More information about the Twisted-Python mailing list