> Dario Lopez-Kästen wrote at 2006-11-17 13:07 +0100:
>> ...
>> yes, we sometimes get deadlocks in the database, net outages and general
>> misbehavior of DCO2.
> But "DCO2" is not responsible for your deadlocks...
Depends what version of DCOracle Dario has, but I've found that
StoredProcedures may cause deadlocks, at last in DCO2 version
I used. I described this in my previous mail in this topic.

That was problem when during one request there was only one call
to a StoredProcedure. During that call database connection
was created (_v_database_connection) and SP raised exception.

Then publisher aborts and rollbacks everything. But first
it destroyed database_connection and then Publisher calls
abort() for SP - but there is no connection at this moment
so no rollback happens.

It is because StoredProcedures in DCOracle2 are a bit strange.
They're resource managers itself, but they're using another
resource managers from db.py.

I've seen this alive in my environment, but this might be
something wrong with my DCOracle2 version. I'll be glad
if somebody may confirm this.

Maciej Wisniowski
Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to