[Mono-bugs] [Bug 421491] "Could not allocate new OCI Handle of type Statement" message when accessing Oracle

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=421491

https://bugzilla.novell.com/show_bug.cgi?id=421491#c6


Chris Brown <chrisbrown76 at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |chrisbrown76 at hotmail.com

--- Comment #6 from Chris Brown <chrisbrown76 at hotmail.com> 2011-08-02 01:21:53 UTC ---
I am running a web application on openSUSE 11.1 with Mono 2.11 and I am also
experiencing this error intermittently ("Could not allocate new OCI Handle of
type Statement"). I'm using Oracle XE 10g.

As previously stated it is very hard to produce a test case and the error does
not seem to be tied to any particular part of my code. For example I have seen
this issue appear during the databinding of a web control via an
ObjectDataSource and TableAdapter. I've also experienced it calling a method on
a TableAdapter directly in my session provider. When the error occurs
restarting Apache is the only option.

I have a Windows Service also running on the same system under Mono accessing
the same database and the error has never shown in this. I have read that there
may be threading issues accessing Oracle with Mono and I'm not sure if this
could be related (or perhaps multiple connections)?

Did anyone make any progress narrowing down the cause of this problem or find
any sort of workaround? Otherwise is there anyway I can capture some extra
logging information for when the error next occurs and possibly ultimately put
together a test case?

Thanks

-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.