Comment 0 for bug 2088

Revision history for this message
Stuart Bishop (stub) wrote :

Steve Alexander wrote:
> 2005-01-13 Federico Di Gregorio <email address hidden>
>
> * ZPsycopgDA/db.py (DB.query): applied patch from Jonathan
> Stoneman to automatically try to reconnect *once* on
> OperationalError. This fix the problem with Zope loosing the
> connection to the database when PostgreSQL is restarted.
>
> http://initd.org/pub/software/psycopg/ChangeLog
>
> I think this is the version in breezy.
>
> Also, Mark reported some IntegrityErrors being changed to
> ProgrammingErrors in the psycopg in breezy.

This is the Zope2 DA, not the Zope3 one btw.

We should do something similar upstream in the Z3 DA, as well as raising the
relevant conflict exceptions when a deadlock or unserializable transaction
is encountered to make Z3 retry the transaction.