[Modeling-users] Warning: possible problem with Zope, maybe MT-related

[Sebastien B. <sbi...@us...>]

        Hi all,

  Just a quick note to warn you about the fact that I currently have a very
  annoying bug revealing itself on a zope-based application using the
  modeling.

  It is still not clear where the bug is, but it has been reported that it was
  also observed with zope and ZPsycopgDA alone.

It might be a MT-issue, or just a Zope-issue (this is just my guess at this
point).

  Description of the problem: at some point, the psycopg adaptor stops adding
  BEGIN and END or ABORT at the begin/end of the txn.
  From that point, none of the sql statements sent to the pg server is
  committed anymore, hence they are lost.

It do not have any other solution than monitoring the application and
restarting it when it happens --ok, this is not a solution, rather an ugly
workaround.

My initial post is at:
http://lists.initd.org/pipermail/psycopg/2003-March/001885.html

  I'll post here if and when a solution will be found.

-- Sebastien.