日志抬头：326ce966-cca7-4cff-ae19-856adb2d03e7
业务单号：
记录时间：2026-03-17 16:16:03
日志内容：{"Code":"260317161603432","SqlText":" update b set b.ExpressCOM=a.ExpressCom,b.ExpressNO=a.ExpressNo, b.RefundType='1' from API_DRP_OrderRefund(nolock)  a left join Ord_Refund(nolock) b on a.code=b.code and a.oldcode=b.PId where    a.ExpressNo<>'' and a.ExpressNo<>b.ExpressNo  and  a.UpdateDateTime >DATEADD(DAY,-1,GETDATE()) and b.BillState<>'99' ","Message":"事务(进程 ID 167)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":51,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 167)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"8816707b-b302-4e91-b2d3-9af08e82fbb3\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 167)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Data\":{\"HelpLink.ProdName\":\"Microsoft SQL Server\",\"HelpLink.ProdVer\":\"15.00.2000\",\"HelpLink.EvtSrc\":\"MSSQLServer\",\"HelpLink.EvtID\":\"1205\",\"HelpLink.BaseHelpUrl\":\"http://go.microsoft.com/fwlink\",\"HelpLink.LinkId\":\"20476\"},\"InnerException\":null,\"HelpURL\":null,\"StackTraceString\":\"   在 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   在 QianHui.Infrastructure.SqlServerHelper.Execute(String sql, SqlTransaction sqlTran, CommandType cmdType, SqlParameter[] sqlParms)\",\"RemoteStackTraceString\":null,\"RemoteStackIndex\":0,\"ExceptionMethod\":\"8\\nOnError\\nSystem.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\\nSystem.Data.SqlClient.SqlConnection\\nVoid OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])\",\"HResult\":-2146232060,\"Source\":\".Net SqlClient Data Provider\",\"WatsonBuckets\":null}"}