Re: [cx-oracle-users] Crash of OCIStmtRelease during cursor.close()

[<Gui...@su...>]

Hi all,
The problem I had with OCIStmtRelease a month ago has finally been solved. Even though it turned out not to be cxOracle's fault at all, I thought I'd give the solution here in case anyone ever comes across this issue.

The problem was that under cxOracle 4.4 and Oracle 11, our program used to crash randomly during calls to the OCI.
At first I thought it was a problem with cxOracle, but it turns out it was due to a new diagnostics tool called ADR that Oracle introduced in their 11g version.
The solution is to either set the environment variable PTHREAD_DEFAULT_STACK_SIZE to a big enough value, or to disable ADR altogether. I chose to disable it since I don't know what 'big enough' means and I can't take the risk of having this problem occur ever again. 

So thanks a lot for your help anyway, especially to Anthony and Amaury. 




-----Message d'origine-----
De : Gui...@su... [mailto:Gui...@su...] 
Envoyé : vendredi 5 novembre 2010 12:13
À : cx-...@li...
Objet : Re: [cx-oracle-users] Crash of OCIStmtRelease during cursor.close()


> There is an internal method Cursor_FreeHandle() which is called.
> Cursor_Free() does not directly call Cursor_Close() so they are not
> the same thing.

Right, but Cursor_FreeHandle is where my program crashes, during the
execution of OCIStmtRelease, so this will still get called and my
program will probably still crash for the same reason that it does now,
won't it?

But I can't just talk the talk and not walk the walk. As I said, I'll do
the tests today so we'll know for sure. 

By the way, I know it's a long shot but I found this Oracle trace when
the program crashes. If it means anything to anyone. 

_kpedbg_dmp_stack()+231
<-_kpeDbgCrash()+51
<-__VInfreq__kpustmtrelease()+341
<-_OCIStmtRelease()+87
<-_OCIStmtRelease()+49
Before that it's Cursor_FreeHandle() and Cursor_Close() that are called
and lead to OCIStmtRelease.


Thanks,
Guillaume



------------------------------------------------------------------------------
The Next 800 Companies to Lead America's Growth: New Video Whitepaper
David G. Thomson, author of the best-selling book "Blueprint to a 
Billion" shares his insights and actions to help propel your 
business during the next growth cycle. Listen Now!
http://p.sf.net/sfu/SAP-dev2dev
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users