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

fresh installation on Raspberry Pi generates failed SQLs (Duplicate entry insertion) for LLD

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Blocker Blocker
    • None
    • 4.4.3
    • Server (S)
    • Team A
    • Sprint 59 (Dec 2019)

      Raspbian GNU/Linux 10 (buster), fresh installation zabbix 4.4.3 from official packages.

      # cat /proc/cpuinfo
      processor       : 0
      model name      : ARMv6-compatible processor rev 7 (v6l)
      BogoMIPS        : 697.95
      Features        : half thumb fastmult vfp edsp java tls
      CPU implementer : 0x41
      CPU architecture: 7
      CPU variant     : 0x0
      CPU part        : 0xb76
      CPU revision    : 7
      
      Hardware        : BCM2835
      Revision        : 000e
      Serial          : 00000000dc8125bb
      Model           : Raspberry Pi Model B Rev 2
      
      # mysqld -V
      mysqld  Ver 10.3.17-MariaDB-0+deb10u1 for debian-linux-gnueabihf on armv7l (Raspbian 10)
      

      Default "Zabbix server" host, after if performed initial LLD discovery for "Mounted filesystem discovery" and "Network interface discovery", start to rise these error each one hour:

        9784:20191212:005351.090 [Z3005] query failed: [1062] Duplicate entry '1305-30248' for key 'items_applications_1' [insert into items_applications (itemappid,applicationid,itemid) va
      lues (50001,1305,30248),(50002,1306,30249),(50003,1305,30244),(50004,1304,30243),(50005,1305,30240),(50006,1305,30236),(50007,1304,30239),(50008,1307,30246),(50009,1304,30235),(50010,
      1304,30247),(50011,1307,30250),(50012,1307,30242),(50013,1306,30241),(50014,1306,30245),(50015,1307,30238),(50016,1306,30237);
      ]
        9784:20191212:005351.195 [Z3005] query failed: [1062] Duplicate entry '1308-30253' for key 'items_applications_1' [insert into items_applications (itemappid,applicationid,itemid) va
      lues (50001,1308,30253),(50002,1308,30252),(50003,1308,30251),(50004,1308,30257),(50005,1308,30256),(50006,1308,30255),(50007,1308,30254),(50008,1308,30258);
      ]
      

      Using "Check now" for these 2 LLD rules you can cause the errors appearing as well.

            ak Andrejs Kozlovs
            zalex_ua Oleksii Zagorskyi
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: