Help us, please :) We use SessionManager, so default isolation level, as I understand, is ReadCommitted. We call one method asynchronously by ajax request, there are two simultaneous request. And we always get deadlock. (code is simplified and "unrefactored")
We get deadlock on foreach, trying to enumerate photoGalleryBlock.PhotoSet. After uncommenting ### we get another deadlock on #2. Actually, not on #2, but when transaction is completed, Sql Server throws an error "deadlock on update User set [DiskSpaces.PhotoGallery] = 5" Thanks in advance. |
This information is not enough for catch this deadlock. You can use SQL Server Profiler with TSQL_Locks template or implement correct handling of this deadlock with reprocessing library |