日志抬头：337dc2d0-3337-4fcd-b3fe-0cf90043af04
业务单号：
记录时间：2026-02-13 22:42:50
日志内容：{"Code":"260213224250288","SqlText":" delete a from API_DRP_BarCode_Temp(nolock) a where  BarCode_API='3523854864843778' and FromShop='DS0091' ;\r\nINSERT INTO API_DRP_BarCode_Temp(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nvalues('YA25211H015182135','YA25211H015182135','ON','1968931837205852189','3766351736470634683','3523854864843778','L','蓝色','YA25211H015182135','169','129'\r\n,'DouDian','1968922476987322368','DouDian','DS0091','2026/2/13 22:42:45','%7b%22id%22%3a%221968931837205852189%22%2c%22refSpuId%22%3a%223766351736470634683%22%2c%22refSkuId%22%3a%223523854864843778%22%2c%22status%22%3a%22ON%22%2c%22outerId%22%3a%22YA25211H015182135%22%2c%22title%22%3a%22%e7%88%b1%e5%ae%a22025%e5%a4%8f%e5%ad%a3%e6%9e%81%e7%ae%80%e9%a3%8e%e4%b8%a4%e4%bb%b6%e5%a5%97%e8%a3%85%e8%ae%be%e8%ae%a1%e5%b8%88%e5%a5%b3%e8%a3%85%e6%94%b6%e8%85%b0%e6%97%b6%e5%b0%9a%e5%a5%97%e8%a3%85YA25211H015%22%2c%22barcode%22%3a%22YA25211H015182135%22%2c%22standards%22%3a%22L%2c%e8%93%9d%e8%89%b2%22%2c%22cid%22%3anull%2c%22price%22%3a%22169%22%2c%22num%22%3a129%2c%22matchStatus%22%3a%22UN_MATCHER%22%2c%22matchType%22%3anull%2c%22picUrl%22%3a%22https%3a%2f%2fp3-aio.ecombdimg.com%2fobj%2fecom-shop-material%2fjpeg_m_5200608a7d8f031f941e6cbfdb77e504_sx_22525_www800-800%22%2c%22url%22%3anull%2c%22syncErrMsg%22%3anull%2c%22sysOuterId%22%3anull%2c%22createTime%22%3a%221753844841000%22%2c%22updateTime%22%3a%221765501302000%22%2c%22refPlatform%22%3a%22DY%22%2c%22thirdSkuType%22%3a%22DY%22%2c%22refType%22%3a%22MALL%22%2c%22marketType%22%3anull%2c%22refBrandName%22%3anull%2c%22refSourceId%22%3a%221968922476987322368%22%2c%22refSourceCode%22%3anull%2c%22groupPrice%22%3anull%2c%22inputStr%22%3anull%2c%22presaleType%22%3a%22none%22%2c%22deliveryMode%22%3a%22Now%22%2c%22deliveryDays%22%3a2%2c%22presellDelay%22%3a0%2c%22multiTime%22%3a%5b%5d%7d','2025/7/30 11:07:21','2025/12/12 9:01:42','0','P36','条码不存在','','none','Now','2','0'); delete a from API_DRP_BarCode_dtl(nolock) a where FromShop='DS0091' and BarCode_API='3523854864843778';","Message":"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"d001568c-22e3-4623-adf0-2d36cb381d78\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}
日志抬头：cd9ea66f-d2ac-4a1c-8e37-d13cc31b8917
业务单号：
记录时间：2026-02-13 22:42:54
日志内容：{"Code":"260213224254045","SqlText":"update a set a.GoodsCode =isnull(b.code,'') ,a.sysis= (case when b.code is null then '0' else '1' end),a.Remark= (case when b.code is null then '商品不存在' else '匹配成功' end)\r\nfrom API_DRP_BarCode_Temp(nolock) a left join BD_Goods_dtl(nolock) b on a.BarCode =b.BarCode  ;update b set b.Status=a.Status,b.UpdateDateTime=a.CreateDateTime,b.UpdateUserCode='API',b.refId=a.refId,b.presaleType=a.presaleType,b.deliveryMode=a.deliveryMode,b.deliveryDays=a.deliveryDays,b.BarCode=a.BarCode,b.GoodsCode=a.GoodsCode,b.Remark=a.Remark,b.sysis=a.sysis,b.presellDelay=a.presellDelay  from API_DRP_BarCode_Temp(nolock)  a left join API_DRP_BarCode(nolock) b on a.BarCode_API=b.BarCode_API and a.fromshop=b.fromshop;INSERT INTO API_DRP_BarCode(GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay)\r\nselect GoodsCode,BarCode, Status,refId,GoodsCode_API,BarCode_API,API_Ext1N,API_Ext2N,outerId,TagPrice,Stock_API\r\n,Platformstr,PlatformFromShop,Platform,FromShop,CreateDateTime,vjson,createTime,modifyTime,sysis,SourceProcessCode,Remark,API_Ext3N,presaleType,deliveryMode,deliveryDays,presellDelay from API_DRP_BarCode_Temp(nolock)   a  \r\nwhere NOT EXISTS  (select b.BarCode_API from API_DRP_BarCode(nolock) b where a.fromshop=b.FromShop and a.BarCode_API=b.BarCode_API) ; delete API_DRP_BarCode_Temp     where BarCode_API  in (select b.BarCode_API from API_DRP_BarCode(nolock) b) and  CreateDateTime<=dateadd(minute,-60,GETDATE()) ;","Message":"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。","Req":"{\"Errors\":[{\"Source\":\".Net SqlClient Data Provider\",\"Number\":1205,\"State\":52,\"Class\":13,\"Server\":\"172.18.63.40,4001\",\"Message\":\"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"Procedure\":\"\",\"LineNumber\":1}],\"ClientConnectionId\":\"d001568c-22e3-4623-adf0-2d36cb381d78\",\"ClassName\":\"System.Data.SqlClient.SqlException\",\"Message\":\"事务(进程 ID 120)与另一个进程被死锁在 锁 | 通信缓冲区 资源上，并且已被选作死锁牺牲品。请重新运行该事务。\",\"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}"}