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);
- is duplicated by
-
ZBX-14312 Proxy->Agent communication drops intermittently
- Closed