[Ape] Psycopg and idle in transaction
m.bizzarri at icube.it
Fri Nov 12 06:30:06 EST 2004
-----BEGIN PGP SIGNED MESSAGE-----
Shane Hathaway wrote:
| On Sunday 07 November 2004 06:34 am, Marco Bizzarri wrote:
|>Also, from a point debugging/monitoring point of view, I see as very bad
|>the problem of having trasnaction open and don't knowing if they are
|>applications bug or normal APE behaviour...
|>I don't know if this scenario is potentially dangerous, but I wouldn't
|>like to experiment in order to discover it ;)
| There is apparently still some mystery about Zope's transaction
| I've seen behavior like this before. The two likely places to look
for a bug
| apelib/sql/dbapi.py, lines 159-199
| apelib/zodb3/storage.py, lines 196-235
| I've scrutinized these before and didn't uncover anything. Maybe
| of eyes will help.
I've looked at the code. I'm not too much in the ZODB stuff. However,
considering what is done in the lib/Shared/ZRDB/TM.py, I suspect there
is some transaction register missing. I suspect the registration is
missing in the case of a simple 'read'. In that case, there is an access
to the DB but, since there is no registration with the transaction, a
commit or rollback is never called.
Hope this help. I will try to take a deeper look in it.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
More information about the Ape