深圳智汇创想科技有限公司

prometheus告警

            开始时间: 04:03:52 

            错误代码: N040352202  

            sql类型: UPDATE   

            sql: [04:03:52]  -------------------------------------------------------------

CODE:N040352202

Error:16_8152_30_-2146232060

SQL:UPDATE RB_AmazonUploadProduct_V2

SET

Status=@Status,

UpdateTime=getdate(),

ErrRetryRemarks=isnull(ErrRetryRemarks,'')+'【重试标识_RetryCommonErrorUpload_230712_04_03】',

ErrRetryTime=getdate()

where QueueID in ( SELECT CONVERT(INT, item) FROM Charsplitforin(@QueueIDs, ',') )

And [CustomerID] = @CustomerID

PARAMS:@CustomerID = 1 ,@QueueIDs = 791515735,791410224,791362404,791308591,791271833,791261348,791257028,791033050,791018294,789755115,789740965,789711231,789693334,789660400,789639398,789622838,789580658,789554793,789524242,789523984,789523900,789500678,789491171,789437917,789367019,789366866,789366767,789366650,789366540,789359826,789359590,789359414,789359267,789359099,789340444,789235785,789234285,789233210,789231517,789229958,789220469,789220368,789220258,789220159,789220036,789215630,789215206,789215098,789203545,789203463,789203431,789203390,789203260,789201535,789201308,789201101,789200864,789200541,789200279,789200067,789199290,789194009,789193722,789193414,789193160,789192869,789192416,789192145,789191223,789188933,789188818,789188705,789188558,789186497,789180615,789180437,789180432,789180214,789179986,789179889,789179714,789171573,789171464,789171362,789171283,789171149,789136423,789136152,789135770,789110525,789110379,789110211,789110023,789100088,789099484,789099284,789085304,789084249,789083899,789083574,789083488,789083391,789083361,789083138,789080485,789078741,789077762,789056535,789056378,789055960,789049836,789049742,789049571,789049452,789049358,789047105,789047037,789037219,789011560,789009297,789002081,788999196,788995435,788994944,788980874,788980455,788979593,788979520,788979455,788979389,788979335,788917677,788917589,788917469,788917367,788917172,788917098,788917030,788916945,788913190,788907724,788899358,788899055,788898997,788897019,788896873,788896830,788891100,788890905,788890878,788890551,788890345,788890221,788710549,788710437,788707925,788707804,788707674,788707568,788572424,788519183,788507098,788462308,788427601,788424374,788424144,788424048,786327717,781549658,781457944,781420249,781414106,781391003,781248607,781248315,781248307,781247970,781193160,781192917,781121613,781120998,781120843,781120604,781119942,781119929,781118968,781118869,781118045,781094663,781094560,781094402,781094247,780811534,780810108,780792757,780792363,780696986,780660146,780659942,780659860,780659827,780659718,780659653,780659642,780659628,780659520,780659497,780659444,780659297,779284960,779217221,779207650,779178601,779145432,779144638,779096837,779094979,779039272,779029561,779029333,779014750,778978568,778965383,778953795,778942701,778920496,778912218,778902678,778872323,778740313,778738149,778545942,778484776,778374566,778374460,778370498,778370290,778370023,778337098,776835565,776805510,776745271,776721770,776675414,776570839,776568172,776553979,776553805,776514241,776512199,776511803,776510578,776494289,776484096,776412428,776412306,776140483,776099915,776090082,776088484,775999930,774903970,774903851,774799868,774799594,774785135,774324606,774324247,774056947,774035387,774035314,774014446,774010686,774010601,773993894,773985734,773985648,773964528,773964437,773891897,773891828,773891773,773891721,773889411,773889386,773889331,773889306,773810811,773798995,773760332,773723988,773699847,773679370,773665873,773606717,773579010,773559859,773420445,773371090,773310240,773310182,773277163,773211028,772320679,772320424,772312588,772312354,772219005,772205249,772205216,772190545,772181850,772178347,772161962,772148565,772081609,772058617,772033723,772025347,771987397,771930692,771901750,771724607,771713384,771451941,771392921,771382965,771246412,771213201,769120623,768762943,768555860,764973275,764783115,764768582,764768203,764733610,764729747,764707248,764697560,764679235,764670231,764648497,764614936,764580767,764552336,764531999,764499455,764453001,764432845,764347982,764326253,764315667,764315347,764297997,764266197,764261593,764109445,764083888,763983102,763086676,762715762,762610722,762596975,762545776,762519182,762519107,762493523,762400571,762396814,762384829,762348680,762211856,762190085,762011710,761915264,761894002,761830829,761830362,761744913,760555768,760377405,760350206,760322237,760285743,760262418,760262350,760262332,760253352,760246529,760235672,760229764,760222742,760218956,760206684,760186099,760180610,760168158,760159138,760134093,760113972,760112998,760086841,760073634,760023658,760006612,759823083,759704762,759644970,759629695,759619856,759521797,758325026,758324980,758286085,758284953,758251465,758245759,758222404,758207906,758196595,758185211,758165172,758149966,758143400,758119814,758058345,758024283,757934658,757874214,757858653,757847292,757638083,757445979,757428156,757339068,757269664,757263177,755557885,755546812,755535402,755496576,755488867,755411977,755400773,755373784,755304859,754861079,754488607,754453847,754357766,754348193,752490512,752462585,752442279,752424892,752423713,752415405,752389572,752371708,752302914,752279446,752236718,752167628,752131402,751946829,751931745,751924152,751911156,751873829,751822325,751817970,751352065,748933556,748925365,748919415,748902560,748895011,748889883,748887086,748886194,748872640,748868799,748864122,748860728,748829044,748781531,748777709,748775150,748773715,748771838,748763835,748763667,748761568,748758620,748758441,748750791,748700670,748697310,748679593,748678563,748677672,748667440,748654167,748653747,748651494,748643013,748634387,748626248,748625982,748607158,748601931,748590468,747479770,747471753,747425616,747423368,747373274,747348420,747324769,747300514,747172841,747103298,747096643,747060594,747043841,746906239,746844175,746829341,746826025,745399045,744979283,744905245,744901704,744767117,744451087,744214423,744150936,734611181,734606539,734330490,734330355,734320777,734268393,734207434,734067453,734053659,734030817,733772158,733745918,733738775,733738372,733687877,733508286,733488515,733487537,733485338,733481197,731807632,731786419,731776436,731748002,731745312,731741538,731740805,731740135,731738931,731737024,731725342,731723474,731720485,731720230,731713746,731698489,731665124,731616346,731580140,731575683,731573053,731572413,731568084,731549160,731517658,731315673,730132062,730119288,730092123,730069685,730057013,730046652,729983143,729812296,729733650,729723616,729512298,729311113,729308500,729306244,729259947,729254071,729248230,729195026,729190882,729188243,729177127,729176018,728186628,728091456 ,@Status = 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.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.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DALExtend.RB_AmazonUploadProduct_V2Extend.BatchUploadProductV2StatusByQueueIDsWithSign(Int32 customerID, Int32 status, List1 queueIDs, String descStr)

在 Biz.Irobotbox.Amazon.Amazon_RetryErrorUpload.RetryCommonErrorUpload(DateTime starTime, DateTime endTime, Nullable`1 isUserUpload)

在 ChinaDownLoadImage.Task.Amazon.Task_Amazon_AmazonRetryByErrorCode.Execute()

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

---