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

Duplicate key errors inserting to items_applications

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 4.4.2
    • Server (S)
    • None
    • Raspbian Buster (fully upgraded) on Raspberry Pi 4
      Current MariaDB
    • Team C
    • Sprint 59 (Dec 2019), Sprint 60 (Jan 2020)
    • 2

    Description

      Steps to reproduce:

      1. Clean install of OS and Zabbix
      2. Verify database and all tables are configured with CHARACTER SET utf8 COLLATE utf8_bin;
      3. Configure a few OS hosts for monitoring using the OS agent (windows)
      1. Configure a few network devices (routers, wifi) for monitoring via SNMP
      2. Configure zabbix agentd on the zabbix server
      3. Verify functionality and monitoring data is being collected
      4. Monitor contents of zabbix_server.log

      Result:
      Observe many/repeating occurrences of messages similar to:

       1753:20191127:071745.921 [Z3005] query failed: [1062] Duplicate entry '1346-30464' for key 'items_applications_1' [insert into items_applications (itemappid,applicationid,itemid) values (45487,1346,30464),(45488,1347,30480),(45489,1343,30471),(45490,1347,30470),(45491,1343,30466),(45492,1345,30463),(45493,1344,30472),(45494,1344,30467),(45495,1347,30465),(45496,1346,30479),(45497,1346,30469),(45498,1343,30461),(45499,1347,30475),(45500,1344,30462),(45501,1345,30473),(45502,1344,30477),(45503,1345,30478),(45504,1345,30468),(45505,1346,30474),(45506,1343,30476);
      Expected:
      No messages.

      Questions:

      Please explain the function and use of the items_applications table, how these messages may be affecting zabbix, and if possible how I might correct what's causing them.

      Attachments

        Issue Links

          Activity

            People

              ak Andrejs Kozlovs
              BearGFR Robert Garrett
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: