Trgiger status Problem - after restore database

[lukisec]

Hi,

MariaDB [zabbix]> select * from zabbix.event_recovery where eventid=3883;
+---------+-----------+-----------+---------------+--------+
| eventid | r_eventid | c_eventid | correlationid | userid |
+---------+-----------+-----------+---------------+--------+
| 3883 | 3893 | NULL | NULL | NULL |
+---------+-----------+-----------+---------------+--------+
1 row in set (0.00 sec)



and i have still problem with provblem resolving, plz help.

[aigars.kadikis]

Hi,

Please show MySQL output from:

use zabbix;
show create table items;

Regards,

[lukisec]

+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| items | CREATE TABLE `items` (
`itemid` bigint(20) unsigned NOT NULL,
`type` int(11) NOT NULL DEFAULT '0',
`snmp_community` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`snmp_oid` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
`hostid` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`key_` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`delay` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '0',
`history` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '90d',
`trends` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '365d',
`status` int(11) NOT NULL DEFAULT '0',
`value_type` int(11) NOT NULL DEFAULT '0',
`trapper_hosts` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`units` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`snmpv3_securityname` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`snmpv3_securitylevel` int(11) NOT NULL DEFAULT '0',
`snmpv3_authpassphrase` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`snmpv3_privpassphrase` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`formula` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`lastlogsize` bigint(20) unsigned NOT NULL DEFAULT '0',
`logtimefmt` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`templateid` bigint(20) unsigned DEFAULT NULL,
`valuemapid` bigint(20) unsigned DEFAULT NULL,
`params` text COLLATE utf8_bin NOT NULL,
`ipmi_sensor` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`authtype` int(11) NOT NULL DEFAULT '0',
`username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`password` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`publickey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`privatekey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`mtime` int(11) NOT NULL DEFAULT '0',
`flags` int(11) NOT NULL DEFAULT '0',
`interfaceid` bigint(20) unsigned DEFAULT NULL,
`port` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`description` text COLLATE utf8_bin NOT NULL,
`inventory_link` int(11) NOT NULL DEFAULT '0',
`lifetime` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '30d',
`snmpv3_authprotocol` int(11) NOT NULL DEFAULT '0',
`snmpv3_privprotocol` int(11) NOT NULL DEFAULT '0',
`state` int(11) NOT NULL DEFAULT '0',
`snmpv3_contextname` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`evaltype` int(11) NOT NULL DEFAULT '0',
`jmx_endpoint` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`master_itemid` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`itemid`),
UNIQUE KEY `items_1` (`hostid`,`key_`),
KEY `items_3` (`status`),
KEY `items_4` (`templateid`),
KEY `items_5` (`valuemapid`),
KEY `items_6` (`interfaceid`),
KEY `items_7` (`master_itemid`),
CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE,
CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE,
CONSTRAINT `c_items_3` FOREIGN KEY (`valuemapid`) REFERENCES `valuemaps` (`valuemapid`),
CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`),
CONSTRAINT `c_items_5` FOREIGN KEY (`master_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.18 sec)

[aigars.kadikis]

Please upgrade Zabbix server + frontend to latest 3.4.x version.

yum clean all
yum update zabbix-server zabbix-web

If the error persists, please include a bigger range of log:

grep "query failed" /var/log/zabbix/zabbix_server.log

Please format the log with CODE tag:


Regards,

[lukisec]

Hi,


zabbix_server (Zabbix) 3.4.9
Revision 80550 9 May 2018, compilation time: May 9 2018 10:02:30

44317:20180511:102312.591 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17661,44537,null,null,null),(9775,44537,null,null,null),(51393,44537,null,null,null),(31354,44537,null,null,null),(47462,44537,null,null,null),(60303,44537,null,null,null),(57386,44537,null,null,null),(11012,44537,null,null,null),(12959,44537,null,null,null),(69140,44537,null,null,null),(8201,44537,null,null,null),(93898,44537,null,null,null),(14506,44537,null,null,null),(115795,44537,null,null,null),(38593,44537,null,null,null),(86407,44537,null,null,null),(20095,44537,null,null,null),(80429,44537,null,null,null),(8561,44537,null,null,null),(88849,44537,null,null,null),(35046,44537,null,null,null),(13101,44537,null,null,null),(98584,44537,null,null,null),(96657,44537,null,null,null),(15309,44537,null,null,null),(17345,44537,null,null,null),(9628,44537,null,null,null),(60026,44537,null,null,null),(102316,44537,null,null,null),(113301,44537,null,null,null),(29240,44537,null,null,null),(28048,44537,null,null,null),(16887,44537,null,null,null),(64232,44537,null,null,null),(10710,44537,null,null,null),(133279,44537,null,null,null),(109107,44537,null,null,null),(18042,44537,null,null,null),(12598,44537,null,null,null),(53878,44537,null,null,null),(27423,44537,null,null,null),(87513,44537,null,null,null),(94856,44537,null,null,null),(34304,44537,null,null,null),(130545,44537,null,null,null),(83916,44537,null,null,null),(36470,44537,null,null,null),(144547,44537,null,null,null),(120460,44537,null,null,null),(34911,44537,null,null,null),(32800,44537,null,null,null),(77147,44537,null,null,null),(90729,44537,null,null,null),(12173,44537,null,null,null),(140433,44537,null,null,null),(88336,44537,null,null,null),(80619,44537,null,null,null),(79148,44537,null,null,null),(52383,44537,null,null,null),(115558,44537,null,null,null),(47364,44537,null,null,null),(13919,44537,null,null,null),(114648,44537,null,null,null),(120692,44537,null,null,null),(116887,44537,null,null,null),(36353,44537,null,null,null),(84655,44537,null,null,null),(36017,44537,null,null,null),(19429,44537,null,null,null),(109352,44537,null,null,null),(52676,44537,null,null,null),(34926,44537,null,null,null),(8520,44537,null,null,null),(3136,44537,null,null,null),(105966,44537,null,null,null),(44705,44537,null,null,null),(98013,44537,null,null,null),(33081,44537,null,null,null),(15845,44537,null,null,null),(15686,44537,null,null,null),(32550,44537,null,null,null),(39882,44537,null,null,null),(37528,44537,null,null,null),(43458,44537,null,null,null),(5388,44537,null,null,null),(42071,44537,null,null,null),(108025,44537,null,null,null),(44140,44537,null,null,null),(41074,44537,null,null,null),(103815,44537,null,null,null),(40550,44537,null,null,null),(138371,44537,null,null,null),(127864,44537,null,null,null),(119864,44537,null,null,null),(26137,44537,null,null,null),(116059,44537,null,null,null),(118200,44537,null,null,null),(13232,44537,null,null,null),(89783,44537,null,null,null),(15689,44537,null,null,null),(95000,44537,null,null,null),(9075,44537,null,null,null),(127777,44537,null,null,null),(126411,44537,null,null,null),(40727,44537,null,null,null),(6867,44537,null,null,null),(7275,44537,null,null,null),(116153,44537,null,null,null),(19345,44537,null,null,null),(138706,44537,null,null,null),(141493,44537,null,null,null),(31009,44537,null,null,null),(140670,44537,null,null,null),(45507,44537,null,null,null),(35378,44537,null,null,null),(6047,44537,null,null,null),(77482,44537,null,null,null),(15614,44537,null,null,null),(144338,44537,null,null,null),(52331,44537,null,null,null),(69037,44537,null,null,null),(139939,44537,null,null,null),(93310,44537,null,null,null),(52137,44537,null,null,null),(145487,44537,null,null,null),(141992,44537,null,null,null),(16277,44537,null,null,null),(72356,44537,null,null,null),(143861,44537,null,null,null),(108183,44537,null,null,null),(136491,44537,null,null,null),(21077,44537,null,null,null),(42212,44537,null,null,null),(74920,44537,null,null,null),(118048,44537,null,null,null),(23242,44537,null,null,null),(134097,44537,null,null,null),(129670,44537,null,null,null),(33850,44537,null,null,null),(74223,44537,null,null,null),(23830,44537,null,null,null),(27896,44537,null,null,null),(34724,44537,null,null,null),(103169,44537,null,null,null),(141910,44537,null,null,null),(32419,44537,null,null,null),(19753,44537,null,null,null),(112428,44537,null,null,null),(127292,44537,null,null,null),(42771,44537,null,null,null),(76320,44537,null,null,null),(108368,44537,null,null,null),(99283,44537,null,null,null),(13489,44537,null,null,null),(48505,44537,null,null,null),(2796,44537,null,null,null),(22076,44537,null,null,null),(125738,44537,null,null,null),(77342,44537,null,null,null),(115256,44537,null,null,null),(133559,44537,null,null,null),(37970,44537,null,null,null),(4237,44537,null,null,null),(9987,44537,null,null,null),(82131,44537,null,null,null),(99329,44537,null,null,null),(31456,44537,null,null,null),(10804,44537,null,null,null),(108909,44537,null,null,null),(22251,44537,null,null,null),(47580,44537,null,null,null),(8365,44537,null,null,null),(24106,44537,null,null,null),(106632,44537,null,null,null),(37125,44537,null,null,null),(10970,44537,null,null,null),(40772,44537,null,null,null),(119068,44537,null,null,null),(74549,44537,null,null,null),(20602,44537,null,null,null),(7729,44537,null,null,null),(117702,44537,null,null,null),(34353,44537,null,null,null),(29384,44537,null,null,null),(37095,44537,null,null,null),(22433,44537,null,null,null),(11561,44537,null,null,null),(36780,44537,null,null,null),(16930,44537,null,null,null),(80472,44537,null,null,null),(20372,44537,null,null,null),(65304,44537,null,null,null),(32727,44537,null,null,null),(31368,44537,null,null,null),(32496,44537,null,null,null),(6828,44537,null,null,null),(125684,44537,null,null,null),(90824,44537,null,null,null),(81416,44537,null,null,null),(52036,44537,null,null,null),(31404,44537,null,null,null),(108418,44537,null,null,null),(19626,44537,null,null,null),(51860,44537,null,null,null),(32753,44537,null,null,null),(90636,44537,null,null,null),(117884,44537,null,null,null),(14729,44537,null,null,null),(132157,44537,null,null,null),(5951,44537,null,null,null),(99427,44537,null,null,null),(77106,44537,null,null,null),(41808,44537,null,null,null),(14569,44537,null,null,null),(45307,44537,null,null,null),(84243,44537,null,null,null),(18865,44537,null,null,null),(10933,44537,null,null,null),(111585,44537,null,null,null),(100274,44537,null,null,null),(90070,44537,null,null,null),(110512,44537,null,null,null),(77906,44537,null,null,null),(7202,44537,null,null,null),(83278,44537,null,null,null),(66386,44537,null,null,null),(115860,44537,null,null,null),(53290,44537,null,null,null),(19712,44537,null,null,null),(94699,44537,null,null,null),(66563,44537,null,null,null),(7118,44537,null,null,null),(71598,44537,null,null,null),(15540,44537,null,null,null),(13327,44537,null,null,null),(38585,44537,null,null,null),(102456,44537,null,null,null),(14875,44537,null,null,null),(126139,44537,null,null,null),(80822,44537,null,null,null),(131964,44537,null,null,null),(108577,44537,null,null,null),(136698,44537,null,null,null),(130288,44537,null,null,null),(109646,44537,null,null,null),(103078,44537,null,null,null),(31498,44537,null,null,null),(76683,44537,null,null,null),(103278,44537,null,null,null),(41067,44537,null,null,null),(54468,44537,null,null,null),(130962,44537,null,null,null),(32977,44537,null,null,null),(9165,44537,null,null,null),(3208,44537,null,null,null),(85203,44537,null,null,null),(83988,44537,null,null,null),(20145,44537,null,null,null),(69838,44537,null,null,null),(78464,44537,null,null,null),(33363,44537,null,null,null),(80189,44537,null,null,null),(15216,44537,null,null,null),(140855,44537,null,null,null),(129509,44537,null,null,null),(85887,44537,null,null,null),(81993,44537,null,null,null),(15069,44537,null,null,null),(4143,44537,null,null,null),(126312,44537,null,null,null),(51092,44537,null,null,null),(16378,44537,null,null,null),(85573,44537,null,null,null),(43815,44537,null,null,null),(113485,44537,null,null,null),(41417,44537,null,null,null),(38835,44537,null,null,null),(118760,44537,null,null,null),(134851,44537,null,null,null),(124632,44537,null,null,null),(11934,44537,null,null,null),(44536,44537,null,null,null),(134741,44537,null,null,null),(35206,44537,null,null,null),(65877,44537,null,null,null),(119549,44537,null,null,null),(3853,44537,null,null,null),(72305,44537,null,null,null),(36611,44537,null,null,null),(23742,44537,null,null,null),(89678,44537,null,null,null),(138873,44537,null,null,null),(37028,44537,null,null,null),(144139,44537,null,null,null),(49859,44537,null,null,null),(40455,44537,null,null,null),(82449,44537,null,null,null),(64061,44537,null,null,null),(11053,44537,null,null,null),(39418,44537,null,null,null),(140249,44537,null,null,null),(137007,44537,null,null,null),(116389,44537,null,null,null),(103029,44537,null,null,null),(48639,44537,null,null,null),(38108,44537,null,null,null),(6641,44537,null,null,null),(86855,44537,null,null,null),(134195,44537,null,null,null),(106531,44537,null,null,null),(14165,44537,null,null,null),(111442,44537,null,null,null),(86571,44537,null,null,null),(82882,44537,null,null,null),(12353,44537,null,null,null),(50689,44537,null,null,null),(14763,44537,null,null,null),(18196,44537,null,null,null),(36102,44537,null,null,null),(19142,44537,null,null,null),(129709,44537,null,null,null),(97604,44537,null,null,null),(7436,44537,null,null,null),(103661,44537,null,null,null),(40688,44537,null,null,null),(19665,44537,null,null,null),(59693,44537,null,null,null),(112131,44537,null,null,null),(74960,44537,null,null,null),(101056,44537,null,null,null),(63175,44537,null,null,null),(37131,44537,null,null,null),(122907,44537,null,null,null),(60410,44537,null,null,null),(141540,44537,null,null,null),(73506,44537,null,null,null),(68325,44537,null,null,null),(35161,44537,null,null,null),(51586,44537,null,null,null),(9118,44537,null,null,null),(55390,44537,null,null,null),(29074,44537,null,null,null),(35738,44537,null,null,null),(130911,44537,null,null,null),(111254,44537,null,null,null),(57111,44537,null,null,null),(58171,44537,null,null,null),(110168,44537,null,null,null),(98742,44537,null,null,null),(76817,44537,null,null,null),(21187,44537,null,null,null),(10702,44537,null,null,null),(93704,44537,null,null,null),(60118,44537,null,null,null),(101247,44537,null,null,null),(22380,44537,null,null,null),(124077,44537,null,null,null),(126847,44537,null,null,null),(24401,44537,null,null,null),(137828,44537,null,null,null),(114901,44537,null,null,null),(14673,44537,null,null,null),(106019,44537,null,null,null),(77393,44537,null,null,null),(49059,44537,null,null,null),(35618,44537,null,null,null),(92309,44537,null,null,null),(86490,44537,null,null,null),(60810,44537,null,null,null),(30429,44537,null,null,null),(108126,44537,null,null,null),(7569,44537,null,null,null),(60362,44537,null,null,null),(124220,44537,null,null,null),(82393,44537,null,null,null),(106305,44537,null,null,null),(72084,44537,null,null,null),(64614,44537,null,null,null),(28415,44537,null,null,null),(70887,44537,null,null,null),(102115,44537,null,null,null),(144997,44537,null,null,null),(110249,44537,null,null,null),(33473,44537,null,null,null),(34787,44537,null,null,null),(8980,44537,null,null,null),(52728,44537,null,null,null),(101779,44537,null,null,null),(39612,44537,null,null,null),(29580,44537,null,null,null),(123416,44537,null,null,null),(74767,44537,null,null,null),(36439,44537,null,null,null),(29666,44537,null,null,null),(16176,44537,null,null,null),(119588,44537,null,null,null),(18260,44537,null,null,null),(15480,44537,null,null,null),(35763,44537,null,null,null),(31110,44537,null,null,null),(5571,44537,null,null,null),(107668,44537,null,null,null),(12325,44537,null,null,null),(127821,44537,null,null,null),(143921,44537,null,null,null),(10336,44537,null,null,null),(31829,44537,null,null,null),(74594,44537,null,null,null),(8412,44537,null,null,null),(85699,44537,null,null,null),(37747,44537,null,null,null),(3378,44537,null,null,null),(35655,44537,null,null,null),(43766,44537,null,null,null),(7719,44537,null,null,null),(55273,44537,null,null,null),(20516,44537,null,null,null),(100469,44537,null,null,null),(67699,44537,null,null,null),(56193,44537,null,null,null),(107510,44537,null,null,null),(71079,44537,null,null,null),(92962,44537,null,null,null),(122202,44537,null,null,null),(9264,44537,null,null,null),(40780,44537,null,null,null),(36740,44537,null,null,null),(55828,44537,null,null,null),(12231,44537,null,null,null),(142597,44537,null,null,null),(108811,44537,null,null,null),(108279,44537,null,null,null),(75741,44537,null,null,null),(50821,44537,null,null,null),(20322,44537,null,null,null),(106789,44537,null,null,null),(15582,44537,null,null,null),(87821,44537,null,null,null),(21792,44537,null,null,null),(44399,44537,null,null,null),(88659,44537,null,null,null),(24890,44537,null,null,null),(109555,44537,null,null,null),(77950,44537,null,null,null),(68812,44537,null,null,null),(31460,44537,null,null,null),(60950,44537,null,null,null),(35699,44537,null,null,null),(142646,44537,null,null,null),(12764,44537,null,null,null),(97551,44537,null,null,null),(39374,44537,null,null,null),(121424,44537,null,null,null),(85780,44537,null,null,null),(144290,44537,null,null,null),(142163,44537,null,null,null),(127246,44537,null,null,null),(64174,44537,null,null,null),(92491,44537,null,null,null),(35514,44537,null,null,null),(14204,44537,null,null,null),(42920,44537,null,null,null),(37799,44537,null,null,null),(85531,44537,null,null,null),(75930,44537,null,null,null),(82699,44537,null,null,null),(24309,44537,null,null,null),(64469,44537,null,null,null),(18089,44537,null,null,null),(33789,44537,null,null,null),(18921,44537,null,null,null),(8598,44537,null,null,null),(71289,44537,null,null,null),(42302,44537,null,null,null),(28785,44537,null,null,null),(18417,44537,null,null,null),(6122,44537,null,null,null),(39725,44537,null,null,null),(39983,44537,null,null,null),(61560,44537,null,null,null),(17400,44537,null,null,null),(42461,44537,null,null,null),(130472,44537,null,null,null),(64370,44537,null,null,null),(18646,44537,null,null,null),(8973,44537,null,null,null),(64986,44537,null,null,null),(37845,44537,null,null,null),(67453,44537,null,null,null),(36506,44537,null,null,null),(107622,44537,null,null,null),(46275,44537,null,null,null),(104153,44537,null,null,null),(30811,44537,null,null,null),(100715,44537,null,null,null),(8063,44537,null,null,null),(75262,44537,null,null,null),(136242,44537,null,null,null),(133936,44537,null,null,null),(122621,44537,null,null,null),(141286,44537,null,null,null),(79562,44537,null,null,null),(12570,44537,null,null,null),(13094,44537,null,null,null),(102741,44537,null,null,null),(25430,44537,null,null,null),(2685,44537,null,null,null),(36880,44537,null,null,null),(118885,44537,null,null,null),(71988,44537,null,null,null),(12834,44537,null,null,null),(134535,44537,null,null,null),(77739,44537,null,null,null),(11216,44537,null,null,null),(137184,44537,null,null,null),(39837,44537,null,null,null),(110755,44537,null,null,null),(114840,44537,null,null,null),(83637,44537,null,null,null),(11854,44537,null,null,null),(34481,44537,null,null,null),(10612,44537,null,null,null),(109190,44537,null,null,null),(80763,44537,null,null,null),(123457,44537,null,null,null),(58505,44537,null,null,null),(79189,44537,null,null,null),(31111,44537,null,null,null),(30046,44537,null,null,null),(139114,44537,null,null,null),(52480,44537,null,null,null),(8423,44537,null,null,null),(42726,44537,null,null,null),(133371,44537,null,null,null),(137050,44537,null,null,null),(62541,44537,null,null,null),(92919,44537,null,null,null),(124440,44537,null,null,null),(141592,44537,null,null,null),(77239,44537,null,null,null),(134651,44537,null,null,null),(62739,44537,null,null,null),(33616,44537,null,null,null),(45860,44537,null,null,null),(141034,44537,null,null,null),(63088,44537,null,null,null),(53785,44537,null,null,null),(137373,44537,null,null,null),(7384,44537,null,null,null),(129134,44537,null,null,null),(121359,44537,null,null,null),(42069,44537,null,null,null),(132606,44537,null,null,null),(145447,44537,null,null,null),(30557,44537,null,null,null),(62496,44537,null,null,null),(115656,44537,null,null,null),(56468,44537,null,null,null),(45024,44537,null,null,null),(106443,44537,null,null,null),(9210,44537,null,null,null),(122864,44537,null,null,null),(71641,44537,null,null,null),(98692,44537,null,null,null),(39242,44537,null,null,null),(36265,44537,null,null,null),(52282,44537,null,null,null),(26537,44537,null,null,null),(9523,44537,null,null,null),(68858,44537,null,null,null),(38546,44537,null,null,null),(43045,44537,null,null,null),(144736,44537,null,null,null),(138245,44537,null,null,null),(118666,44537,null,null,null),(122993,44537,null,null,null),(9326,44537,null,null,null),(40872,44537,null,null,null),(78275,44537,null,null,null),(43716,44537,null,null,null),(140763,44537,null,null,null),(132921,44537,null,null,null),(94502,44537,null,null,null),(126177,44537,null,null,null),(116547,44537,null,null,null),(93516,44537,null,null,null),(89873,44537,null,null,null),(78031,44537,null,null,null),(71850,44537,null,null,null),(38296,44537,null,null,null),(10281,44537,null,null,null),(76914,44537,null,null,null),(4652,44537,null,null,null),(75977,44537,null,null,null),(38673,44537,null,null,null),(100227,44537,null,null,null),(10601,44537,null,null,null),(100039,44537,null,null,null),(15783,44537,null,null,null),(73966,44537,null,null,null),(88945,44537,null,null,null),(104976,44537,null,null,null),(101466,44537,null,null,null),(68676,44537,null,null,null),(2415,44537,null,null,null),(112072,44537,null,null,null),(19865,44537,null,null,null),(83033,44537,null,null,null),(90285,44537,null,null,null),(33663,44537,null,null,null),(36313,44537,null,null,null),(78228,44537,null,null,null),(110627,44537,null,null,null),(7680,44537,null,null,null),(136017,44537,null,null,null),(34627,44537,null,null,null),(116590,44537,null,null,null),(11992,44537,null,null,null),(35814,44537,null,null,null),(37217,44537,null,null,null),(61734,44537,null,null,null),(121726,44537,null,null,null),(31992,44537,null,null,null),(45417,44537,null,null,null),(138544,44537,null,null,null),(61972,44537,null,null,null),(134964,44537,null,null,null),(71444,44537,null,null,null),(30284,44537,null,null,null),(8700,44537,null,null,null),(100422,44537,null,null,null),(7445,44537,null,null,null),(37614,44537,null,null,null),(22081,44537,null,null,null),(61250,44537,null,null,null),(45190,44537,null,null,null),(4342,44537,null,null,null),(24805,44537,null,null,null),(93399,44537,null,null,null),(72164,44537,null,null,null),(112176,44537,null,null,null),(111302,44537,null,null,null),(67097,44537,null,null,null),(138750,44537,null,null,null),(102936,44537,null,null,null),(40355,44537,null,null,null),(30466,44537,null,null,null),(9159,44537,null,null,null),(35110,44537,null,null,null),(52780,44537,null,null,null),(36567,44537,null,null,null),(4975,44537,null,null,null),(3583,44537,null,null,null),(136192,44537,null,null,null),(73745,44537,null,null,null),(28144,44537,null,null,null),(43672,44537,null,null,null),(136956,44537,null,null,null),(108672,44537,null,null,null),(138791,44537,null,null,null),(44072,44537,null,null,null),(18379,44537,null,null,null),(34144,44537,null,null,null),(61508,44537,null,null,null),(89829,44537,null,null,null),(17451,44537,null,null,null),(53449,44537,null,null,null),(94596,44537,null,null,null),(29320,44537,null,null,null),(13835,44537,null,null,null),(125533,44537,null,null,null),(75350,44537,null,null,null),(132846,44537,null,null,null),(128063,44537,null,null,null),(16278,44537,null,null,null),(31255,44537,null,null,null),(33743,44537,null,null,null),(68724,44537,null,null,null),(128443,44537,null,null,null),(62638,44537,null,null,null),(44335,44537,null,null,null),(26709,44537,null,null,null),(61827,44537,null,null,null),(104245,44537,null,null,null),(84123,44537,null,null,null),(10314,44537,null,null,null),(75685,44537,null,null,null),(119155,44537,null,null,null),(8613,44537,null,null,null),(17119,44537,null,null,null),(105128,44537,null,null,null),(27946,44537,null,null,null),(37432,44537,null,null,null),(9059,44537,null,null,null),(9317,44537,null,null,null),(43099,44537,null,null,null),(77693,44537,null,null,null),(87766,44537,null,null,null),(51539,44537,null,null,null),(37228,44537,null,null,null),(109447,44537,null,null,null),(23065,44537,null,null,null),(124986,44537,null,null,null),(133006,44537,null,null,null),(81289,44537,null,null,null),(94797,44537,null,null,null),(41893,44537,null,null,null),(11543,44537,null,null,null),(7593,44537,null,null,null),(81852,44537,null,null,null),(58455,44537,null,null,null),(32882,44537,null,null,null),(119829,44537,null,null,null),(17990,44537,null,null,null),(15203,44537,null,null,null),(121142,44537,null,null,null),(68119,44537,null,null,null),(21698,44537,null,null,null),(97799,44537,null,null,null),(91792,44537,null,null,null),(82511,44537,null,null,null),(120652,44537,null,null,null),(14401,44537,null,null,null),(92203,44537,null,null,null),(6321,44537,null,null,null),(58659,44537,null,null,null),(42637,44537,null,null,null),(28281,44537,null,null,null),(39687,44537,null,null,null),(117124,44537,null,null,null),(108486,44537,null,null,null),(72832,44537,null,null,null),(144790,44537,null,null,null),(129089,44537,null,null,null),(43218,44537,null,null,null),(37920,44537,null,null,null),(31544,44537,null,null,null),(96882,44537,null,null,null),(10416,44537,null,null,null),(21592,44537,null,null,null),(13539,44537,null,null,null),(80871,44537,null,null,null),(2909,44537,null,null,null),(73287,44537,null,null,null),(42539,44537,null,null,null),(55931,44537,null,null,null),(51933,44537,null,null,null),(102158,44537,null,null,null),(82649,44537,null,null,null),(142279,44537,null,null,null),(75818,44537,null,null,null),(119273,44537,null,null,null),(35455,44537,null,null,null),(145198,44537,null,null,null),(133671,44537,null,null,null),(120263,44537,null,null,null),(67846,44537,null,null,null),(32939,44537,null,null,null),(81511,44537,null,null,null),(35160,44537,null,null,null),(65448,44537,null,null,null),(133237,44537,null,null,null),(76601,44537,null,null,null),(36075,44537,null,null,null),(32501,44537,null,null,null),(12549,44537,null,null,null),(129463,44537,null,null,null),(52181,44537,null,null,null),(43580,44537,null,null,null),(105371,44537,null,null,null),(66600,44537,null,null,null),(58750,44537,null,null,null),(98241,44537,null,null,null),(1398,44537,null,null,null),(65680,44537,null,null,null),(40672,44537,null,null,null),(38981,44537,null,null,null),(11189,44537,null,null,null),(67358,44537,null,null,null),(109501,44537,null,null,null),(75575,44537,null,null,null),(56337,44537,null,null,null),(20468,44537,null,null,null),(101157,44537,null,null,null),(145335,44537,null,null,null),(7666,44537,null,null,null),(132464,44537,null,null,null),(18600,44537,null,null,null),(57843,44537,null,null,null),(46970,44537,null,null,null),(95194,44537,null,null,null),(109148,44537,null,null,null),(107188,44537,null,null,null),(26495,44537,null,null,null),(39010,44537,null,null,null),(109739,44537,null,null,null),(116238,44537,null,null,null),(91503,44537,null,null,null),(140021,44537,null,null,null),(20819,44537,null,null,null),(37860,44537,null,null,null),(144583,44537,null,null,null),(52565,44537,null,null,null),(9231,44537,null,null,null),(85009,44537,null,null,null),(70509,44537,null,null,null),(43269,44537,null,null,null),(113109,44537,null,null,null),(112608,44537,null,null,null),(12431,44537,null,null,null),(131197,44537,null,null,null),(115911,44537,null,null,null),(19246,44537,null,null,null),(37536,44537,null,null,null),(30066,44537,null,null,null),(38964,44537,null,null,null),(39158,44537,null,null,null),(88597,44537,null,null,null),(17631,44537,null,null,null),(31625,44537,null,null,null),(5766,44537,null,null,null),(116442,44537,null,null,null),(34344,44537,null,null,null),(55435,44537,null,null,null),(47769,44537,null,null,null),(54195,44537,null,null,null),(144513,44537,null,null,null),(3263,44537,null,null,null),(99386,44537,null,null,null),(45069,44537,null,null,null),(114096,44537,null,null,null),(39610,44537,null,null,null),(91245,44537,null,null,null),(64412,44537,null,null,null),(47813,44537,null,null,null),(71700,44537,null,null,null),(8227,44537,null,null,null),(55768,44537,null,null,null),(3904,44537,null,null,null),(128629,44537,null,null,null),(34155,44537,null,null,null),(99742,44537,null,null,null),(23598,44537,null,null,null),(95101,44537,null,null,null),(92593,44537,null,null,null),(19102,44537,null,null,null),(8752,44537,null,null,null),(90548,44537,null,null,null),(32549,44537,null,null,null),(10013,44537,null,null,null),(136857,44537,null,null,null),(127025,44537,null,null,null),(47219,44537,null,null,null),(131325,44537,null,null,null),(6783,44537,null,null,null),(95643,44537,null,null,null),(28687,44537,null,null,null),(87095,44537,null,null,null),(1190,44537,null,null,null),(61925,44537,null,null,null),(100371,44537,null,null,null),(63757,44537,null,null,null),(68279,44537,null,null,null),(142938,44537,null,null,null),(106400,44537,null,null,null),(81609,44537,null,null,null),(69195,44537,null,null,null),(17772,44537,null,null,null),(57292,44537,null,null,null),(125779,44537,null,null,null),(99522,44537,null,null,null),(102419,44537,null,null,null),(123154,44537,null,null,null),(112649,44537,null,null,null),(18653,44537,null,null,null),(120602,44537,null,null,null),(49370,44537,null,null,null),(122155,44537,null,null,null),(19150,44537,null,null,null),(34665,44537,null,null,null),(49193,44537,null,null,null),(79964,44537,null,null,null),(109596,44537,null,null,null),(104442,44537,null,null,null),(41598,44537,null,null,null),(70184,44537,null,null,null),(136102,44537,null,null,null),(119363,44537,null,null,null),(76181,44537,null,null,null),(43630,44537,null,null,null),(9281,44537,null,null,null),(54511,44537,null,null,null),(25617,44537,null,null,null),(119457,44537,null,null,null),(110300,44537,null,null,null),(40918,44537,null,null,null),(14811,44537,null,null,null),(98283,44537,null,null,null),(42583,44537,null,null,null),(112368,44537,null,null,null),(36186,44537,null,null,null),(32276,44537,null,null,null),(38872,44537,null,null,null),(35902,44537,null,null,null),(113660,44537,null,null,null),(36977,44537,null,null,null),(10090,44537,null,null,null),(99996,44537,null,null,null),(7833,44537,null,null,null),(97881,44537,null,null,null),(144955,44537,null,null,null),(24849,44537,null,null,null),(72228,44537,null,null,null),(1904,44537,null,null,null),(97072,44537,null,null,null),(131104,44537,null,null,null),(37444,44537,null,null,null),(113906,44537,null,null,null),(35048,44537,null,null,null),(15393,44537,null,null,null),(8326,44537,null,null,null),(10799,44537,null,null,null),(93563,44537,null,null,null),(72998,44537,null,null,null),(43143,44537,null,null,null),(115053,44537,null,null,null),(34831,44537,null,null,null),(6643,44537,null,null,null),(7164,44537,null,null,null),(105261,44537,null,null,null),(25154,44537,null,null,null),(142827,44537,null,null,null),(96974,44537,null,null,null),(10185,44537,null,null,null),(34537,44537,null,null,null),(78555,44537,null,null,null),(141158,44537,null,null,null),(8039,44537,null,null,null),(144003,44537,null,null,null),(36658,44537,null,null,null),(46433,44537,null,null,null),(6788,44537,null,null,null),(72542,44537,null,null,null),(96099,44537,null,null,null),(66171,44537,null,null,null),(79501,44537,null,null,null),(132553,44537,null,null,null),(143001,44537,null,null,null),(22181,44537,null,null,null),(114589,44537,null,null,null),(70441,44537,null,null,null),(106155,44537,null,null,null),(49453,44537,null,null,null),(54914,44537,null,null,null),(118161,44537,null,null,null),(41557,44537,null,null,null),(41421,44537,null,null,null),(112475,44537,null,null,null),(130094,44537,null,null,null),(30843,44537,null,null,null),(10104,44537,null,null,null),(139298,44537,null,null,null),(127441,44537,null,null,null),(18700,44537,null,null,null),(67802,44537,null,null,null),(4806,44537,null,null,null),(28195,44537,null,null,null),(109701,44537,null,null,null),(88276,44537,null,null,null),(128013,44537,null,null,null),(78639,44537,null,null,null),(132966,44537,null,null,null),(40175,44537,null,null,null),(125952,44537,null,null,null),(45739,44537,null,null,null),(123994,44537,null,null,null),(69488,44537,null,null,null),(62883,44537,null,null,null),(50439,44537,null,null,null),(31296,44537,null,null,null),(43004,44537,null,null,null),(33972,44537,null,null,null),(22841,44537,null,null,null),(124847,44537,null,null,null),(84866,44537,null,null,null),(2596,44537,null,null,null),(39886,44537,null,null,null),(39651,44537,null,null,null),(141077,44537,null,null,null),(3653,44537,null,null,null),(127941,44537,null,null,null),(32128,44537,null,null,null),(41796,44537,null,null,null),(21938,44537,null,null,null),(124035,44537,null,null,null),(44932,44537,null,null,null),(34621,44537,null,null,null),(78980,44537,null,null,null),(42689,44537,null,null,null),(121187,44537,null,null,null),(43936,44537,null,null,null),(35539,44537,null,null,null),(52858,44537,null,null,null),(20431,44537,null,null,null),(88416,44537,null,null,null),(67310,44537,null,null,null),(52434,44537,null,null,null),(115959,44537,null,null,null),(99697,44537,null,null,null),(2960,44537,null,null,null),(124720,44537,null,null,null),(91145,44537,null,null,null),(137678,44537,null,null,null),(126986,44537,null,null,null),(42169,44537,null,null,null),(29958,44537,null,null,null),(129748,44537,null,null,null),(32173,44537,null,null,null),(108954,44537,null,null,null),(132072,44537,null,null,null),(48826,44537,null,null,null),(135909,44537,null,null,null),(128353,44537,null,null,null),(106069,44537,null,null,null),(3796,44537,null,null,null),(81894,44537,null,null,null),(126352,44537,null,null,null),(16710,44537,null,null,null),(4952,44537,null,null,null),(18462,44537,null,null,null),(52528,44537,null,null,null),(114742,44537,null,null,null),(102647,44537,null,null,null),(32404,44537,null,null,null),(112567,44537,null,null,null),(68170,44537,null,null,null),(83150,44537,null,null,null),(68216,44537,null,null,null),(75493,44537,null,null,null),(37964,44537,null,null,null),(121093,44537,null,null,null),(43083,44537,null,null,null),(11799,44537,null,null,null),(126051,44537,null,null,null),(31543,44537,null,null,null),(9885,44537,null,null,null),(35855,44537,null,null,null),(84411,44537,null,null,null),(38017,44537,null,null,null),(15152,44537,null,null,null),(12138,44537,null,null,null),(64694,44537,null,null,null),(118522,44537,null,null,null),(93845,44537,null,null,null),(27009,44537,null,null,null),(11321,44537,null,null,null),(69405,44537,null,null,null),(54675,44537,null,null,null),(124940,44537,null,null,null),(92255,44537,null,null,null),(71172,44537,null,null,null),(103762,44537,null,null,null),(63969,44537,null,null,null),(84459,44537,null,null,null),(47413,44537,null,null,null),(75303,44537,null,null,null),(126220,44537,null,null,null),(103224,44537,null,null,null),(53093,44537,null,null,null),(69615,44537,null,null,null),(135970,44537,null,null,null),(21385,44537,null,null,null),(40314,44537,null,null,null),(22486,44537,null,null,null),(3020,44537,null,null,null),(143280,44537,null,null,null),(110573,44537,null,null,null),(120958,44537,null,null,null),(117922,44537,null,null,null),(54820,44537,null,null,null),(40856,44537,null,null,null),(143659,44537,null,null,null),(46842,44537,null,null,null),(25664,44537,null,null,null),(120085,44537,null,null,null),(70049,44537,null,null,null),(32610,44537,null,null,null),(105173,44537,null,null,null),(125071,44537,null,null,null),(44870,44537,null,null,null),(26833,44537,null,null,null),(40605,44537,null,null,null),(109827,44537,null,null,null),(27994,44537,null,null,null),(12223,44537,null,null,null),(62235,44537,null,null,null),(118112,44537,null,null,null),(74291,44537,null,null,null),(21735,44537,null,null,null),(68768,44537,null,null,null),(6504,44537,null,null,null),(11496,44537,null,null,null),(67638,44537,null,null,null),(102698,44537,null,null,null),(99566,44537,null,null,null),(86026,44537,null,null,null),(73229,44537,null,null,null),(121476,44537,null,null,null),(47124,44537,null,null,null),(17736,44537,null,null,null),(88380,44537,null,null,null),(77065,44537,null,null,null),(6744,44537,null,null,null),(18183,44537,null,null,null),(120842,44537,null,null,null),(117493,44537,null,null,null),(15875,44537,null,null,null),(14287,44537,null,null,null),(101109,44537,null,null,null),(89578,44537,null,null,null),(93119,44537,null,null,null),(93939,44537,null,null,null),(90500,44537,null,null,null),(38159,44537,null,null,null),(119670,44537,null,null,null),(30423,44537,null,null,null),(103903,44537,null,null,null),(133795,44537,null,null,null),(80966,44537,null,null,null),(144874,44537,null,null,null),(128303,44537,null,null,null),(37655,44537,null,null,null),(143374,44537,null,null,null),(57975,44537,null,null,null),(1970,44537,null,null,null),(89527,44537,null,null,null),(53726,44537,null,null,null),(10564,44537,null,null,null),(138284,44537,null,null,null),(13592,44537,null,null,null),(11950,44537,null,null,null),(51138,44537,null,null,null),(44476,44537,null,null,null),(38392,44537,null,null,null),(77608,44537,null,null,null),(54038,44537,null,null,null),(66860,44537,null,null,null),(35308,44537,null,null,null),(74728,44537,null,null,null),(32458,44537,null,null,null),(13425,44537,null,null,null),(78880,44537,null,null,null),(40620,44537,null,null,null),(49640,44537,null,null,null),(56106,44537,null,null,null),(118990,44537,null,null,null),(105570,44537,null,null,null),(13825,44537,null,null,null),(110350,44537,null,null,null),(9841,44537,null,null,null),(57661,44537,null,null,null),(72033,44537,null,null,null),(7885,44537,null,null,null),(33331,44537,null,null,null),(110900,44537,null,null,null),(48334,44537,null,null,null),(18564,44537,null,null,null),(104386,44537,null,null,null),(70605,44537,null,null,null),(48961,44537,null,null,null),(2065,44537,null,null,null),(17869,44537,null,null,null),(41524,44537,null,null,null),(56905,44537,null,null,null),(86531,44537,null,null,null),(75006,44537,null,null,null),(92644,44537,null,null,null),(35335,44537,null,null,null),(50774,44537,null,null,null),(17314,44537,null,null,null),(46632,44537,null,null,null),(8720,44537,null,null,null),(80714,44537,null,null,null),(76859,44537,null,null,null),(89179,44537,null,null,null),(99106,44537,null,null,null),(60852,44537,null,null,null),(48201,44537,null,null,null),(10763,44537,null,null,null),(82556,44537,null,null,null),(129006,44537,null,null,null),(17258,44537,null,null,null),(31736,44537,null,null,null),(27850,44537,null,null,null),(94341,44537,null,null,null),(69269,44537,null,null,null),(14912,44537,null,null,null),(62450,44537,null,null,null),(76769,44537,null,null,null),(12082,44537,null,null,null),(74883,44537,null,null,null),(15778,44537,null,null,null),(9676,44537,null,null,null),(113819,44537,null,null,null),(26412,44537,null,null,null),(9873,44537,null,null,null),(143467,44537,null,null,null),(9721,44537,null,null,null),(61109,44537,null,null,null),(114188,44537,null,null,null),(53671,44537,null,null,null),(129881,44537,null,null,null),(136898,44537,null,null,null),(42501,44537,null,null,null),(1760,44537,null,null,null),(112744,44537,null,null,null),(41912,44537,null,null,null),(114323,44537,null,null,null),(66962,44537,null,null,null),(33452,44537,null,null,null),(141674,44537,null,null,null),(142742,44537,null,null,null),(83490,44537,null,null,null),(41694,44537,null,null,null),(13291,44537,null,null,null),(12276,44537,null,null,null),(46886,44537,null,null,null),(7756,44537,null,null,null),(66805,44537,null,null,null),(131917,44537,null,null,null),(37291,44537,null,null,null),(47716,44537,null,null,null),(131727,44537,null,null,null),(107377,44537,null,null,null),(7320,44537,null,null,null),(77015,44537,null,null,null),(39514,44537,null,null,null),(5434,44537,null,null,null),(1778,44537,null,null,null),(35899,44537,null,null,null),(104037,44537,null,null,null),(75894,44537,null,null,null),(36833,44537,null,null,null),(98475,44537,null,null,null),(113000,44537,null,null,null),(135198,44537,null,null,null),(79754,44537,null,null,null),(44553,44537,null,null,null),(11458,44537,null,null,null),(11109,44537,null,null,null),(17934,44537,null,null,null),(13443,44537,null,null,null),(140478,44537,null,null,null),(25701,44537,null,null,null),(46174,44537,null,null,null),(96222,44537,null,null,null),(30710,44537,null,null,null),(12482,44537,null,null,null),(93986,44537,null,null,null),(71896,44537,null,null,null),(122516,44537,null,null,null),(103454,44537,null,null,null),(127975,44537,null,null,null),(35288,44537,null,null,null),(19668,44537,null,null,null),(82338,44537,null,null,null),(78793,44537,null,null,null),(38471,44537,null,null,null),(7531,44537,null,null,null),(121829,44537,null,null,null),(143157,44537,null,null,null),(31212,44537,null,null,null),(141955,44537,null,null,null),(145149,44537,null,null,null),(106594,44537,null,null,null),(59602,44537,null,null,null),(42021,44537,null,null,null),(115383,44537,null,null,null),(45913,44537,null,null,null),(84699,44537,null,null,null),(32348,44537,null,null,null),(80298,44537,null,null,null),(15114,44537,null,null,null),(55164,44537,null,null,null),(61394,44537,null,null,null),(15632,44537,null,null,null),(57509,44537,null,null,null),(97501,44537,null,null,null),(117406,44537,null,null,null),(16748,44537,null,null,null),(94036,44537,null,null,null),(7402,44537,null,null,null),(116278,44537,null,null,null),(37329,44537,null,null,null),(78178,44537,null,null,null),(71127,44537,null,null,null),(40817,44537,null,null,null),(32634,44537,null,null,null),(29911,44537,null,null,null),(9365,44537,null,null,null),(41637,44537,null,null,null),(17071,44537,null,null,null),(8378,44537,null,null,null),(23644,44537,null,null,null),(87281,44537,null,null,null),(21840,44537,null,null,null),(39561,44537,null,null,null),(59862,44537,null,null,null),(16977,44537,null,null,null),(16418,44537,null,null,null),(48386,44537,null,null,null),(138613,44537,null,null,null),(106114,44537,null,null,null),(20779,44537,null,null,null),(133514,44537,null,null,null),(92019,44537,null,null,null),(5974,44537,null,null,null),(73698,44537,null,null,null),(44346,44537,null,null,null),(17548,44537,null,null,null),(145376,44537,null,null,null),(126943,44537,null,null,null),(36318,44537,null,null,null),(97919,44537,null,null,null),(29075,44537,null,null,null),(94144,44537,null,null,null),(132793,44537,null,null,null),(144630,44537,null,null,null),(139562,44537,null,null,null),(98825,44537,null,null,null),(98120,44537,null,null,null),(51243,44537,null,null,null),(24145,44537,null,null,null),(22556,44537,null,null,null),(142220,44537,null,null,null),(13377,44537,null,null,null),(94753,44537,null,null,null),(47175,44537,null,null,null),(25383,44537,null,null,null),(11269,44537,null,null,null),(55120,44537,null,null,null),(29864,44537,null,null,null),(22029,44537,null,null,null),(53926,44537,null,null,null),(18463,44537,null,null,null),(123241,44537,null,null,null),(21002,44537,null,null,null),(10236,44537,null,null,null),(96325,44537,null,null,null),(111873,44537,null,null,null),(107766,44537,null,null,null),(92831,44537,null,null,null),(24356,44537,null,null,null),(109930,44537,null,null,null),(17822,44537,null,null,null),(119027,44537,null,null,null),(127359,44537,null,null,null),(110090,44537,null,null,null),(15018,44537,null,null,null),(90389,44537,null,null,null),(11282,44537,null,null,null),(131776,44537,null,null,null),(60537,44537,null,null,null),(23626,44537,null,null,null),(49686,44537,null,null,null),(41114,44537,null,null,null),(113200,44537,null,null,null),(70360,44537,null,null,null),(26873,44537,null,null,null),(8832,44537,null,null,null),(87414,44537,null,null,null),(61602,44537,null,null,null),(144195,44537,null,null,null),(126098,44537,null,null,null),(74083,44537,null,null,null),(59985,44537,null,null,null),(31065,44537,null,null,null),(16611,44537,null,null,null),(35107,44537,null,null,null),(48878,44537,null,null,null),(64109,44537,null,null,null),(28732,44537,null,null,null),(122669,44537,null,null,null),(105528,44537,null,null,null),(113449,44537,null,null,null),(143611,44537,null,null,null),(33122,44537,null,null,null),(45259,44537,null,null,null),(26315,44537,null,null,null),(113056,44537,null,null,null),(93757,44537,null,null,null),(33979,44537,null,null,null),(10192,44537,null,null,null),(131601,44537,null,null,null),(19471,44537,null,null,null),(14824,44537,null,null,null),(67205,44537,null,null,null),(141246,44537,null,null,null),(132020,44537,null,null,null),(51028,44537,null,null,null),(98192,44537,null,null,null),(90200,44537,null,null,null),(7079,44537,null,null,null),(6943,44537,null,null,null),(127154,44537,null,null,null),(35965,44537,null,null,null),(68012,44537,null,null,null),(120319,44537,null,null,null),(22749,44537,null,null,null),(38497,44537,null,null,null),(114235,44537,null,null,null),(137631,44537,null,null,null),(124126,44537,null,null,null),(56069,44537,null,null,null),(120808,44537,null,null,null),(18738,44537,null,null,null),(83732,44537,null,null,null),(31743,44537,null,null,null),(27301,44537,null,null,null),(137229,44537,null,null,null),(44508,44537,null,null,null),(36051,44537,null,null,null),(60457,44537,null,null,null),(67252,44537,null,null,null),(89023,44537,null,null,null),(44748,44537,null,null,null),(133842,44537,null,null,null),(115696,44537,null,null,null),(25885,44537,null,null,null),(18785,44537,null,null,null),(101298,44537,null,null,null),(2638,44537,null,null,null),(129826,44537,null,null,null),(21116,44537,null,null,null),(106201,44537,null,null,null),(139523,44537,null,null,null),(103705,44537,null,null,null),(39780,44537,null,null,null),(14727,44537,null,null,null),(18151,44537,null,null,null),(59503,44537,null,null,null),(124316,44537,null,null,null),(36888,44537,null,null,null),(104336,44537,null,null,null),(77990,44537,null,null,null),(55714,44537,null,null,null),(44379,44537,null,null,null),(140716,44537,null,null,null),(12817,44537,null,null,null),(5304,44537,null,null,null),(134432,44537,null,null,null),(39793,44537,null,null,null),(13500,44537,null,null,null),(24495,44537,null,null,null),(81007,44537,null,null,null),(91879,44537,null,null,null),(45696,44537,null,null,null),(19195,44537,null,null,null),(126896,44537,null,null,null),(142066,44537,null,null,null),(134243,44537,null,null,null),(128223,44537,null,null,null),(131396,44537,null,null,null),(38215,44537,null,null,null),(9773,44537,null,null,null),(101201,44537,null,null,null),(93176,44537,null,null,null),(73100,44537,null,null,null),(1857,44537,null,null,null),(55671,44537,null,null,null),(6692,44537,null,null,null),(15361,44537,null,null,null),(52637,44537,null,null,null),(26452,44537,null,null,null),(5151,44537,null,null,null),(123097,44537,null,null,null),(37658,44537,null,null,null),(9825,44537,null,null,null),(40647,44537,null,null,null),(13671,44537,null,null,null),(57341,44537,null,null,null),(31954,44537,null,null,null),(121870,44537,null,null,null),(104695,44537,null,null,null),(111347,44537,null,null,null),(34953,44537,null,null,null),(85283,44537,null,null,null),(79416,44537,null,null,null),(57603,44537,null,null,null),(16809,44537,null,null,null),(44217,44537,null,null,null),(35001,44537,null,null,null),(126758,44537,null,null,null),(63402,44537,null,null,null),(43575,44537,null,null,null),(61697,44537,null,null,null),(107335,44537,null,null,null),(60500,44537,null,null,null),(58094,44537,null,null,null),(24934,44537,null,null,null),(15732,44537,null,null,null),(46382,44537,null,null,null),(45112,44537,null,null,null),(133330,44537,null,null,null),(29128,44537,null,null,null),(67536,44537,null,null,null),(39836,44537,null,null,null),(11052,44537,null,null,null),(57445,44537,null,null,null),(128588,44537,null,null,null),(131545,44537,null,null,null),(58047,44537,null,null,null),(54560,44537,null,null,null),(6147,44537,null,null,null),(75157,44537,null,null,null),(111679,44537,null,null,null),(100167,44537,null,null,null),(84752,44537,null,null,null),(13725,44537,null,null,null),(23919,44537,null,null,null),(141341,44537,null,null,null),(54092,44537,null,null,null),(4389,44537,null,null,null),(6699,44537,null,null,null),(103560,44537,null,null,null),(56530,44537,null,null,null),(41969,44537,null,null,null),(39648,44537,null,null,null),(135147,44537,null,null,null),(39934,44537,null,null,null),(88104,44537,null,null,null),(56612,44537,null,null,null),(140160,44537,null,null,null),(42260,44537,null,null,null),(139982,44537,null,null,null),(139896,44537,null,null,null),(98903,44537,null,null,null),(24594,44537,null,null,null),(90341,44537,null,null,null),(46585,44537,null,null,null),(94901,44537,null,null,null),(114693,44537,null,null,null),(34716,44537,null,null,null),(114520,44537,null,null,null),(7795,44537,null,null,null),(19525,44537,null,null,null),(119316,44537,null,null,null),(7617,44537,null,null,null),(114355,44537,null,null,null),(111146,44537,null,null,null),(119904,44537,null,null,null),(15311,44537,null,null,null),(7037,44537,null,null,null),(36698,44537,null,null,null),(87318,44537,null,null,null),(95457,44537,null,null,null),(85103,44537,null,null,null),(133202,44537,null,null,null),(46079,44537,null,null,null),(122577,44537,null,null,null),(36004,44537,null,null,null),(26271,44537,null,null,null),(66429,44537,null,null,null),(62837,44537,null,null,null),(35413,44537,null,null,null),(11787,44537,null,null,null),(64565,44537,null,null,null),(53341,44537,null,null,null),(97701,44537,null,null,null),(21344,44537,null,null,null),(63718,44537,null,null,null),(32972,44537,null,null,null),(32109,44537,null,null,null),(27501,44537,null,null,null),(139024,44537,null,null,null),(14769,44537,null,null,null),(98865,44537,null,null,null),(33881,44537,null,null,null),(100809,44537,null,null,null),(117204,44537,null,null,null),(137136,44537,null,null,null),(13632,44537,null,null,null),(14231,44537,null,null,null),(56381,44537,null,null,null),(21430,44537,null,null,null),(13751,44537,null,null,null),(105089,44537,null,null,null),(18739,44537,null,null,null),(59907,44537,null,null,null),(43717,44537,null,null,null),(78358,44537,null,null,null),(76078,44537,null,null,null),(39465,44537,null,null,null),(59445,44537,null,null,null),(40062,44537,null,null,null),(121641,44537,null,null,null),(8930,44537,null,null,null),(134345,44537,null,null,null),(37493,44537,null,null,null),(131282,44537,null,null,null),(144048,44537,null,null,null),(84792,44537,null,null,null),(128889,44537,null,null,null),(65828,44537,null,null,null),(97660,44537,null,null,null),(41748,44537,null,null,null),(20238,44537,null,null,null),(94941,44537,null,null,null),(47678,44537,null,null,null),(42378,44537,null,null,null),(78738,44537,null,null,null),(11507,44537,null,null,null),(19618,44537,null,null,null),(123542,44537,null,null,null),(25830,44537,null,null,null),(139645,44537,null,null,null),(88149,44537,null,null,null),(10560,44537,null,null,null),(114427,44537,null,null,null),(108861,44537,null,null,null),(134807,44537,null,null,null),(35716,44537,null,null,null),(69780,44537,null,null,null),(37816,44537,null,null,null),(34106,44537,null,null,null),(104830,44537,null,null,null),(74684,44537,null,null,null),(71752,44537,null,null,null),(33936,44537,null,null,null),(20961,44537,null,null,null),(130582,44537,null,null,null),(40987,44537,null,null,null),(34406,44537,null,null,null),(8082,44537,null,null,null),(16287,44537,null,null,null),(3314,44537,null,null,null),(36410,44537,null,null,null),(105632,44537,null,null,null),(128537,44537,null,null,null),(63628,44537,null,null,null),(32263,44537,null,null,null),(37577,44537,null,null,null),(50556,44537,null,null,null),(14428,44537,.................

[lukisec]

Anyone can help?

[vso]

Could you please be so kind and try disabling housekeeper, does it help ?

[lukisec]

Hi,

I disabled housekeeping but it doesn't help, still the same:

41553:20180515:113008.634 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (14422,98944,null,null,null),(144069,98944,null,null,null),(65922,98944,null,null,null),(89839,98944,null,null,null),(85715,98944,null,null,null),(45096,98944,null,null,null),(60319,98944,null,null,null),(19028,98944,null,null,null),(141306,98944,null,null,null),(5872,98944,null,null,null),(78659,98944,null,null,null),(28950,98944,null,null,null),(75880,98944,null,null,null),(15648,98944,null,null,null),(109415,98944,null,null,null),(10631,98944,null,null,null),(66464,98944,null,null,null),(54754,98944,null,null,null),(62560,98944,null,null,null),(17562,98944,null,null,null),(94821,98944,null,null,null),(43339,98944,null,null,null),(20708,98944,null,null,null),(43915,98944,null,null,null),(113504,98944,null,null,null),(10973,98944,null,null,null),(8100,98944,null,null,null),(60899,98944,null,null,null),(29504,98944,null,null,null),(13858,98944,null,null,null),(133628,98944,null,null,null),(10031,98944,null,null,null),(35374,98944,null,null,null),(15042,98944,null,null,null),(142429,98944,null,null,null),(140220,98944,null,null,null),(105393,98944,null,null,null),(83687,98944,null,null,null),(30632,98944,null,null,null),(73643,98944,null,null,null),(8337,98944,null,null,null),(7239,98944,null,null,null),(97584,98944,null,null,null),(117000,98944,null,null,null),(13251,98944,null,null,null),(130,98944,null,null,null),(125358,98944,null,null,null),(65382,98944,null,null,null),(69208,98944,null,null,null),(131412,98944,null,null,null),(117560,98944,null,null,null),(76987,98944,null,null,null),(16771,98944,null,null,null),(44107,98944,null,null,null),(107094,98944,null,null,null),(107685,98944,null,null,null),(86275,98944,null,null,null),(91501,98944,null,null,null),(95917,98944,null,null,null),(120341,98944,null,null,null),(17894,98944,null,null,null),(138564,98944,null,null,null),(12668,98944,null,null,null),(40511,98944,null,null,null),(57551,98944,null,null,null),(10390,98944,null,null,null),(131,98943,null,null,null),(3815,98944,null,null,null),(1133,98944,null,null,null),(7547,98944,null,null,null),(17315,98944,null,null,null),(16200,98944,null,null,null),(12089,98944,null,null,null),(84262,98944,null,null,null),(35924,98944,null,null,null),(118683,98944,null,null,null),(87927,98944,null,null,null),(6434,98944,null,null,null),(112923,98944,null,null,null),(9803,98944,null,null,null),(31126,98944,null,null,null),(95394,98944,null,null,null),(41099,98944,null,null,null),(124240,98944,null,null,null),(24107,98944,null,null,null),(12866,98944,null,null,null),(8653,98944,null,null,null),(66195,98944,null,null,null),(9230,98944,null,null,null),(19586,98944,null,null,null),(2488,98944,null,null,null),(60322,98944,null,null,null),(25248,98944,null,null,null),(12280,98944,null,null,null),(128700,98944,null,null,null),(61454,98944,null,null,null),(18484,98944,null,null,null),(139661,98944,null,null,null),(132518,98944,null,null,null),(6965,98944,null,null,null),(15749,98944,null,null,null),(82548,98944,null,null,null),(103047,98944,null,null,null),(31317,98944,null,null,null),(133073,98944,null,null,null),(80328,98944,null,null,null),(98607,98944,null,null,null),(23847,98944,null,null,null),(20161,98944,null,null,null),(11526,98944,null,null,null),(90388,98944,null,null,null),(48062,98944,null,null,null),(90942,98944,null,null,null),(92454,98944,null,null,null),(49731,98944,null,null,null),(19496,98944,null,null,null),(112336,98944,null,null,null),(38854,98944,null,null,null),(91900,98944,null,null,null),(3161,98944,null,null,null),(140778,98944,null,null,null),(21504,98944,null,null,null),(134153,98944,null,null,null);

[vso]

Please do show create table problem;
show create table event_recovery;

[lukisec]

MariaDB [zabbix]> show create table event_recovery;
+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| event_recovery | CREATE TABLE `event_recovery` (
`eventid` bigint(20) unsigned NOT NULL,
`r_eventid` bigint(20) unsigned NOT NULL,
`c_eventid` bigint(20) unsigned DEFAULT NULL,
`correlationid` bigint(20) unsigned DEFAULT NULL,
`userid` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`eventid`),
KEY `event_recovery_1` (`r_eventid`),
KEY `event_recovery_2` (`c_eventid`),
CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,
CONSTRAINT `c_event_recovery_2` FOREIGN KEY (`r_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,
CONSTRAINT `c_event_recovery_3` FOREIGN KEY (`c_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
+----------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.09 sec)


MariaDB [zabbix]> show create table problem;
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| problem | CREATE TABLE `problem` (
`eventid` bigint(20) unsigned NOT NULL,
`source` int(11) NOT NULL DEFAULT '0',
`object` int(11) NOT NULL DEFAULT '0',
`objectid` bigint(20) unsigned NOT NULL DEFAULT '0',
`clock` int(11) NOT NULL DEFAULT '0',
`ns` int(11) NOT NULL DEFAULT '0',
`r_eventid` bigint(20) unsigned DEFAULT NULL,
`r_clock` int(11) NOT NULL DEFAULT '0',
`r_ns` int(11) NOT NULL DEFAULT '0',
`correlationid` bigint(20) unsigned DEFAULT NULL,
`userid` bigint(20) unsigned DEFAULT NULL,
PRIMARY KEY (`eventid`),
KEY `problem_1` (`source`,`object`,`objectid`),
KEY `problem_2` (`r_clock`),
KEY `problem_3` (`r_eventid`),
CONSTRAINT `c_problem_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE,
CONSTRAINT `c_problem_2` FOREIGN KEY (`r_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |
+---------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[vso]

Foreign keys looks fine, could you please increase log level of history syncer and attach log.
zabbix_server -R log_level_increase='history syncer'

[lukisec]

41554:20180515:115320.203 query [txnlev:1] [insert into history_str (itemid,clock,ns,value) values (55231,1526378000,197206251,'enet0'),(27285,1526378000,197206251,'avo-rou-1');
]
 41554:20180515:115320.203 query [txnlev:1] [insert into history_uint (itemid,clock,ns,value) values (65720,1526378000,157219083,142600),(65480,1526378000,161658046,0),(65180,1526378000,163927078,11248623616),(64580,1526378000,164063580,1070974509056),(59240,1526378000,165324598,1628459008),(48080,1526378000,166010608,0),(51800,1526378000,166209611,0),(52220,1526378000,166484015,0),(53900,1526378000,166810319,0),(52100,1526378000,166941721,0),(56960,1526378000,167591830,3104),(55220,1526378000,167967236,842968),(63980,1526378000,168345241,192397312),(64400,1526378000,168563644,118115016704),(36920,1526378000,168882449,0),(36500,1526378000,170784876,0),(59330,1526378000,170842477,0),(66260,1526378000,171426185,1121562624),(58400,1526378000,171721589,0),(59120,1526378000,172605802,1),(48140,1526378000,172750104,2320),(64640,1526378000,172844405,0),(65540,1526378000,173182110,107001663488),(51920,1526378000,173462714,19744),(51500,1526378000,174550929,9480),(52700,1526378000,174768132,98456),(35180,1526378000,176959063,0),(64760,1526378000,178615687,0),(47960,1526378000,180139909,11616),(65000,1526378000,182178838,0);
]
 41554:20180515:115320.204 query [txnlev:1] [insert into history_text (itemid,clock,ns,value) values (29818,1526378000,197206251,'ZyWALL 2 Plus');
]
 41554:20180515:115320.204 query [txnlev:1] [commit;]
 41554:20180515:115320.205 End of zbx_history_add_values()
 41554:20180515:115320.205 End of DCmass_add_history()
 41554:20180515:115320.205 query [txnlev:1] [begin;]
 41554:20180515:115320.205 In DCmass_update_items()
 41554:20180515:115320.205 End of DCmass_update_items()
 41554:20180515:115320.205 In DCmass_update_triggers()
 41554:20180515:115320.205 In zbx_link_triggers_with_functions() trigger_order_num:5
 41554:20180515:115320.205 In substitute_simple_macros() data:'{17181}<20'
 41554:20180515:115320.205 End substitute_simple_macros() data:'{17181}<20'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{25994}=0'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{25994}=0'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{26108}<209715200'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{26108}<209715200'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{27842}<20M'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{27842}<20M'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{28001}<5'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{28001}<5'
 41554:20180515:115320.206 End of zbx_link_triggers_with_functions() triggers_func_pos_num:5
 41554:20180515:115320.206 In evaluate_expressions() tr_num:5
 41554:20180515:115320.206 In substitute_simple_macros() data:'{17181}<20'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{17181}<20'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{25994}=0'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{25994}=0'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{26108}<209715200'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{26108}<209715200'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{27842}<20M'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{27842}<20M'
 41554:20180515:115320.206 In substitute_simple_macros() data:'{28001}<5'
 41554:20180515:115320.206 End substitute_simple_macros() data:'{28001}<5'
 41554:20180515:115320.206 In substitute_functions()
 41554:20180515:115320.206 In zbx_extract_functionids() tr_num:5
 41554:20180515:115320.206 End of zbx_extract_functionids() functionids_num:5
 41554:20180515:115320.206 In zbx_populate_function_items() functionids_num:5
 41554:20180515:115320.206 End of zbx_populate_function_items() ifuncs_num:5
 41554:20180515:115320.206 In zbx_evaluate_item_functions() funcs_num:5
 41554:20180515:115320.206 In evaluate_function() function:'Windows.Heitel:net.tcp.listen[5500].last(0)'
 41554:20180515:115320.206 In evaluate_LAST()
 41554:20180515:115320.206 In get_function_parameter_int() parameters:'0' Nparam:1
 41554:20180515:115320.206 In substitute_simple_macros() data:'0'
 41554:20180515:115320.206 get_function_parameter_int() type:sec value:0
 41554:20180515:115320.206 End of get_function_parameter_int():SUCCEED
 41554:20180515:115320.206 In zbx_vc_get_value_range() itemid:59120 value_type:3 seconds:0 count:1 timestamp:1526378000
 41554:20180515:115320.206 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
 41554:20180515:115320.207 End of evaluate_LAST():SUCCEED
 41554:20180515:115320.207 End of evaluate_function():SUCCEED value:'1'
 41554:20180515:115320.207 In evaluate_function() function:'Windows.KRONOS-CA:vm.memory.size[free].last(0)'
 41554:20180515:115320.207 In evaluate_LAST()
 41554:20180515:115320.207 In get_function_parameter_int() parameters:'0' Nparam:1
 41554:20180515:115320.207 In substitute_simple_macros() data:'0'
 41554:20180515:115320.207 get_function_parameter_int() type:sec value:0
 41554:20180515:115320.207 End of get_function_parameter_int():SUCCEED
 41554:20180515:115320.207 In zbx_vc_get_value_range() itemid:59240 value_type:3 seconds:0 count:1 timestamp:1526378000
 41554:20180515:115320.207 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
 41554:20180515:115320.207 End of evaluate_LAST():SUCCEED
 41554:20180515:115320.207 End of evaluate_function():SUCCEED value:'1628459008'
 41554:20180515:115320.207 In evaluate_function() function:'Linux.Portal:vfs.fs.size[/,pfree].last(0)'
 41554:20180515:115320.207 In evaluate_LAST()
 41554:20180515:115320.207 In get_function_parameter_int() parameters:'0' Nparam:1
 41554:20180515:115320.207 In substitute_simple_macros() data:'0'
 41554:20180515:115320.207 get_function_parameter_int() type:sec value:0
 41554:20180515:115320.207 End of get_function_parameter_int():SUCCEED
 41554:20180515:115320.207 In zbx_vc_get_value_range() itemid:65660 value_type:0 seconds:0 count:1 timestamp:1526378000
 41554:20180515:115320.207 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
 41554:20180515:115320.207 End of evaluate_LAST():SUCCEED
 41554:20180515:115320.207 End of evaluate_function():SUCCEED value:'88.123073'
 41554:20180515:115320.207 In evaluate_function() function:'Linux.VM:vm.memory.size[available].last(0)'
 41554:20180515:115320.207 In evaluate_LAST()
 41554:20180515:115320.207 In get_function_parameter_int() parameters:'0' Nparam:1
 41554:20180515:115320.207 In substitute_simple_macros() data:'0'
 41554:20180515:115320.207 get_function_parameter_int() type:sec value:0
 41554:20180515:115320.207 End of get_function_parameter_int():SUCCEED
 41554:20180515:115320.207 In zbx_vc_get_value_range() itemid:65180 value_type:3 seconds:0 count:1 timestamp:1526378000
 41554:20180515:115320.207 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
 41554:20180515:115320.207 End of evaluate_LAST():SUCCEED
 41554:20180515:115320.207 End of evaluate_function():SUCCEED value:'11248623616'
 41554:20180515:115320.207 In evaluate_function() function:'Linux.Proxy:vfs.fs.inode[/var/spool/squid,pfree].last(0)'
 41554:20180515:115320.207 In evaluate_LAST()
 41554:20180515:115320.207 In get_function_parameter_int() parameters:'0' Nparam:1
 41554:20180515:115320.207 In substitute_simple_macros() data:'0'
 41554:20180515:115320.207 get_function_parameter_int() type:sec value:0
 41554:20180515:115320.208 End of get_function_parameter_int():SUCCEED
 41554:20180515:115320.208 In zbx_vc_get_value_range() itemid:33620 value_type:0 seconds:0 count:1 timestamp:1526378000
 41554:20180515:115320.208 End of zbx_vc_get_value_range():SUCCEED count:1 cached:1
 41554:20180515:115320.208 End of evaluate_LAST():SUCCEED
 41554:20180515:115320.208 End of evaluate_function():SUCCEED value:'95.90445'
 41554:20180515:115320.208 End of zbx_evaluate_item_functions()
 41554:20180515:115320.208 In zbx_substitute_functions_results() ifuncs_num:5 tr_num:5
 41554:20180515:115320.208 zbx_substitute_functions_results() expression[0]:'{17181}<20' => '95.90445<20'
 41554:20180515:115320.208 zbx_substitute_functions_results() expression[1]:'{25994}=0' => '1=0'
 41554:20180515:115320.208 zbx_substitute_functions_results() expression[2]:'{26108}<209715200' => '1628459008<209715200'
 41554:20180515:115320.208 zbx_substitute_functions_results() expression[3]:'{27842}<20M' => '11248623616<20M'
 41554:20180515:115320.208 zbx_substitute_functions_results() expression[4]:'{28001}<5' => '88.123073<5'
 41554:20180515:115320.208 End of zbx_substitute_functions_results()
 41554:20180515:115320.208 End of substitute_functions()
 41554:20180515:115320.208 In evaluate() expression:'95.90445<20'
 41554:20180515:115320.208 End of evaluate() value:0.000000
 41554:20180515:115320.208 In evaluate() expression:'1=0'
 41554:20180515:115320.208 End of evaluate() value:0.000000
 41554:20180515:115320.208 In evaluate() expression:'1628459008<209715200'
 41554:20180515:115320.208 End of evaluate() value:0.000000
 41554:20180515:115320.208 In evaluate() expression:'11248623616<20M'
 41554:20180515:115320.208 End of evaluate() value:0.000000
 41554:20180515:115320.208 In evaluate() expression:'88.123073<5'
 41554:20180515:115320.208 End of evaluate() value:0.000000
 41554:20180515:115320.208 End of evaluate_expressions()
 41554:20180515:115320.208 In zbx_process_triggers() values_num:5
 41554:20180515:115320.208 In zbx_process_trigger() triggerid:17557 value:0(0) new_value:3
 41554:20180515:115320.208 End of zbx_process_trigger():FAIL flags:0
 41554:20180515:115320.208 In zbx_process_trigger() triggerid:24547 value:0(0) new_value:3
 41554:20180515:115320.208 End of zbx_process_trigger():FAIL flags:0
 41554:20180515:115320.208 In zbx_process_trigger() triggerid:24635 value:0(0) new_value:3
 41554:20180515:115320.208 End of zbx_process_trigger():FAIL flags:0
 41554:20180515:115320.208 In zbx_process_trigger() triggerid:26186 value:0(0) new_value:3
 41554:20180515:115320.208 End of zbx_process_trigger():FAIL flags:0
 41554:20180515:115320.208 In zbx_process_trigger() triggerid:26336 value:0(0) new_value:3
 41554:20180515:115320.208 End of zbx_process_trigger():FAIL flags:0
 41554:20180515:115320.209 End of zbx_process_triggers()
 41554:20180515:115320.209 End of DCmass_update_triggers()
 41554:20180515:115320.209 In DCmass_update_trends()
 41554:20180515:115320.209 End of DCmass_update_trends()
 41554:20180515:115320.209 In process_events() events_num:0
 41554:20180515:115320.209 End of process_events() processed:0
 41554:20180515:115320.209 query [txnlev:1] [commit;]
 41554:20180515:115320.209 In DBupdate_itservices()
 41554:20180515:115320.209 End of DBupdate_itservices():SUCCEED
 41554:20180515:115320.209 In DCmass_update_history() history_num:1
 41554:20180515:115320.209 End of DCmass_update_history()
 41554:20180515:115320.209 In DCmass_add_history()
 41554:20180515:115320.209 In zbx_history_add_values()
 41554:20180515:115320.209 query [txnlev:1] [begin;]
 41554:20180515:115320.209 query [txnlev:1] [insert into history (itemid,clock,ns,value) values (58446,1526378000,202343524,0.000000);
]
 41554:20180515:115320.210 query [txnlev:1] [commit;]
 41554:20180515:115320.210 End of zbx_history_add_values()
 41554:20180515:115320.210 End of DCmass_add_history()
 41554:20180515:115320.210 query [txnlev:1] [begin;]
 41554:20180515:115320.210 In DCmass_update_items()
 41554:20180515:115320.210 End of DCmass_update_items()
 41554:20180515:115320.210 In DCmass_update_triggers()
 41554:20180515:115320.210 In zbx_link_triggers_with_functions() trigger_order_num:0
 41554:20180515:115320.211 End of zbx_link_triggers_with_functions() triggers_func_pos_num:0
 41554:20180515:115320.211 End of DCmass_update_triggers()
 41554:20180515:115320.211 In DCmass_update_trends()
 41554:20180515:115320.211 End of DCmass_update_trends()
 41554:20180515:115320.211 In process_events() events_num:0
 41554:20180515:115320.211 End of process_events() processed:0
 41554:20180515:115320.211 query [txnlev:1] [commit;]
 41554:20180515:115320.211 In DBupdate_itservices()
 41554:20180515:115320.211 End of DBupdate_itservices():SUCCEED
 41554:20180515:115320.211 __zbx_zbx_setproctitle() title:'history syncer #2 [synced 46 items in 0.009562 sec, idle 1 sec]'

[vso]

I am sorry but there are no errors in the log provided. It would be nice to have one that say "foreign key constraint fails"

Or is it timer process that has an error ?

[lukisec]

41555:20180515:121812.497 End of evaluate_expressions()
 41555:20180515:121812.497 In zbx_process_triggers() values_num:7
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23059 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23060 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23061 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23062 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23063 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.497 In zbx_process_trigger() triggerid:23064 value:0(0) new_value:3
 41555:20180515:121812.497 End of zbx_process_trigger():FAIL flags:0
 41555:20180515:121812.498 In zbx_process_trigger() triggerid:24372 value:0(1) new_value:3
 41555:20180515:121812.498 End of zbx_process_trigger():SUCCEED flags:12
 41555:20180515:121812.498 End of zbx_process_triggers()
 41555:20180515:121812.498 End of DCmass_update_triggers()
 41555:20180515:121812.498 In DCmass_update_trends()
 41555:20180515:121812.498 End of DCmass_update_trends()
 41555:20180515:121812.498 In process_events() events_num:1
 41555:20180515:121812.498 In DCget_nextid() table:'events' num:1
 41555:20180515:121812.498 End of DCget_nextid() table:'events' [99470:99470]
 41555:20180515:121812.498 query [txnlev:1] [select eventid,object,objectid from problem where r_eventid is null and source=3 and ( (object=0 and objectid=24372))]
 41555:20180515:121812.508 In DCget_nextid() table:'events' num:0
 41555:20180515:121812.508 End of DCget_nextid() table:'events' [99471:99470]
 41555:20180515:121812.508 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (99470,3,0,24372,1526379492,45162314,0);
]
 41555:20180515:121812.515 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17661,99470,null,null,null),(9775,99470,null,null,null),(31354,99470,null,null,null),(96733,99470,null,null,null),(76104,99470,null,null,null),(55089,99470,null,null,null),(71413,99470,null,null,null),(50557,99470,null,null,null),(94600,99470,null,null,null),(11012,99470,null,null,null),(47077,99470,null,null,null),(12959,99470,null,null,null),(8201,99470,null,null,null),(93898,99470,null,null,null),(58373,99470,null,null,null),(91598,99470,null,null,null),(14506,99470,null,null,null),(115795,99470,null,null,null),(96983,99470,null,null,null),(57032,99470,null,null,null),(86407,99470,null,null,null),(20095,99470,null,null,null),(45265,99470,null,null,null),(8561,99470,null,null,null),(78051,99470,null,null,null),(88849,99470,null,null,null),(35046,99470,null,null,null),(13101,99470,null,null,null),(95333,99470,null,null,null),(61113,99470,null,null,null),(98584,99470,null,null,null),(96657,99470,null,null,null),(15309,99470,null,null,null),(17345,99470,null,null,null),(9628,99470,null,null,null),(87270,99470,null,null,null),(102316,99470,null,null,null),(113301,99470,null,null,null),(29240,99470,null,null,null),(84099,99470,null,null,null),(28048,99470,null,null,null),(16887,99470,null,null,null),(90094,99470,null,null,null),(10710,99470,null,null,null),(90051,99470,null,null,null),(133279,99470,null,null,null),(109107,99470,null,null,null),(18042,99470,null,null,null),(12598,99470,null,null,null),.........,(56836,99470,null,null,null),(27423,99470,null,null,null),(87513,99470,null,null,null),(47571,99470,null,null,null),(94856,99470,null,null,null),(34304,99470,null,null,null),(130545,99470,null,null,null),(86098,99470,null,null,null),(75657,99470,null,null,null),(144547,99470,null,null,null),(120460,99470,null,null,null),(34911,99470,null,null,null),(32800,99470,null,null,null),(56374,99470,null,null,null),(87412,99470,null,null,null),(96014,99470,null,null,null),(90729,99470,null,null,null),(12173,99470,null,null,null),(44788,99470,null,null,null),(140433,99470,null,null,null),(88336,99470,null,null,null),(45031,99470,null,null,null),(52163,99470,null,null,null),(115558,99470,null,null,null),(92604,99470,null,null,null),(13919,99470,null,null,null),(114648,99470,null,null,null),(120692,99470,null,null,null),(116887,99470,null,null,null),(36353,99470,null,null,null),(76055,99470,null,null,null),(36017,99470,null,null,null),(19429,99470,null,null,null),(87545,99470,null,null,null),(109352,99470,null,null,null),(63986,99470,null,null,null),(8520,99470,null,null,null),(3136,99470,null,null,null),(105966,99470,null,null,null),(98013,99470,null,null,null),(33081,99470,null,null,null),(15845,99470,null,null,null),(15686,99470,null,null,null),(32550,99470,null,null,null),(39882,99470,null,null,null),(78875,99470,null,null,null),(72129,99470,null,null,null),(5388,99470,null,null,null),(42071,99470,null,null,null),(108025,99470,null,null,null),(44140,99470,null,null,null),(4107null),(61857,99470,null,null,null),(55882,99470,null,null,null),(18686,99470,null,null,null),(123751,99470,null,null,null),(32843,99470,null,null,null),(5619,99470,null,null,null),(76190,99470,null,null,null),(139692,99470,null,null,null),(100959,99470,null,null,null),(65418,99470,null,null,null),(121316,99470,null,null,null),(20198,99470,null,null,null),(20380,99470,null,null,null),(10245,99470,null,null,null),(140390,99470,null,null,null),(113153,99470,null,null,null),(113861,99470,null,null,null),(8793,99470,null,null,null),(66407,99470,null,null,null),(110945,99470,null,null,null);
]
 41555:20180515:121812.522 [Z3005] query failed: [1452] Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`event_recovery`, CONSTRAINT `c_event_recovery_1` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE) [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17661,99470,null,null,null),(9775,99470,null,null,null),(31354,99470,null,null,null),(96733,99470,null,null,null),(76104,99470,null,null,null),(55089,99470,null,null,null),(71413,99470,null,null,null),(50557,99470,null,null,null),(94600,99470,null,null,null),(11012,99470,null,null,null),(47077,99470,null,null,null),(12959,99470,null,null,null),(8201,99470,null,null,null),(93898,99470,null,null,null),(58373,99470,null,null,null),(91598,99470,null,null,null),(14506,99470,null,null,null),(115795,99470,null,null,null),(96983,99470,null,null,null),(57032,99470,null,null,null),(86407,99470,null,null,null),(20095,99470,null,null,null),(45265,99470,null,null,null),(8561,99470,null,nullnull,null,null),(14727,99470,null,null,null),(18151,99470,null,null,null),(73329,99470,null,null,null),(64425,99470,null,null,null),(124316,99470,null,null,null),(104336,99470,null,null,null),(76503,99470,null,null,null),(84854,99470,null,null,null),(80864,99470,null,null,null),(44379,99470,null,null,null),(140716,99470,null,null,nu(18686,99470,null,null,null),(123751,99470,null,null,null),(32843,99470,null,null,null),(5619,99470,null,null,null),(76190,99470,null,null,null),(139692,99470,null,null,null),(100959,99470,null,null,null),(65418,99470,null,null,null),(121316,99470,null,null,null),(20198,99470,null,null,null),(20380,99470,null,null,null),(10245,99470,null,null,null),(140390,99470,null,null,null),(113153,99470,null,null,null),(113861,99470,null,null,null),(8793,99470,null,null,null),(66407,99470,null,null,null),(110945,99470,null,null,null);
] failed, setting transaction as failed
 41555:20180515:121812.525 ignoring query [txnlev:1] [update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=17661;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=9775;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=31354;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=96733;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=76104;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=55089;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=71413;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=50557;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=94600;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=11012;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=47077;
update problem set r_eventid=99470,r_clock=1526379492,r_ns=45162314,userid=0 where eventid=12959;

[vso]

It looks like one of those events are missing in events table, can you please confirm ?

insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (17661,99470,null,null,null),(9775,99470,null,null ,null),(31354,99470,null,null,null),(96733,99470,n ull,null,null),(76104,99470,null,null,null),(55089 ,99470,null,null,null),(71413,99470,null,null,null ),(50557,99470,null,null,null),(94600,99470,null,n ull,null),(11012,99470,null,null,null),(47077,9947 0,null,null,null),(12959,99470,null,null,null),(82 01,99470,null,null,null),(93898,99470,null,null,nu ll),(58373,99470,null,null,null),(91598,99470,null ,null,null),(14506,99470,null,null,null),(115795,9 9470,null,null,null),(96983,99470,null,null,null), (57032,99470,null,null,null),(86407,99470,null,nul l,null),(20095,99470,null,null,null),(45265,99470, null,null,null),(8561,99470,null,nullnull,null,nul l),(14727,99470,null,null,null),(18151,99470,null, null,null),(73329,99470,null,null,null),(64425,994 70,null,null,null),(124316,99470,null,null,null),( 104336,99470,null,null,null),(76503,99470,null,nul l,null),(84854,99470,null,null,null),(80864,99470, null,null,null),(44379,99470,null,null,null),(1407 16,99470,null,null,nu(18686,99470,null,null,null), (123751,99470,null,null,null),(32843,99470,null,nu ll,null),(5619,99470,null,null,null),(76190,99470, null,null,null),(139692,99470,null,null,null),(100 959,99470,null,null,null),(65418,99470,null,null,n ull),(121316,99470,null,null,null),(20198,99470,nu ll,null,null),(20380,99470,null,null,null),(10245, 99470,null,null,null),(140390,99470,null,null,null ),(113153,99470,null,null,null),(113861,99470,null ,null,null),(8793,99470,null,null,null),(66407,994 70,null,null,null),(110945,99470,null,null,null);

For example select from events where eventid in (17661);
select from events where eventid in (9775);

[lukisec]

MariaDB [zabbix]> select from events where eventid in (9775);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from events where eventid in (9775)' at line 1

but

MariaDB [zabbix]> select * from events where eventid in (9775);
Empty set (0.00 sec)


MariaDB [zabbix]> select * from events where eventid in (17661);
Empty set (0.00 sec)