307243:20250428:151039.021 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,name,severity) values (222916608,0,0,3518246,1745845835,718767,1,'/var/log: Disk space is low (used > 80%)',2);.] 307243:20250428:151039.021 In dbconn_get_cached_nextid() table:'event_tag' num:12 307243:20250428:151039.021 End of dbconn_get_cached_nextid() table:'event_tag' [33167419:33167430] 307243:20250428:151039.021 query [txnlev:1] [insert into event_tag (eventtagid,eventid,tag,value) values (33167419,222916608,'scope','availability'),(33167420,222916608,'scope','capacity'),(33167421,222916608,'component','storage'),(33167422,222916608,'filesystem','/var/log'),(33167423,222916608,'discovery','vmware_custom'),(33167424,222916608,'env','TEST'),(33167425,222916608,'contract','P0124001096'),(33167426,222916608,'SLA','N-00-00-00-00'),(33167427,222916608,'path','vm/Hosted/Vault/test'),(33167428,222916608,'vm_id','vm-194188'),(33167429,222916608,'class','os'),(33167430,222916608,'target','linux');.] 307243:20250428:151039.021 [Z3008] query failed due to primary key constraint: [1062] Duplicate entry '33167419' for key 'PRIMARY' MariaDB [zabbix]> select count(*) from event_tag; +----------+ | count(*) | +----------+ | 33056641 | +----------+ 1 row in set (4.965 sec) MariaDB [zabbix]> select * from event_tag where eventtagid = 33167419; +------------+-----------+--------+-----------+ | eventtagid | eventid | tag | value | +------------+-----------+--------+-----------+ | 33167419 | 226515294 | target | cisco-ios | +------------+-----------+--------+-----------+ 1 row in set (0.001 sec) MariaDB [zabbix]> select * from events where eventid = 226515294; +-----------+--------+--------+----------+------------+-------+--------------+-----------+-----------------------------------------+----------+ | eventid | source | object | objectid | clock | value | acknowledged | ns | name | severity | +-----------+--------+--------+----------+------------+-------+--------------+-----------+-----------------------------------------+----------+ | 226515294 | 0 | 0 | 4622333 | 1745791969 | 1 | 0 | 974111956 | Cisco IOS: High ICMP ping response time | 2 | +-----------+--------+--------+----------+------------+-------+--------------+-----------+-----------------------------------------+----------+ 1 row in set (0.001 sec) MariaDB [zabbix]> describe event_tag -> ; +------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+---------------------+------+-----+---------+-------+ | eventtagid | bigint(20) unsigned | NO | PRI | NULL | | | eventid | bigint(20) unsigned | NO | MUL | NULL | | | tag | varchar(255) | NO | | | | | value | varchar(255) | NO | | | | +------------+---------------------+------+-----+---------+-------+ 4 rows in set (0.000 sec) MariaDB [zabbix]> show create table event_tag; +-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | event_tag | CREATE TABLE `event_tag` ( `eventtagid` bigint(20) unsigned NOT NULL, `eventid` bigint(20) unsigned NOT NULL, `tag` varchar(255) NOT NULL DEFAULT '', `value` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`eventtagid`), KEY `event_tag_1` (`eventid`), CONSTRAINT `c_event_tag_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin | +-----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec) MariaDB [zabbix]> select * from event_tag order by eventtagid desc limit 10; +------------+-----------+-----------+--------------+ | eventtagid | eventid | tag | value | +------------+-----------+-----------+--------------+ | 33175870 | 222949120 | target | generic | | 33175869 | 222949120 | class | network | | 33175868 | 222949120 | component | network | | 33175867 | 222949120 | component | health | | 33175866 | 222949120 | scope | performance | | 33175865 | 222949120 | scope | availability | | 33175864 | 222949100 | target | generic | | 33175863 | 222949100 | class | network | | 33175862 | 222949100 | component | network | | 33175861 | 222949100 | component | health | +------------+-----------+-----------+--------------+ 10 rows in set (0.000 sec)