001- 性能优化-获取取消选中的库存订单 SQL 大量超时
001+ WMS:性能优化-获取取消选中的库存订单 SQL 大量超时

001- 性能优化-获取取消选中的库存订单 SQL 大量超时
001+ WMS:性能优化-获取取消选中的库存订单 SQL 大量超时

001- [步骤]
001+ <a href="https://alidocs.dingtalk.com/i/nodes/ZX6GRezwJl7BvlK5h6N6D9vnVdqbropQ?doc_type=wiki_doc">https://alidocs.dingtalk.com/i/nodes/ZX6GRezwJl7BvlK5h6N6D9vnVdqbropQ?doc_type=wiki_doc
002- [03:12:47] -------------------------------------------------------------CODE:N03124713Error:11_-2_0_-2146232060SQL:SELECT oi.CustomerID,oi.OrderCode,oi.IsPay,oi.PayTime,oi.OrderSourceID,oi.WareHouseID FROM RB_OrderInfo oi(NOLOCK) INNER JOIN RB_WareHouse wh(NOLOCK) ON oi.WareHouseID=wh.ID AND oi.CustomerID=wh.CustomerID LEFT JOIN RB_OrderInfo_InventoryCheckWhenPayed imp(NOLOCK) ON oi.OrderCode=imp.OrderCode and oi.CustomerID=imp.CustomerID WHERE oi.CustomerID=@CustomerID AND oi.IsPay=1 and oi.IsStockOrder=0 AND oi.AddTime&gt;='2023-02-16' and wh.WareHouseType=1 AND imp.ID IS NULL ORDER BY oi.PayTime PARAMS:@CustomerID = 1 ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) 在 System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetUncheckInventoryOrderModels(Int32 customerID, Boolean isUseWriteDB) 在 Biz.Irobotbox.Order.OrderInfoService.AutoCheckInventoryWithPaidOrder(Int32 customerID) 在 ChinaDownLoadImage.Task.Order.Task_AutoCheckInventoryWithPaidOrderService.Execute() 在 RB.Utility.SystemTask.b__43_0() 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.ThreadPoolWorkQueue.Dispatch()-------------------------------------------------------------[结果]
002+ [步骤]
003- [期望]
003+ [03:12:47] -------------------------------------------------------------CODE:N03124713Error:11_-2_0_-2146232060SQL:SELECT oi.CustomerID,oi.OrderCode,oi.IsPay,oi.PayTime,oi.OrderSourceID,oi.WareHouseID FROM RB_OrderInfo oi(NOLOCK) INNER JOIN RB_WareHouse wh(NOLOCK) ON oi.WareHouseID=wh.ID AND oi.CustomerID=wh.CustomerID LEFT JOIN RB_OrderInfo_InventoryCheckWhenPayed imp(NOLOCK) ON oi.OrderCode=imp.OrderCode and oi.CustomerID=imp.CustomerID WHERE oi.CustomerID=@CustomerID AND oi.IsPay=1 and oi.IsStockOrder=0 AND oi.AddTime&gt;='2023-02-16' and wh.WareHouseType=1 AND imp.ID IS NULL ORDER BY oi.PayTime PARAMS:@CustomerID = 1 ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) 在 System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady) 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 在 System.Data.SqlClient.SqlDataReader.get_MetaData() 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetUncheckInventoryOrderModels(Int32 customerID, Boolean isUseWriteDB) 在 Biz.Irobotbox.Order.OrderInfoService.AutoCheckInventoryWithPaidOrder(Int32 customerID) 在 ChinaDownLoadImage.Task.Order.Task_AutoCheckInventoryWithPaidOrderService.Execute() 在 RB.Utility.SystemTask.b__43_0() 在 System.Threading.Tasks.Task.Execute() 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot) 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution) 在 System.Threading.ThreadPoolWorkQueue.Dispatch()-------------------------------------------------------------[结果]
004- 改造 SQL 或者 延长 SQL 查询时长让其不报错
004+ [期望]
005+ 改造 SQL 或者 延长 SQL 查询时长让其不报错

