[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#c4


Jonathan Vargas <jvargas at alkaid.cr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW
                 CC|                            |jvargas at alkaid.cr
       InfoProvider|jp.gouigoux at free.fr         |

--- Comment #4 from Jonathan Vargas <jvargas at alkaid.cr> 2011-01-13 18:59:12 UTC ---
Hi, we also have this problem and I will explain why a test case is difficult
to submit and study is necessary.

Our environment:
--
We have an asp.net app running on mono 2.67 on redhat enterprise 5 and apache
2.2.3 on a 64 bit host.

We have tried to connects to Oracle Database through Oracle Instant Client and
the Oracle's 11g Client, for 64 bits, both to an Oracle XE and a Oracle
Database Standar, on separate hosts.


The problem:
--
The apps works fine, but very often in some queries we get the error described
at this line of code in OracleClient's code: 

https://github.com/mono/mono/blob/master/mcs/class/System.Data.OracleClient/System.Data.OracleClient.Oci/OciHandle.cs#L88

"Could not allocate new OCI Handle of type {0}"

The error is triggered sometimes with a handler of type "OciSentenceHandle", or
"OciTransactionHandle", and in the worst case, mod-mono-server just crashes and
we get the following error in apache's log:


Stacktrace:

Native stacktrace:

[Thu Jan 13 11:47:15 2011] [error] (70014)End of file found: read_data failed
[Thu Jan 13 11:47:15 2011] [error] Command stream corrupted, last command was 1


No solution
--
We haven't found any trick or idea of what's going on, as we are not experts in
OCI's code and operation. After we receive this exception, the previously
stablished connection seems to be dirty or something, because we try to
retrieve schema information for a table and it returns invalid info.


Expectation
--
Determine what are the cases when this call returns unexpected values: 

OCIHandleAlloc (this,
  out newHandle,
  type,
  0,
  IntPtr.Zero
);

And then search for a solution. Also, it the problem is definitively at
oracle's side, or if it should be managed by mono's OracleClient
implementation.

If you need more information please ask us for it. Thanks in advance.

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