prometheus告警

            开始时间: 04:07:05 

            错误代码: N04070589  

            sql类型: UPDATE   

            sql: [04:07:05]  -------------------------------------------------------------

CODE:N04070589

Error:16_8152_30_-2146232060

SQL:UPDATE RB_AmazonUploadProduct_V2

SET

Status=@Status,

UpdateTime=getdate(),

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

ErrRetryTime=getdate()

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

And [CustomerID] = @CustomerID

PARAMS:@CustomerID = 1 ,@QueueIDs = 803267208,803197528,803181834,803135450,803130586,803125249,803124088,803122323,803122068,803120508,803119633,803117683,803117423,803117294,803117282,803113572,803113571,803113570,803113569,803113524,803113452,803113445,803113319,803113316,803113315,803111394,803104162,803095692,803095599,803094428,803091894,803091823,803091431,803091069,803090588,803090587,803090556,803090189,803089004,803088700,803087582,803087441,803087346,803086485,803085200,803083756,803082337,803082267,803081019,803079761,803078785,803076194,803073798,803072755,803071724,803071240,803070988,803070925,803070797,803070736,803070413,803070397,803068892,803068306,803068049,803067959,803067953,803067912,803067907,803067857,803067833,803067640,803067600,803067563,803067337,803067294,803067288,803067286,803067281,803066847,803066576,803066524,803066481,803066445,803066407,803066148,803066087,803066079,803066037,803066031,803066030,803065983,803065901,803065824,803065635,803065584,803065530,803065520,803065330,803065256,803065245,803065171,803065051,803064893,803064875,803064688,803064657,803064655,803064653,803064641,803064637,803064611,803064608,803064605,803064040,803063831,803063793,803063744,803063669,803062923,803062886,803062277,803062099,803061970,803061929,803061921,803061874,803061296,803061278,803061248,803061141,803061134,803061128,803061042,803060988,803060924,803060919,803060907,803060690,803060663,803060645,803060601,803060556,803060502,803060471,803060115,803060014,803059674,803059672,803059407,803059343,803059325,803059322,803059222,803059221,803059149,803059089,803057921,803057202,803056570,803056443,803056233,803055828,803055671,803055560,803055191,803055089,803055083,803054808,803054779,803054383,803053566,803053092,803053074,803053060,803053050,803053040,803053008,803053006,803052947,803052941,803052694,803052666,803052626,803052586,803052574,803052572,803052463,803052462,803052458,803052028,803051949,803051898,803051894,803051843,803051749,803051742,803051687,803051685,803051658,803051609,803051606,803051495,803051428,803051393,803051385,803051383,803051302,803051301,803051296,803051254,803051238,803051138,803051030,803051022,803051006,803050970,803050947,803050894,803050766,803050277,803050213,803050207,803050195,803050140,803050131,803049804,803049619,803049612,803049610,803049607,803049348,803049336,803049333,803049325,803049263,803049252,803049245,803049235,803049232,803049227,803048731,803048475,803048471,803048467,803048124,803048026,803048020,803047971,803047958,803047947,803047925,803047921,803047636,803046760,803046690,803046418,803046366,803046343,803046285,803046248,803046132,803046126,803046123,803046111,803046053,803046010,803045978,803045958,803045329,803045311,803045196,803045192,803045188,803045182,803045165,803045113,803045109,803045015,803045003,803044990,803044934,803044360,803044301,803044143,803043990,803043915,803043850,803043849,803043792,803043789,803043784,803043758,803043681,803043676,803043557,803043550,803043413,803043319,803043318,803043187,803043138,803043129,803042741,803042733,803042668,803040779,803040516,803040498,803040469,803040445,803040397,803040359,803039891,803039799,803039744,803039666,803039627,803039416,803039385,803039332,803039301,803039299,803039272,803039238,803038290,803038217,803038017,803037976,803037975,803037911,803037905,803037874,803037873,803037872,803036704,803036516,803036445,803036348,803036211,803036167,803036166,803036164,803036161,803036083,803036065,803035977,803035463,803035278,803035150,803035007,803034955,803034953,803034922,803033821,803033606,803031724,803031202,803029893,803029827,803029799,803028030,803027930,803027920,803027917,803027915,803027912,803027908,803027643,803027561,803027380,803027299,803027290,803027273,803027271,803027264,803027258,803027253,803027249,803027245,803027236,803027226,803027187,803027098,803027086,803027082,803027074,803027072,803027064,803027056,803026989,803026567,803025098,803025020,803024904,803024899,803024896,803024873,803024152,803024076,803023038,803022944,803021415,803021315,803021243,803021150,803021144,803020269,803020235,803020224,803020223,803020222,803020221,803020220,803020219,803020208,803020169,803020141,803020133,803020132,803020131,803020130,803020129,803020128,803020120,803020119,803020118,803020110,803020095,803020094,803020093,803020078,803020077,803020076,803020073,803020061,803020060,803020059,803020052,803020051,803020050,803020030,803020029,803020028,803020027,803020020,803020019,803020018,803019968,803019967,803019966,803019965,803019964,803019953,803019952,803019951,803019950,803019949,803019913,803019912,803019907,803019906,803019858,803019855,803019822,803019821,803019820,803019819,803019818,803019817,803019816,803019815,803019814,803019813,803019801,803019800,803019799,803019798,803019797,803019671,803019455,803019000,803018560,803018475,803018440,803018437,803018419,803018417,803018399,803017927,803017284,803017266,803017091,803017046,803016891,803016825,803016801,803016781,803016768,803016735,803016692,803016587,803016099,803015676,803015672,803015549,803015544,803015459,803015422,803015364,803015362,803015174,803014568,803014534,803014363,803014359,803014348,803014326,803014210,803014206,803014202,803010466,803009937,803009825,803009647,803009576,803009566,803009540,803009500,803009268,803009117,803008997,803008968,803008959,803008932,803008840,803008593,803008433,803008413,803008328,803008273,803004517,803003003,803002768,803002643,803002590,803002333,803002331,803002321,803002314,803002308,803002305,803002298,803002297,803002292,803002281,803001838,803001624,803001209,803000463,803000318,803000302,803000295,803000165,803000061,802999891,802999810,802999639,802999627,802999604,802999603,802999521,802999160,802990541,802982324,802878653,802878649,802878647,802878644,802875281,802874725,802874724,802872750,802872736,802872735,802872722,802872653,802872650,802872645,802872492,802872489,802872486,802872483,802870937,802870923,802870864,802870857,802870848,802870732,802870717,802870675,802870549,802870364,802870350,802868944,802868792,802868721,802868676,802868620,802868613,802868275,802868170,802868120,802867984,802867933,802867928,802867860,802867836,802867403,802867390,802867388,802867366,802867361,802867179,802867102,802866593,802866389,802866388,802866342,802866038,802863639,802863545,802863464,802863442,802863406,802863250,802863242,802862675,802862598,802862377,802862168,802862122,802862120,802862064,802862060,802862052,802861953,802861877,802861832,802861780,802861720,802861706,802861551,802861528,802861491,802861437,802861389,802859975,802859905,802859891,802858922,802858611,802858582,802858311,802858304,802858243,802858241,802857941,802857928,802857873,802857869,802857827,802856993,802856627,802856546,802856407,802856326,802856143,802856140,802856060,802855741,802855733,802855686,802855503,802855150,802854955,802854869,802854732,802854633,802854493,802854475,802853963,802853956,802853951,802853950,802853941,802853926,802853808,802852032,802851706,802851015,802850932,802850847,802850693,802849871,802849865,802849637,802849505,802849499,802849495,802849487,802849481,802849473,802849468,802849457,802849194,802849018,802848919,802848446,802846642,802846630,802846505,802846495,802846466,802846419,802846361,802846311,802845461,802845457,802845446,802845394,802845390,802845386,802845382,802844974,802844770,802844676,802843818,802843700,802843402,802842614,802842494,802842451,802842445,802842388,802842053,802841977,802841903,802841787,802841716,802841620,802841493,802841282,802841124,802839784,802839753,802839454,802839019,802838960,802835743,802835500,802835387,802835370,802835280,802835269,802833397,802833247,802833226,802833222,802832488,802831427,802831362,802830912,802828945,802828766,802828693,802828521,802828519,802828422,802828342,802828047,802828045,802828004,802827498,802827463,802827456,802825470,802825390,802825102,802824803,802823466,802823425,802823143,802822103,802821080,802821003,802820706,802820544,802820188,802819874,802819791,802819662,802818891,802816529,802650018,802649929,802649836,802636991,802633590,802633505,802630175,802630169,802621522,802621377,802618003,802617945,802617835,802617789,802617754,802615736,802613642,802612626,802612606,802612292,802612074,802612046,802611982,802611957,802611487,802608916,802608800,802608286,802607769,802606042,802599569,802596401,802585585,802585385,802580488,802575491,802575079,802575047,802574051,802573109,802572989,802565276,802564766,802564700,802563693,802562230,802562100,802560707,802560194,802560127,802557822,802554469,802552720,802551038,802551027,802550980,802550958,802550947,802550937,802550926,802550914,802550904,802550892,802550882,802550871,802550860,802550788,802550787,802550783,802550778,802550744,802550734,802550724,802550711,802550695,802550619,802548690,802548150,802545788,802545767,802542776,802540947,802532980,802530577,802527353,802523539,802523350,802513559,802512662,802510203,802486804,802476501,802473639,802471584,802457856,802449491,802449331,802447906,802447210,802447150,802446315,802446303,802446273,802446268,802446266,802442311,802440980,802440038,802440016,802440013,802439970,802439966,802439091,802435226,802434894,802426127,802425913,802425911,802425906,802425902,802425024,802417552,802417551,802417550,802417541,802417477,802417476,802417475,802053014,802052992,802052987,802042980,802042976,802042972,802042934,802027310,802019589,802019554,802017459,802017435,802016774,802012912,802012908,802012904,802012826,802007961,802006080,802006076,802006043,802005275,801996242,801991175,801991038,801991030,801980737,801980708,801979021,801978343,801978180,801978019,801972458,801972407,801972383,801964677,801960045,801953636,801953627,801946608,801945192,801945182,801945171,801945150,801944567,801943125,801939927,801932913,801931310,801930138,801922288,801922148,801915389,801887010,801886952,801852951,801789089,801766683,801737193,801737149,801737059,801699352,801699276,801696690,801696688,801696654,801696617,800904390,800814844,800814806,800770648,800698468,800611266,800608945,800575107,800559662,800559598,800545903,800545853,800545824,800190152,800190138,800161464,800161463,800161454,800161453,800153468,800152978,800151639,800150173,800149317,800149312,800147681,800147206,800144522,800141889,800133711,800133653,800112324,800091568,800085934,800084026,800079456,800079416,800079402,800079267,800079243,800077748,800077747,800077746,800077743,800077741,800075396,800075376,800075373,800075369,800075001,800073269,800073221,800070583,800070538,800070385,800070337,800068394,800064804,800064785,800064778,800064739,800064735,800059910,800059869,800059861,800059614,800059605,800058593,800058546,800058542,800058540,800058536,800044058,800028412,800024695,800022421,800019802,800019705,800018362,800017952,800017151,800015123,800010429,800009804,800007574,800006732,800005067,800002785,800002555,800000674,799986605,799986442,799880214,799880104,799880076,799879985,799879942,799874783,799112508,798112854,798107012,798068325,798068152,798059924,798043446,798042839,798040057,798025464,798002550,797997228,797989201,797988308,797978470,797970354,797958210,797953503,797949675,797949216,797949094,797949091,797946474,797945857,797945374,797944788,797938507,797927723,797926004,797892179,797877181,797873727,797872055,797870532,797830501,797695103,796396287,796075811,796058871,796049369,796049097,796048926,796048702,794555733,794555652,794555605,794555570,794523450,794515097,794514092,794505007,794444083,791771464,791767323,791767023,791708299,791690508,791671331,791581417,791508752,791495698,791477353,791429000,791356552,791261348,791259046,791257028,791248626,791033050,790997192,790956201,790889926,789755115,789740965,789711231,789693334,789660400,789656474,789159888,789158050,789083697,789078940,789078741,789077762,788973345,788746188,788744955,788646576,788642955,788519183,788464603,788461087,788427601,788424144,781470028,781469506,781463872,781460527,781460457,781459663,781457944,781388475,781382980,781360578,781359844,781250565,781250534,781249981,781249747,781208437,781207132,780581234,780580723,780580369,780579889,780579756,779369014,779284960,779207650,779144638,779116827,779096837,779094979,779029561,779029333,779016078,778965383,778942701,778920496,778912218,778902678,778872323,778740313,778738149,778545942,778484776,778374566,778374460,778370498,778370290,778370023,778337098,776675414,776647732,776607120,776606096,776604951,776514241,776510578,776494289,776484096,776186369,776186352,776186310,776140483,776121671,776099915,776090082,776088484,775999930,774056947,774014446,773993894,773810811,773798995,773760332,773723988,773699847,773679370,773665873,773606717,773579010,773559859,773420445,773371090,773277163,773211028,772219005,772190545,772181850,772161962,772148565,772058617,772033723,772025347,771987397,771930692,771901750,771724607,771713384,771451941,771392921,771382965,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,763922125,763086676,762715762,762610722,762596975,762545776,762493523,762400571,762396814,762384829,762348680,762190085,762011710,761915264,761894002,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,758286085,758284953,758251465,758245759,758222404,758207906,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 ,@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()

---