[步骤]
prometheus告警
开始时间: 00:16:49
错误代码: N00164912
sql类型: INSERT
sql: [00:16:49] -------------------------------------------------------------
CODE:N00164912
Error:16_8152_30_-2146232060
SQL:insert into RB_AliExpress_OpenRefundOrderTMC values (@CustomerID,@OrderSourceID,@SellerOperatorLoginID,@OrderCount,@AddTime,@IsSuccess,@Remark) ;select @@IDENTITY
PARAMS:@CustomerID = 1 ,@OrderSourceID = 7110 ,@SellerOperatorLoginID = cn1524363825zzeq ,@OrderCount = 0 ,@AddTime = 2023/1/2 0:16:49 ,@IsSuccess = True ,@Remark = 调用API接口:[es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@37f6d310 on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-1-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 113ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@3af06142[Running, pool size = 49, active threads = 49, queued tasks = 1002, completed tasks = 4543641833]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@3a65936a on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-5-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 800.1ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@6496788e[Running, pool size = 49, active threads = 49, queued tasks = 1015, completed tasks = 4568641277]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@eb3b52b on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-4-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 31.3ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@46316314[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4563866931]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@12eac573 on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-3-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 91.8ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@13d5375[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4557800483]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@23dd4644 on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-2-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 5.2ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@2eccb7d2[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4556219478]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@2203b0f1 on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-1-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 113ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@3af06142[Running, pool size = 49, active threads = 49, queued tasks = 1002, completed tasks = 4543641833]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@4605d6ad on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-5-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 197.2ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@6496788e[Running, pool size = 49, active threads = 49, queued tasks = 1015, completed tasks = 4568641281]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@4e2dbf98 on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-4-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 31.3ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@46316314[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4563866931]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@74b18fae on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-3-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 91.8ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@13d5375[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4557800483]] (and) [es_rejected_execution_exception] rejected execution of org.elasticsearch.common.util.concurrent.TimedRunnable@6cf4719f on QueueResizingEsThreadPoolExecutor[name = hwy-zh-gz-css-datawarehouse-ess-esn-2-1/search, queue capacity = 1000, min queue capacity = 1000, max queue capacity = 1000, frame size = 2000, targeted response rate = 1s, task execution EWMA = 5.2ms, adjustment amount = 50, org.elasticsearch.common.util.concurrent.QueueResizingEsThreadPoolExecutor@2eccb7d2[Running, pool size = 49, active threads = 49, queued tasks = 1000, completed tasks = 4556219478]]接口返回记录数为0 ,
MESSAGE:String or binary data would be truncated.
The statement has been terminated.
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, TaskCompletionSource1 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.ExecuteScalar()
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtend.Generate.RB_AliExpress_OpenRefundOrderTMCExtend.Add(RB_AliExpress_OpenRefundOrderTMC model)
在 Biz.AliExpress.AliexpressMQService.ExecuteTask(CM_GetOrderSourceByAliexpress model)
在 RB.Utility.TaskSmartManager1.execute(Func2 execFunction)
在 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()
[结果]
[期望]
最新提交记录
解决方案:分析这个Remark 意义不大,可以截取处理,已截取处理