Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-7817

Duplicate entry '100100000010710-General' for key 'applications_2'

XMLWordPrintable

      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?

            Unassigned Unassigned
            kpucynski Karol Pucynski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: