使用 SqlWorkflowPersistenceService 时，在 PersistenceDBAccessor.RetrieveNonblockingInstanceStateIds 中获取 SqlException 死锁

Question

我正在使用 WF 3.5，在启动几个 WorkflowRuntime 的过程中，有时会出现以下异常：

System.Data.SqlClient.SqlException: Transaction (Process ID 108) 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)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.HasMoreRows()
   at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
   at System.Workflow.Runtime.Hosting.PersistenceDBAccessor.RetrieveNonblockingInstanceStateIds(Guid ownerId, DateTime ownedUntil)
   at System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService.RecoverRunningWorkflowInstances()
   at System.Workflow.Runtime.Hosting.SqlWorkflowPersistenceService.OnStarted()
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at System.Workflow.Runtime.WorkflowRuntime.StartRuntime()

我认为运行多个 WorkflowRuntime 是可以的。我正在旋转多个服务器，因为我将工作负载分配到不同的服务器，但所有服务器都访问同一个数据库。有什么想法吗？

Answer 1

找到答案了！

我应该使用启用锁定的 SqlWorkflowPersistenceService 构造函数：

SqlWorkflowPersistenceService 构造函数（字符串、布尔值、TimeSpan、TimeSpan）
http://msdn.microsoft.com/en -us/library/ms608171(v=VS.90).aspx

有关详细信息：https://connect.microsoft.com/wf/feedback/details/541240/sqlexception-deadlock-in-persistencedbaccessor-retrievenonblockinginstancestateids