-
Problem report
-
Resolution: Duplicate
-
Blocker
-
None
-
4.4.3
-
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.
- duplicates
-
ZBX-16997 Duplicate key errors inserting to items_applications
- Closed