nCODE:N15370710\r\nError:13_1205_51_-2146232060\r\nSQL:\r\n
UPDATE QE \ r \ n
SET QE.LockGuid = '0c445863f887467faafb9744420b5508',
QE.QueueState = 1,
QE.ExecTime = getdate( ) \ r \ n
FROM
RB_Ebay_Listing_Queue_V2 QE \ r \ n
WHERE
QE.QueueID IN (
\ r \ n SELECT TOP
( 24 ) Q.QueueID\ r \ n
FROM
RB_Ebay_Listing_Queue_V2 Q WITH ( NOLOCK ) \ r \ n \ t
INNER JOIN RB_Ebay_Listing_Basic_V2 B WITH ( NOLOCK ) \ r \ n \ t ON B.CustomerID = Q.CustomerID\ r \ n \ t \ t
AND B.ListingBasicID = Q.ListingBasicID\ r \ n \ t \ t
AND B.OrderSourceID = Q.OrderSourceID\ r \ n \ t \ t
AND B.SiteCode = Q.SiteCode\ r \ n \ t
LEFT JOIN RB_Ebay_Listing_Product_V2 P WITH ( NOLOCK ) \ r \ n \ t ON Q.ListingBasicID = P.ListingBasicID\ r \ n \ t \ t
AND Q.CustomerID = P.CustomerID\ r \ n \ t \ t
AND P.OrderSourceID = Q.OrderSourceID\ r \ n \ t \ t
AND Q.SiteCode = P.SiteCode\ r \ n \ t \ t
AND P.IsVariation = 0 \ r \ n \ t
LEFT JOIN RB_OrderSource OS WITH ( NOLOCK ) \ r \ n \ t ON OS.ID = Q.OrderSourceID\ r \ n \ t \ t
AND OS.CustomerID = Q.CustomerID\ r \ n
WHERE
Q.QueueState = 0 \ r \ n \ t
AND Q.QueueType = 3 \ r \ n \ t
ORDER BY
Q.AddTime\ r \ n \ t
) \ r \ nPARAMS :\ r \ nMESSAGE : TRANSACTION ( Process ID 732 ) was deadlocked ON lock resources WITH another process
AND has been chosen AS the deadlock victim.Rerun the TRANSACTION.\ r \ nTRACE : 在 System.Data.SqlClient.SqlConnection.OnError ( SqlException EXCEPTION, Boolean breakConnection, ACTION ` 1 wrapCloseInAction ) \ r \ n 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning ( TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose ) \ r \ n 在 System.Data.SqlClient.TdsParser.TryRun ( RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean & dataReady ) \ r \ n 在 System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds ( String methodName, Boolean async, Int32 timeout, Boolean asyncWrite ) \ r \ n 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery ( TaskCompletionSource ` 1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean & usedCache, Boolean asyncWrite, Boolean inRetry ) \ r \ n 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery ( ) \ r \ n 在 RB.DAL.DBOperator.ExecuteSql ( String SQLString, SqlCommand cmd, Int32 Times, SqlParameter [] cmdParms ) 在 RB.DAL.DBOperator.toCommonTipException ( SqlException ex, String SQL, SqlParameter [] cmdParms ) \ r \ n 在 RB.DAL.DBOperator.ExecuteSql ( String SQLString, SqlCommand cmd, Int32 Times, SqlParameter [] cmdParms ) \ r \ n 在 RB.DALExtend.RB_Ebay_Listing_Queue_V2Extend.UpdateModifyLockGuid ( String LockGuid ) \ r \ n 在 Biz.Ebay.Listing.EbayUpdateProduct.UpdateQueueMain ( ) \ r \ n 在 ChinaDownLoadImage.Task.Task_Ebay_Listing_V2_Update.Execute ( ) \ r \ n 在 RB.Utility.SystemTask.< doTask > b__43_0 ( ) \ r \ n 在 System.Threading.Tasks.Task.Execute ( ) \ r \ n 在 System.Threading.ExecutionContext.RunInternal ( ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx ) \ r \ n 在 System.Threading.ExecutionContext.Run ( ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx ) \ r \ n 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal ( Task & currentTaskSlot ) \ r \ n 在 System.Threading.Tasks.Task.ExecuteEntry ( Boolean bPreventDoubleExecution ) \ r \ n 在 System.Threading.ThreadPoolWorkQueue.Dispatch ( ) \ r \ n \ r \ n -------------------------------------------------------------\r\n\n\n\r"}
重现步骤