DevForce Community Forum : Deadlock detection http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Deadlock detection Wed, 13 May 2026 09:56:40 -700 Fri, 27 Jan 2012 14:54:00 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3235 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Deadlock detection : Hi Silvio, We have... http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12563#12563 Author: ritaf
Subject: 3235
Posted: 27-Jan-2012 at 2:54pm

HiSilvio,

 

 

Wehave done some optimization to prevent deadlocks.  But in case they still occur I want to add anability for the application to retry the save. I can retry calling SaveChangesAsync from the client but I need to havea way to determine that the error was in fact a deadlock error.  Currently, on a client I can only get exceptionmessage, stack and etc. (RemoteException properties of EntityManagerException)and generic FailureType.  I need to find somethingin the EntityManagerSaveException that will tell me the error number.

 

In case of a deadlock, EntityServerSaveInterceptor.OnErrorinner exception is System.Data.SqlClient.SqlException, error number 1205.

 

Thank you,

Rita

]]> Fri, 27 Jan 2012 14:54:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12563#12563 Deadlock detection : Hi Rita,In what circunstances... http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12562#12562 Author: sbelini
Subject: 3235
Posted: 27-Jan-2012 at 1:55pm

Hi Rita,
 
In what circunstances do you anticipate these deadlocks? (on concurrency conflicts?)
Have you considered using optimistic concurrency? (more detais in the DevForce Resource Center)
 
Unfortunatelly, you won't be able to retry the save on the server once you get an error.
 
What particular type of inner exception are you getting on EntityServerSaveInterceptor.OnError? I tried to simulate a deadlock and ended up getting timeout errors due to non response from SQL Server.
 
 
Silvio.
 
 
 
 
]]> Fri, 27 Jan 2012 13:55:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12562#12562 Deadlock detection : Hi,I am a novice DevForce developer,... http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12549#12549 Author: ritaf
Subject: 3235
Posted: 26-Jan-2012 at 10:00am

Hi,

I am a novice DevForce developer, so my question is probably very trivial.

Is there a way to detect deadlock errors (or to distinguish any other data provider errors) when EntityManager.SaveChanges/SaveChangesAsync fails? I want to retry saving changes if they fail due to the database deadlock.  When deadlock occurs I can see a particular type of exception on a server side in EntityServerSaveInspector.OnError as an InnerException but I am not sure if I can retry at this point.  On a client side, error is returned as a generic EntityManagerServerException and InnerException is not set.  I can see RemoteExceptionDetails but I cannot see the original error number, so I cannot make a determination that it’s a deadlock error.

Thank you,

Rita

]]> Thu, 26 Jan 2012 10:00:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3235&PID=12549#12549