• Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Critical Critical
    • None
    • 2.2.21, 3.4.8
    • Agent (G), Proxy (P)
    • None
    • Production

      zabbix proxy and server - 3.4, agents - 2.4

      Windows hosts (110+) agents lost communication intermittently, 

      Dead lock warnings seen :

      30333:20180427:131054.254 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into problem (eventid,source,object,objectid,clock,ns) values (183424450,0,0,474404,1524834650,542040757),(183424451,0,0,474414,1524834650,542040757);
      
      30333:20180427:140549.430 item "rhldatzab45002:MySQL.Created-tmp-disk-tables" became not supported: Item preprocessing step #1 failed: cannot calculate delta (speed per second) for value "" of type "string": cannot convert value to numeric type
      
      30336:20180427:141106.365 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype,acknowledgeid) values (152486418,19,183448427,173,1524838260,4,'10.38.158.45','Free disk space is less than 10% on volume C: - Current Value = 7.27 %','PROBLEM 3 MON0010118 WINAPPCNR65412',3,'',1,0,null);
      
      30335:20180427:141106.402 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into problem (eventid,source,object,objectid,clock,ns) values (183448428,0,0,388499,1524838259,578349992);
      
      30334:20180427:141106.405 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into problem (eventid,source,object,objectid,clock,ns) values (183448429,0,0,329013,1524838259,968290282);
      
      30310:20180427:141106.421 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into problem (eventid,source,object,objectid,clock,ns) values (183448430,0,0,82539,1524838260,949143978),(183448431,0,0,17341,1524838260,946333165),(183448476,0,0,66016,1524838260,948770012),(183448477,0,0,68684,1524838260,948858908),(183448478,0,0,68712,1524838260,948864937);
      
      30333:20180427:141106.456 [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [insert into problem (eventid,source,object,objectid,clock,ns) values (183448479,0,0,196558,1524838260,802653594);
      

            Unassigned Unassigned
            prafulpol praful pol
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: