[步骤]
CODE:N005358452Error:13_1205_12_-2146232060
SQL:SELECT TOP 1000 [ID],[CustomerID],[OrderSourceID],[OrderID],[IsProcess],[ProcessTime],[AddTime],[UpdateTime],[MessageToSeller],[Status],[BuyerID],[BuyerEmail],[BuyerLogin],[BuyerIsGuest],[BuyerFirstName],[BuyerLastName],[BuyerCompanyName],[BuyerPersonalIdentity],[BuyerPhoneNumber],[BuyerAddressStreet],[BuyerAddressCity],[BuyerAddressPostCode],[BuyerAddressCountryCode],[SurchargeInfo],[DiscountsInfo],[SummaryTotalToPayAmount],[SummaryCurrency],[OrderUpdatedAt],[PaymentID],[PaymentType],[PaymentProvider],[PaymentFinishedAt],[PaymentPaidAmount],[PaymentCurrency],[IsInvoiceRequired],[InvoiceAddressStreet],[InvoiceAddressCity],[InvoiceAddressZipCode],[InvoiceAddressCountryCode],[InvoiceAddressCompanyName],[InvoiceAddressCompanyTaxID],[InvoiceAddressNaturalPersonFirstName],[InvoiceAddressNaturalPersonLastName],[DeliveryAddressFirstName],[DeliveryAddressLastName],[DeliveryAddressStreet],[DeliveryAddressCity],[DeliveryAddressZipCode],[DeliveryAddressCountryCode],[DeliveryAddressCompanyName],[DeliveryAddressPhoneNumber],[DeliveryMethodID],[DeliveryMethodName],[DeliveryPickupPointID],[DeliveryPickupPointName],[DeliveryPickupPointDescription],[PickupPointAddressStreet],[PickupPointAddressZipCode],[PickupPointAddressCity],[CostAmount],[CostCurrency],[DeliveryTimeGuaranteedFrom],[DeliveryTimeGuaranteedTo],[IsSmart],[CalculatedNumberOfPackages],[FulfillmentStatus],[FulfillmentLineItemsSent]
FROM RB_Allegro_OrderInfo
WHERE IsProcess = 0
AND UpdateTime >= Dateadd(MONTH, -1, Getdate())
ORDER BY UpdateTime ASC
PARAMS:
MESSAGE:Transaction (Process ID 826) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
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.TryHasMoreRows(Boolean& moreRows)
在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
在 System.Data.SqlClient.SqlDataReader.Read()
在 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
在 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
在 System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
在 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_Allegro_OrderInfoExtend.GetAllegroNoProcessOrderInfo()
在 Biz.Allegro.AllegroOrderMatchRules.GetOrderInfoListMapping()
在 Biz.PlatformUtil.OrderMatchRules.AOrderMatchRules.DoOrderMatchingRulesTask(Nullable`1 IsSplitStrategyQueue, List`1 orderResult)
在 ChinaDownLoadImage.Task.Task_Order_OrderInfoMatchRules.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()
[结果]
[期望]
添加nolock
添加nolock