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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 4.4.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Team:
      Team A
    • Sprint:
      Sprint 59 (Dec 2019)

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: