重现步骤

[步骤]

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()




[结果]


[期望]


历史记录  
  1. 2023-01-03 10:23:50, 由 袁慧斌 创建。
  2. 2023-01-03 15:12:33, 由 胡晓龙 指派给 程伟。
    修改了 指派给,旧值为 "huxiaolong",新值为 "chengwei"。
  3. 2023-01-03 15:26:25, 由 程伟 指派给 谢业福。
    修改了 指派给,旧值为 "chengwei",新值为 "xieyefu"。
  4. 2023-01-03 16:22:52, 由 谢业福 解决,方案为 历史bug(180天以上) 。
    修改了 解决方案,旧值为 "",新值为 "history"。
    修改了 解决版本,旧值为 "",新值为 "647"。
    修改了 解决日期,旧值为 "",新值为 "2023-01-03 16:21:01"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "xieyefu"。


    最新提交记录


    解决方案:分析这个Remark 意义不大,可以截取处理,已截取处理


  5. 2023-01-04 09:28:49, 由 谢业福 指派给 林鸿贵。
    修改了 指派给,旧值为 "xieyefu",新值为 "linhonggui"。
  6. 2023-01-04 16:39:04, 由 林鸿贵 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "linhonggui",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "linhonggui"。
    修改了 关闭日期,旧值为 "",新值为 "2023-01-04 16:39:04"。
    线上观察
  7. 2023-11-17 09:45:18, 由 刘超 编辑。
    修改了 所属模块,旧值为 "1729",新值为 "1868"。
  8. 2023-11-17 09:53:55, 由 刘超 编辑。
    修改了 所属模块,旧值为 "1868",新值为 "1863"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型
严重程度 提示
优先级 P2
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2023-01-04 16:39:04
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2023-01-03 10:23:50
影响环境 577
由谁解决 谢业福 于 2023-01-03 16:21:01
解决版本 2023智汇一月分支BUG
解决方案 历史bug(180天以上)
由谁关闭 林鸿贵 于 2023-01-04 16:39:04
最后修改 刘超 于 2023-11-17 09:53:48
相关Bug