[Ape] Psycopg and idle in transaction

[Marco Bizzarri]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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
machinery.
| I've seen behavior like this before.  The two likely places to look
for a bug
| are:
|
| 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
another pair
| of eyes will help.
|
| Shane

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.

Regards
Marco
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBlJ69XhfyAQQVoaIRAtZsAJ0fSlHWnyc2fYm6/2AJovmzWowFuQCgshVx
YKtjoek+x5ll4QlsEcJ8Lzw=
=Kdsx
-----END PGP SIGNATURE-----