-
Incident report
-
Resolution: Fixed
-
Major
-
2.2.1
Our zabbix started to produce strange logs:
23247:20140214:062505.184 [Z3005] query failed: [1062] Duplicate entry '100100000010710-General' for key 'applications_2' [insert into applications (applicationid,hostid,name) values (100100000004841,100100000010710,'Filesystem'),(100100000004842,100100000010710,'FTP service'),(100100000004843,100100000010710,'Zabbix agent'),(100100000004844,100100000010710,'General'),(100100000004845,100100000010710,'SSH service'),(100100000004846,100100000010710,'Integrity'),(100100000004847,100100000010710,'CPU'),(100100000004848,100100000010710,'Log files'),(100100000004849,100100000010710,'Filesystems'),(100100000004850,100100000010710,'Memory'),(100100000004851,100100000010710,'General'),(100100000004852,100100000010710,'Network'),(100100000004853,100100000010710,'Memory'),(100100000004854,100100000010710,'OS'),(100100000004855,100100000010710,'Network interfaces'),(100100000004856,100100000010710,'Performance'),(100100000004857,100100000010710,'OS'),(100100000004858,100100000010710,'Processes'),(100100000004859,100100000010710,'Performance'),(100100000004860,100100000010710,'Availability'),(100100000004861,100100000010710,'SCS'),(100100000004862,100100000010710,'Processes'),(100100000004863,100100000010710,'CPU'),(100100000004864,100100000010710,'Services'),(100100000004865,100100000010710,'Security'); insert into application_template (application_templateid,applicationid,templateid) values (100100000002485,100100000004841,100100000002398),(100100000002486,100100000004842,100100000003024),(100100000002487,100100000004843,100100000003620),(100100000002488,100100000004844,100100000002399),(100100000002489,100100000004845,100100000003032),(100100000002490,100100000004846,100100000002400),(100100000002491,100100000004847,100100000003621),(100100000002492,100100000004848,100100000002401),(100100000002493,100100000004849,100100000003622),(100100000002494,100100000004850,100100000002402),(100100000002495,100100000004851,100100000003623),(100100000002496,100100000004852,100100000002403),(100100000002497,100100000004853,100100000003624),(100100000002498,100100000004854,100100000002404),(100100000002499,100100000004855,100100000003625),(100100000002500,100100000004856,100100000002405),(100100000002501,100100000004857,100100000003626),(100100000002502,100100000004858,100100000002406),(100100000002503,100100000004859,100100000003627),(100100000002504,100100000004860,100100000002396),(100100000002505,100100000004861,100100000003557),(100100000002506,100100000004862,100100000003628),(100100000002507,100100000004863,100100000002397),(100100000002508,100100000004864,100100000002407),(100100000002509,100100000004865,100100000003629); ] 23247:20140214:062506.931 [Z3005] query failed: [1062] Duplicate entry '100100000010710-General' for key 'applications_2' [insert into applications (applicationid,hostid,name) values (100100000004841,100100000010710,'Filesystem'),(100100000004842,100100000010710,'FTP service'),(100100000004843,100100000010710,'Zabbix agent'),(100100000004844,100100000010710,'General'),(100100000004845,100100000010710,'SSH service'),(100100000004846,100100000010710,'Integrity'),(100100000004847,100100000010710,'CPU'),(100100000004848,100100000010710,'Log files'),(100100000004849,100100000010710,'Filesystems'),(100100000004850,100100000010710,'Memory'),(100100000004851,100100000010710,'General'),(100100000004852,100100000010710,'Network'),(100100000004853,100100000010710,'Memory'),(100100000004854,100100000010710,'OS'),(100100000004855,100100000010710,'Network interfaces'),(100100000004856,100100000010710,'Performance'),(100100000004857,100100000010710,'OS'),(100100000004858,100100000010710,'Processes'),(100100000004859,100100000010710,'Performance'),(100100000004860,100100000010710,'Availability'),(100100000004861,100100000010710,'SCS'),(100100000004862,100100000010710,'Processes'),(100100000004863,100100000010710,'CPU'),(100100000004864,100100000010710,'Services'),(100100000004865,100100000010710,'Security'); insert into application_template (application_templateid,applicationid,templateid) values (100100000002485,100100000004841,100100000002398),(100100000002486,100100000004842,100100000003024),(100100000002487,100100000004843,100100000003620),(100100000002488,100100000004844,100100000002399),(100100000002489,100100000004845,100100000003032),(100100000002490,100100000004846,100100000002400),(100100000002491,100100000004847,100100000003621),(100100000002492,100100000004848,100100000002401),(100100000002493,100100000004849,100100000003622),(100100000002494,100100000004850,100100000002402),(100100000002495,100100000004851,100100000003623),(100100000002496,100100000004852,100100000002403),(100100000002497,100100000004853,100100000003624),(100100000002498,100100000004854,100100000002404),(100100000002499,100100000004855,100100000003625),(100100000002500,100100000004856,100100000002405),(100100000002501,100100000004857,100100000003626),(100100000002502,100100000004858,100100000002406),(100100000002503,100100000004859,100100000003627),(100100000002504,100100000004860,100100000002396),(100100000002505,100100000004861,100100000003557),(100100000002506,100100000004862,100100000003628),(100100000002507,100100000004863,100100000002397),(100100000002508,100100000004864,100100000002407),(100100000002509,100100000004865,100100000003629);
It seems that machine auto registration stopped working...
We didn't alter database manually.
What can be the problem? How we can debug it and fix it?