I think it was too early to claim victory
More of these errors appeare and local queue has 36 message for a
while, and users start to complain... 16:03 local time was the las
error. Now local queue is 0
Aug 10 15:18:04 pegasus dspam[20830]: bailing on error -2
Aug 10 15:18:04 pegasus dspam[20830]: received invalid result (!DSR_ISSPAM && !DSR_ISINNOCENT): -2
Aug 10 15:18:04 pegasus dspam[20830]: process_message returned error -5. delivering.
Aug 10 15:18:30 pegasus dspam[21046]: query error: Lock wait timeout exceeded; try restarting transaction: see sql.errors for more details
Aug 10 15:18:31 pegasus dspam[21046]: bailing on error -2
Aug 10 15:18:31 pegasus dspam[21046]: received invalid result (!DSR_ISSPAM && !DSR_ISINNOCENT): -2
Aug 10 15:18:31 pegasus dspam[21046]: process_message returned error -5. delivering.
Aug 10 15:24:02 pegasus dspam[21482]: query error: Lock wait timeout exceeded; try restarting transaction: see sql.errors for more details Aug 10 15:24:03 pegasus dspam[21482]: bailing on error -2 Aug 10 15:24:03 pegasus dspam[21482]: received invalid result (!DSR_ISSPAM && !DSR_ISINNOCENT): -2 Aug 10 15:24:04 pegasus dspam[21482]: process_message returned error -5. delivering.
I found this on sql.errors
[08/10/2020 15:24:02] 21482: Lock wait timeout exceeded; try
restarting transaction: UPDATE dspam_token_data SET
last_hit=CURRENT_DATE(),innocent_hits=innocent_hits+1 WHERE uid=28
AND token IN
('14948912781115726382','13709493569832925215','9567555186955417699','7781213596137448844','16876167394723670800','14135606515962448326','13633419060591756544','8376463136792755890','9859383381968039635','14250847747665388669','8708951579419797773','8906751288224622966','1553927311883140390','11459407007179615448','9422171567311614848','4772644390598950679','8167131950483473613','15857570470798748629','12799909717834687840','5624060604292616358','8349756927286612082','8496433124892917760','15005959597418372388','5193030024337512765','18281168459386439234','7072984635321474694','10654808874335640388','167718055410536722','8004930060319501920','3815724449467347857','17835323884672978220','12179720228897007200','2242408896133488806','8485550514024717153','8591035397149716480','16498890998351674918','1352888160187121963','8336303553928586473','5272077507401121952','9686448886222236400','3871040627331842931','786540618018073115','8517892446013532194','2562198556142376312','3376792808084563177','5956492006043883670','11103406511880464701','2311784741678416157','9186500473065401385','101890868803888361','18013701607969030263','1935929173093219923','1658736744487058018','992963647517526399','7847805996321276189','7225847788359653814','15408232980071114827','5842976179749744640','3232442855519593476','11620659528386764017','1340893192692943249','4883679786757601537','6714015356306259968','15999601993413965849','8650572628407852001','12380963508027706973','6972561290944637197','9185276402779666507','3119006314961589726','3210659742514494458','13755530858850940385','9146954543883565117','13679743247475195397','13387001378738632395','17411684054676086493','3520041829754729361','17847060910341045585','6440002448386431066','658685564483865421','8390986541685840737','216389171196459533','4332790240411430168','11977862441461069666','2915127033478652735','6262310753054319849','14730110773414117301','16077474756615792996','5717042429651033924','13385712474779931794','859922501179908818','13920698430544921946','4382988526455143184','7350890408395211037','7099249769087244726','1124380438450149846','4822488365770615096','9753682534574012691','9888093829592526547','15591602253602103195','10972611128875062787','15616813285946917055','13061602878448116324','14809010130167164559','14701987315543567064','2048618380655810265','6721918450908622848','15748594722330603727','12706030730669875742','16553172976508662750','12607878642794591947','6721925386814865408','14998734526249430152','15241311820920193187','8835017266755332353','4485098103874630621','13688949638360179580','8496363635499452160','15124446314158250570','8258622221940200027','556748360547464425','8195108978121895123','5027906060067485533','9897746827996311723','1121162384397559737','989358070399896882','15401895340928141412','1464490712720693565','258809129405224961','3033067735603572605','7686241969642385408','11158450875064555779','7138171929124726819','14519202874686964537','10153588856203831571','16676422077210461440','17273710503942333874','778971352488265576','11492511205587163591','7966374547778664377','8168493375314593042','10800052770385240829','10076049582126031940','1239975662711550539','15748594722413705151','16524692436025399882','1166515538513179228','10294316511497369121','2320359416493860073','15872821890417748324','6714015356304985456','12757279290587495014','13505428713600721066','9144254967405804045','5407965495453102648','1205613363931233661','16219404429108242788','3132280369505569032','15513115574931757614','15541143672374939644','2010349500198186622','13742595396547946735','9133730004138069298','13576497136721521023','4921235072002843881','17072355052248786593','4811496845818641534','7132120500384118661','14388352531173080080','7620056208530906447','12495217322516666803','10920456662451912230','10476479140788341065','17816787972297177941','2931339729037237535','12012116229948678228','3003252293410155390','2085969924581464065','13436869408672499713','7399795964234246285','1340323267372880214','12443408617266858520','9011477697434671768','3391833794332798569','8173649081727682147','8997972241548224546','5645876528989552806','5882791669624910369','18344094458822940189','15278331436529723736','17896210139503383199','9133754328198810930','18310561403251435883','15747198598985511119','15206762690538584420','3385104157882515741','4620104049382910143','7054085923300239741','4537102163180859960','12540522796718034072','4561777046649123384','8363024089896686425','2963723738561428240','11961879260470623427','15739518783606718655','10442537139216819608','8800634332129317510','2683658252926431497','2195616466363177277','6038988460588562749','3992166608269029944','1578310892171459878','2288751345394345193','6999309428648810637','10059619007025931971','16602766830167111166','12583548620691782468','9780901318046660633','16758156680380123924','16654044772939906359','509470277775129101','1403636854949511166','8095261402608671499','5287221291301561577','5225930379338508545','3793039011617323379','14042830181991341740','456626241349239414','9710882572177422843','11048324818781351635','7304863452832687337','9705832076167105086','15231117074395511765','8336200318388510416','15231109624496012245','3505558698057141554','10758302062509534758','4211770856940229643','13157369348961171147','1825510917725202208','2139220633048658818','14532276163649601764','4306057190818266027','8630524233042989647','7170593219826458515','651355948955573111','1469893571215831017','16093948268767406397','1859853549016497536','8471900890874864873','658325183622330849','7133667448774892879','17228573741593878643','6339711671047374768','5314240297128225042','6866412045999517969','15212764358642921572','15936754721501998396','7520932435464611875','15206742229402073444','4198890124070206018','11459407006026509785','10828689609444457629','8719475927680211608','14191007950558599329','3449364722887148571','14837718089931705700','7966374566234388409','1828135766853727680','4877386982301192973','4052623998151635512','9633093045892392407','1916434224998670755','15869273211563990919','589045813281805723','9727072623313173800','4865752989459483354','8545745139768321257','3622393229381284444','13637377293306353597','2849358046220407699','14953461861198927374','12317733282520478238','1563917564693477965','9965287732312000108','74038590523188893','1121236272932231353','8545888509731693307','13112281801480566475','13754491397999102159','15278553126503883519','9942383024577444989','15733759873027029017','6951630649593509260','13174669701963265632','5041640267163218371','12692423105453536697','15643306671134859664','16188952114474457173','13458043447164873683','16220699733654484478','1901967074710619067','275469111046055581','14828337791849996276','943605839538488821','10633612928198156283','6983715452825186872','15206669602356025700','15291222171642048088','5844877339661162224','17385088967529144740','672084524744384162','16984773459068938338','7439582003893858829','16330686116821282027','8256414541672955652','2634995831512363699','1331203157955853230','13778057928776884772','12508799451016558283','6947069665823908134','9649127799795491473','17301331975672884375','7910866058239469837','15747198617441235151','8776317602718626395','5514927056844286209','10865335532225980180','7025193346611189626','12801826469663766400','7203355334051993021','5692174385799708541','13018936746535792619','8197530476807852549','1619596833524661629','9033985937811268841','5961872115933560483','15904531808680153700','14465640463048104215','12049140583001501023','1815551224128994942','11343871190210082423','9629801144077579136','5692265936860773811','258809130124899441','4867627064319016960','11530441138492790499','18276552149520660256','15110689461883347028','6467979494869541687','109053273868740120','7761969926372674266','7336018383515386983','8613957673331493053','171670464408717076','2174364028266949782','11459407006048057225','18213801047485382632','8080495337053287130','14722657483767725628','16513034132614605156','333769656667874973','16511454025021553479','2942397510448127263','13935332245970381997','8462691534175214038','15967904906341644413','10359453998566173899','3610254066106708737','7964978442889295801','2887825424245504945','4558120444533579401','9426633770030634816','8429844217760123048','15225226109325558575','5455012940900208764','936076931884037652','16774754109128752678','4912768002405786857','9047463740039500301','9896646093276336910','12500778042724687362','4878913352593138921','11842478752273852772','989361587978112306','6483472987201935510','14786361776047123394','10316731401343783554','15230140124183718244','12451086019778104710','4072474150390631923','11045470306607444203','11538792971309149950','7575456820021973116','6931005465543220559','3338912312691571472','12840697721884942948','13779294719854683591','1119145413804021225','14620252271636472243','8367267304834012056','17677319877037769339','7066205540057517096','14304106363483563416','5684084699144515923','13958335839201737498','11678262341635027214','9644678482991510613','3186827825934092584','4109107868204740792','2085969925301138545','10844132886853373227','8467411884811838821','5334511981350707200','6383305272293132604','5514909921376940009','3406182250351919322','7468921195533577333','16124247065679593663','15212738791654747236','2291740198062089449','12410697917957384229','9969584382898647629','982008122009281769','4009729736656716335','2181240284936787742','11328845267534296','7820046272539453709','6358940778288017583','9686448573267843606','7081743125603766636','14078427335759611844','6928498405036847956','17794102610541020035','8427292660748388045','13217932154991835008','9751706965846072980','11696681807278604287','12625907771439817746','15437245930039695031','15300299074398139797','1889938689607028328','15229992580447267172','17893246564447180317','9050888227721749005','15647611183090252706','554867952153449503','6941623782129277366','13926936274627249598','9482972663143262483','3538414669057927940','15815917617968211981','1424635162553384110','595036240718947561','14981431884713766727','11037526547009442075','5118717935511382524','7234524142344386825','6815175349528370850','18275892830592697219','17713272839309939831','15638205499537064127','3337313158809325458','4244011710753354296','16810078037720239404','2751541368327900466','7958635638159537202','6229578906482403680','8463994360659998784','3840607166591998139','6505231226657718670','12893204255711123763','15235951860349066792','16795195800527728073','11751187042827140409','6604061670969286199','1012499138223438721','9873565543648176555','15312262076265576966','3035947249349199979','4504123859413003000','12976745292244303534','462547243403206042','4230581900727366200','6813629241685148062','13164882494185927352','5541433476933731092','14584685468925725479','17304132404269220713','15585085175927990628','6938937423421648521','11753420977397360996','990640471941672709','10206867333621559841','8149585243711057275','8224812219757038898','9002034106030862259','14824978684359600484','13277005144194038525','1392748516798457404','16280793764759033112','7964978461428119481','7222970012158303567','11993950288030160321','8097865943817690820','7964978461345019833','7399729153935562637','16409897493516936789','11415486795167940555','56390311818130066','15798146332774362061','8591008717973035968','4398504654869644509','7647321309034843968','16567701304063049920','1732850760721308884','10929063340986773187','10947749436495540353','329566069906994177','7892881397226930176','7811783961998155556','1237395117906111559','2178228320139772475','16483264327413207536','17940474498373201689','1855138733327463298','5203426615942059997','9172066847807681432','12118334559716086349','2019208140891202090','16277228495092354344','5479781484906513339','10015724510573563187','12214063106452665538','1897513123427286190','137772544585628173','10336328230722417185','16835177943716511029','7621667325862222262','6745515152634269903','11642650356453624833','13567410044735566895','464004602502456989','12534422401598977739','4961027871098489361','16103225035926333796','4867607873762961152','960202827962982121','12690155356551758459','8480788315509578253','12515534122870787659','15675170931622886170','4772558865970024448','12064893993196081254','1805643646404550042','17530409095460812565','16166152170421385918','3624144433007196814','10838453884894291733','11877827750152243726','3711404287406575616','14499278299273925771','15748594703874879695','9554812231794799384','13211003256280995230','4058233635735558820','8165150973408597496','633723488062333479','7347834667525920860','13201282297241800273','15991137959875154735','3025174525491528169','13806045031373943000','6348074726883304261','3958570283338011999','16757834170953832027','16627211376162363618','1766908734233541806','6198309616417514795','8754268971623506407','7303477456875413126','8399424093389923278','2277583418036008797','6723560690965025099','3025270494961296617','12505535671259132888','15059450657348197286')
