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

Duplicate key errors inserting to items_applications

XMLWordPrintable

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

      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.

        1. zabbix_server.log.2.gz
          454 kB
          Robert Garrett
        2. zabbix_server.log.gz
          2.46 MB
          Robert Garrett

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

              Created:
              Updated:
              Resolved: