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

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 4.4.2
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Raspbian Buster (fully upgraded) on Raspberry Pi 4
      Current MariaDB
    • Team:
      Team C
    • Sprint:
      Sprint 59 (Dec 2019), Sprint 60 (Jan 2020)
    • Story Points:
      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

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

                Dates

                Created:
                Updated:
                Resolved: