Question

Hi,

From time to time we receive error reports telling us 'Deadlock' happened. I have no clue where to start looking for this since the stacktrace is pretty inconclusive. The only lead is the XTensive.Orm.Providers.NextRow() call. Below is the stack trace.

Regards Paul

16-4-2014 15:27 Error   Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.    System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at Xtensive.Orm.Providers.Command.NextRow()
ClientConnectionId:4c6eab6b-abcc-4a8d-ba05-d99c79fdad1c

Accepted Answer

0	We added the Reprocessing Framework of X-Tensive to solve this. Since that was implemented we sparsely get deadlocks answered Sep 17 '14 at 01:56 Paul Sinnema 261●88●88●96

Answer 2

0

Hello Paul,

for diagnostics you could set SessionConfiguration.ReaderPreloading to ReaderPreloadingPolicy.Always. This setting will force DataObjects.Net to fetch all data from the DbDataReader before it is returned to user. This would allow you to trace exception to a specific query.

answered Apr 24 '14 at 06:13

Denis Krjuchkov
1793●2●5

Subscription:

Related questions