Page 1 of 1

Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Fri 08 Aug 2014 08:29
by dumian
Hi Team,

We have an Enterprise application that use EF 6.1.0 and Devart 8.3.125.0, and we use DB First with Complied Views, we observed that in Production under Memory pressure, when application reach 80% -90% from Machine Memory and GC Begins to clean-up, application pool Process gets a Crash with following exception in Devart.Oracle.Data .

Have you meet In your Performance tests something similar ?

Code: Select all

App_Code.ns7gtqmh |  |  | Exception handled on main host thread =======================================================(inner most exception)===
(1) System.InvalidOperationException
================================================================================
Method        :  d
Type          :  Devart.Common.DbConnectionInternal
Assembly      :  Devart.Data.Oracle, Version=8.3.125.0, Culture=neutral, PublicKeyToken=09af7300eec23701
Assembly Path :  C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\mes\7cbb005b\ffdcc1c5\assembly\dl3\2e3163d9\f6a09db1_9c9acf01\Devart.Data.Oracle.dll
Source        :  Devart.Data.Oracle
Thread        :  6 ''
Helplink      :  

Message:
"Unpooled object has an owner."

Stack Trace:
   at Devart.Common.DbConnectionInternal.d(Object A_0)
   at Devart.Common.DbConnectionPoolGroup.a(DbConnectionPool A_0)
   at Devart.Common.DbConnectionPoolGroup.a(Object A_0)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
================================================================================
Regards,
Johannes

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Thu 14 Aug 2014 11:43
by Shalex
This is a known problem. We are working on it. We will notify you about the results as soon as any are available.

The apperance of the issue doesn't depend on a big amount of memory consumed. The factors are (a) usage of multithreading and (b) loading system by simultaneous establishing new connections and memory deallocation.

As a workaround for the OCI mode (connection via Oracle client), please turn off the Devart pooling and use the OCI pooling instead. For this, include the "Pooling=false;Oci Session Pooling=true;" entry in your connection string. If this doesn't help (or if you are using the Direct mode), turn off both Devart and OCI poolings: "Pooling=false;Oci Session Pooling=false;".

For more information about the connection string parameters, refer to http://www.devart.com/dotconnect/oracle ... tring.html.

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Thu 14 Aug 2014 20:05
by dumian
is that in any of 8.4.xxx versions improved ?

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Fri 15 Aug 2014 08:58
by Shalex
There are no improvements concerning this issue in 8.4.xxx versions.
We will notify you about the results of our investigation as soon as any are available.

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Wed 26 Nov 2014 09:33
by dumian
Hi,

Are any News regarding that issue ?

Regards,
Johannes

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Thu 27 Nov 2014 14:11
by Shalex
Hello Johannes,

We have sent a test build to your email address. Please check it in your environment. Is the issue you have encountered fixed?

--
Best regards,
Devart Support

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Thu 27 Nov 2014 14:47
by dumian
Hi,

i didn't get anything till now.

regards,
Johannes

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Fri 28 Nov 2014 07:09
by Shalex
Please submit your request via our contact form (include the link to this thread).

Re: Web Application Crash on Memory presure with Devart.Oracle.Data exception

Posted: Thu 15 Jan 2015 16:35
by Shalex
The bug with throwing System.InvalidOperationException by Devart connection pooling in multithreaded applications under high loads is fixed in the new (8.4.333) build of dotConnect for Oracle.