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

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

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

            Dates

              Created:
              Updated:
              Resolved: