EF4 and DevARt 8.4.389 : temporary Locked in Devart.Common.DbConnectionPool.GetObject()

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Dypsok
Posts: 5
Joined: Tue 13 Feb 2018 18:06

EF4 and DevARt 8.4.389 : temporary Locked in Devart.Common.DbConnectionPool.GetObject()

Post by Dypsok » Fri 27 Apr 2018 06:25

Hello, when load testing my wcf application under load burst I make a lot of queries to db as select or insert/update.
I see I have also a lot of garbage collection and when a gc collection is launched during a query all the threads are blocked on a lock in Devart.Common.DbConnectionPool.GetObject() as they were in the middle on a opening connection phase...
I was wondering myself if there is any event launched before and after Devart.Common.DbConnectionPool.GetObject() is called so I could instruct to not let gc collection happen during this phase ?

I have already check this post : https://forums.devart.com/viewtopic.ph ... t=deadlock

I know I could also cancel the pooling but I am afraid that there would be a bad impact on performance...

Thank you for any help !!

Dypsok
Posts: 5
Joined: Tue 13 Feb 2018 18:06

Re: EF4 and DevARt 8.4.389 : temporary Locked in Devart.Common.DbConnectionPool.GetObject()

Post by Dypsok » Fri 27 Apr 2018 13:26

Is there anymway to prevent locking in Devart.Common.DbConnectionPool.GetObject() because it block my whole server application as the threads are waiting ?

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

Re: EF4 and DevARt 8.4.389 : temporary Locked in Devart.Common.DbConnectionPool.GetObject()

Post by Shalex » Fri 27 Apr 2018 16:34

Please upgrade to v9.5.502. This should help.

If you do not have an access to the licensed v9.5.502, test a trial available at https://www.devart.com/dotconnect/oracle/download.html to make sure that the issue is solved.

Post Reply