001- <p>[步骤]</p>
001+ <p><a href="https://alidocs.dingtalk.com/i/nodes/ZX6GRezwJl7BvlK5h6N6D9vnVdqbropQ?doc_type=wiki_doc">https://alidocs.dingtalk.com/i/nodes/ZX6GRezwJl7BvlK5h6N6D9vnVdqbropQ?doc_type=wiki_doc</a></p>
002- <br /><br />[03:12:47] -------------------------------------------------------------<br />CODE:N03124713<br />Error:11_-2_0_-2146232060<br />SQL:SELECT oi.CustomerID,oi.OrderCode,oi.IsPay,oi.PayTime,oi.OrderSourceID,oi.WareHouseID FROM RB_OrderInfo oi(NOLOCK) <br /> INNER JOIN RB_WareHouse wh(NOLOCK) ON oi.WareHouseID=wh.ID AND oi.CustomerID=wh.CustomerID<br /> LEFT JOIN RB_OrderInfo_InventoryCheckWhenPayed imp(NOLOCK) ON oi.OrderCode=imp.OrderCode and oi.CustomerID=imp.CustomerID<br /> WHERE oi.CustomerID=@CustomerID AND oi.IsPay=1 and oi.IsStockOrder=0 AND oi.AddTime&gt;='2023-02-16' and wh.WareHouseType=1 AND imp.ID IS NULL<br /> ORDER BY oi.PayTime <br />PARAMS:@CustomerID = 1 ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 <br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetUncheckInventoryOrderModels(Int32 customerID, Boolean isUseWriteDB)<br /> 在 Biz.Irobotbox.Order.OrderInfoService.AutoCheckInventoryWithPaidOrder(Int32 customerID)<br /> 在 ChinaDownLoadImage.Task.Order.Task_AutoCheckInventoryWithPaidOrderService.Execute()<br /> 在 RB.Utility.SystemTask.b__43_0()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /><br />-------------------------------------------------------------<br /><br /><p>[结果]</p>
002+ <p>[步骤]</p>
003- <br /><p>[期望]</p>
003+ <br /><br />[03:12:47] -------------------------------------------------------------<br />CODE:N03124713<br />Error:11_-2_0_-2146232060<br />SQL:SELECT oi.CustomerID,oi.OrderCode,oi.IsPay,oi.PayTime,oi.OrderSourceID,oi.WareHouseID FROM RB_OrderInfo oi(NOLOCK) <br /> INNER JOIN RB_WareHouse wh(NOLOCK) ON oi.WareHouseID=wh.ID AND oi.CustomerID=wh.CustomerID<br /> LEFT JOIN RB_OrderInfo_InventoryCheckWhenPayed imp(NOLOCK) ON oi.OrderCode=imp.OrderCode and oi.CustomerID=imp.CustomerID<br /> WHERE oi.CustomerID=@CustomerID AND oi.IsPay=1 and oi.IsStockOrder=0 AND oi.AddTime&gt;='2023-02-16' and wh.WareHouseType=1 AND imp.ID IS NULL<br /> ORDER BY oi.PayTime <br />PARAMS:@CustomerID = 1 ,<br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 <br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)<br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /> 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)<br /> 在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br /> 在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)<br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /> 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /> 在 RB.DALExtendV2.RB_OrderInfoExtendV2.GetUncheckInventoryOrderModels(Int32 customerID, Boolean isUseWriteDB)<br /> 在 Biz.Irobotbox.Order.OrderInfoService.AutoCheckInventoryWithPaidOrder(Int32 customerID)<br /> 在 ChinaDownLoadImage.Task.Order.Task_AutoCheckInventoryWithPaidOrderService.Execute()<br /> 在 RB.Utility.SystemTask.b__43_0()<br /> 在 System.Threading.Tasks.Task.Execute()<br /> 在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)<br /> 在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task&amp; currentTaskSlot)<br /> 在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)<br /> 在 System.Threading.ThreadPoolWorkQueue.Dispatch()<br /><br />-------------------------------------------------------------<br /><br /><p>[结果]</p>
004- 改造 SQL 或者 延长 SQL 查询时长让其不报错
004+ <br /><p>[期望]</p>
005+ 改造 SQL 或者 延长 SQL 查询时长让其不报错