Что можно предпринять воизбежание таких ошибок? Сыпятся постоянно после перезда на другой сенрвер.
Code: Select all
Mysql error 1205: Lock wait timeout exceeded; try restarting transaction (UPDATE IGNORE rot_gallery_stats1 SET
total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4,
total_clicks = current_clicks + clicks0 + clicks1 + clicks2 + clicks3 + clicks4,
total_points = current_points + points0 + points1 + points2 + points3 + points4
WHERE thumb_id IN ('66410','85138','56232','83841','82990','62982','66039','57966','85073','63306','85129','56942','85071','66080','61949','85133','58220','84955','65811','82533','58246','84146','85123','56575','85074','85143','54825','64776','54656','26046','54316','83263','57835','85107','17529','65431','28520','34261','13398','16565','28963','27296','34078','20053','28767','34417','85053','83007','84993','35462','18169','45226','33869','85092','32136','32250','15309','31520','56862','83331','20503','57073','34398','57292','38827','55592','32476','57325','82013','57872','20331','31441','26739','20368','18819','58981','25104','44622','44405','82631','45125','30004','84161','18088','35264','13233','17456','43618','24551','64864','31990','18455','22466','22087','45528','15444','17292','14930','38957','84199','40666','18730','31021','65152','64845','41015','17948','33121','34445','40906','21170','44032','21397','62057','57036','84622','85124','55435','61667','83689','28910','56708','63090','17857','57769','63720','46068','57306','41755','54893','27548','54590','44520','54927','21530','54232','15320','55644','46500','57667','26170','54854','13197','25013','20609','20245','23006','60376','35446','21429','64865','17669','45623','82936','31508','20982','83503','59259','29673','14279','27311','64796','34993','30193','23199','15297','46503','43778','33528','66292','39635','84589','63647','30811','54184','83346','63961','21829','56411','83635','23757','58225','83299','22394','57776','24724','54631','39657','57609','38829','35309','85055','44204','42987','27211','82054','85095','35189','45518','81515','13431','84363','14412','82418','17388','33599','29807','15025','39712','22700','17019','34705','84295','31191','82542','17374','33695','20420','13222','85072','85070','85113','85023','85019','85106','85013','85100','85011','85006','85087','85084','84954','85059','84953','84952','84951','85045','84940','85041','84936','85034','84933','84927','84992','84923','84984','84877','84978','84876','84973','84875','84971','84963','84909','84905','84902','84894','84890','84884','84864','84862','84852','55261','27048','66111','63754','34619','55054','83957','63407','20844','27708','84490','24625','55735','29047','20838','17786','65040','20049','41267','16504','30950','42598','13801','65057','18988','84214','20855','15053','60334','13919','16325','16846','13497','43825','26680','32267','14882','64017','81626','41232','25718','84741','28275','42193','32073','18164','20715','22719','33180','55768','63358','84693','66330','82125','56320','62871','83732','66183','27577','54332','62139','31585','57317','62496','31130','56219','40813','54772','40786','57316','13494','54848','17254','81696','44136','30594','17912','39312','17174','21352','45175','31784','13753','30204','22069','14647','14402','14896','84361','17455','15179','17871','44396','35554','22139','19173','44688','43004','30540','65099','26452','81594','45764','13575','57402','66009','62647','41954','57953','66274','62024','84774','56133','66262','62922','35015','56846','62443','18703','54287','57241','19301','54975','22275','54337','30503','54873','31649','55382','55632','25088','24902','15877','35573','32714','31903','14200','25263','35012','42026','45792','45101','41241','26241','15787','42993','23739','34147','33976','27476','21657','45861','16168','20188','24319','18186','45093') )