Re: [cx-oracle-users] Garbage collector causes deadlock in multithreaded cx_Oracle server

[Henning v. B. <hen...@ar...>]

It would certainly help if you posted code demonstrating the problem.

Just a wild guess:

You should always explicitly close() the cursor (not the connection) 
like this:

curs = conn.cursor()
try:
     cursor.execute(...)
finally:
     cursor.close()

(the with statement can be used in newer Python versions).

Maybe that helps already.

The GC might try to close the cursors in a somewhat "wrong" order, which 
could cause the deadlock.
On Windows, you might also try to use the ProcessExplorer to see the C 
function where the thread hangs.
Is it in an OCI call?

HTH
Henning