[步骤]
CODE:N2032118Error:11_-2_0_-2146232060
SQL: SELECT TOP 200
alias.ID as Id,
alias.CustomerID,
b.OrderSourceCountry AS Country,
alias.OrderSourceId,
b.OrderSourceName AS OrderSourceName,
sb.OrderSourceSKU AS OrderSourceSku,
sb.SKU AS Sku,
alias.[Subject] AS Title,
(select stuff((select ','+AttrValue from RB_AliExpress_Listing_ProductProperty (nolock) c where (c.AttrValue <>'' or c.AttrValue IS NOT NULL) AND c.ListingID= alias.Id for xml path('')),1,1,'')) as Attributes,
alias.Detail AS [Description],
alias.OnlineState AS Status
FROM [RB_AliExpress_Listing] AS alias WITH ( NOLOCK )
LEFT JOIN RB_AliExpress_Listing_SKU ( NOLOCK ) AS sb ON alias.ID=sb.ListingID
LEFT JOIN RB_OrderSource ( NOLOCK ) AS b ON alias.OrderSourceID=b.Id
WHERE alias.[CustomerID]=1 AND alias.OnlineState <>2 AND alias.UpdateTime >= '2023/6/2 15:03:23' AND alias.UpdateTime < '2023/6/4 15:03:23' AND alias.ID>0 ORDER BY alias.ID ASC;
PARAMS:
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& 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& 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& task, Boolean& 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.DALExtend.Generate.RB_AliExpress_ListingExtend.GetAliExpressPlatformListing(Int32 customerId, DateTime updateBeginTime, DateTime updateEndTime, Int64 maxId, Int32 pageSize)
在 Biz.InfringingWords.AliExpressPlatformInfringingWordsService.GetAliExpressListingDataUpload(RB_BusinessToOpenSearch_Sync syncModel)
在 Biz.InfringingWords.InfringingWordsService.UpdateSyncConfig(Int32 customerId, String type, Func`2 func)
在 System.Collections.Generic.List`1.ForEach(Action`1 action)
在 ChinaDownLoadImage.Task.InfringingWords.Task_AliExpress_InfringingWords.Execute()
在 RB.Utility.SystemTask.<doTask>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& currentTaskSlot)
在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
在 System.Threading.ThreadPoolWorkQueue.Dispatch()
本语句查询 通过ID排序 无法使用 上 系统索引 IX_RB_AliExpress_Listing_CustomerID_UpdateTime
[结果]
[期望]
修改ID排序 为 updatetime 或者 删除 top 200 以提升性能