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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
dumian
Posts: 13
Joined: Sat 09 Jun 2012 19:10
Contact:

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

Post by dumian » Fri 08 Aug 2014 08:29

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 14 Aug 2014 11:43

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.

dumian
Posts: 13
Joined: Sat 09 Jun 2012 19:10
Contact:

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

Post by dumian » Thu 14 Aug 2014 20:05

is that in any of 8.4.xxx versions improved ?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 15 Aug 2014 08:58

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.

dumian
Posts: 13
Joined: Sat 09 Jun 2012 19:10
Contact:

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

Post by dumian » Wed 26 Nov 2014 09:33

Hi,

Are any News regarding that issue ?

Regards,
Johannes

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 27 Nov 2014 14:11

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

dumian
Posts: 13
Joined: Sat 09 Jun 2012 19:10
Contact:

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

Post by dumian » Thu 27 Nov 2014 14:47

Hi,

i didn't get anything till now.

regards,
Johannes

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Fri 28 Nov 2014 07:09

Please submit your request via our contact form (include the link to this thread).

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

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

Post by Shalex » Thu 15 Jan 2015 16:35

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.

Post Reply