-
Problem report
-
Resolution: Fixed
-
Trivial
-
4.4.2
-
None
-
Raspbian Buster (fully upgraded) on Raspberry Pi 4
Current MariaDB
-
Sprint 59 (Dec 2019), Sprint 60 (Jan 2020)
-
2
Steps to reproduce:
- Clean install of OS and Zabbix
- Verify database and all tables are configured with CHARACTER SET utf8 COLLATE utf8_bin;
- Configure a few OS hosts for monitoring using the OS agent (windows)
- Configure a few network devices (routers, wifi) for monitoring via SNMP
- Configure zabbix agentd on the zabbix server
- Verify functionality and monitoring data is being collected
- 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.
- is duplicated by
-
ZBX-17073 fresh installation on Raspberry Pi generates failed SQLs (Duplicate entry insertion) for LLD
- Closed