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

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

    Details

      Description

      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?

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: