23818:20160721:143731.002 In process_trigger_events() events_num:56 23818:20160721:143731.002 In DCget_nextid() table:'events' num:56 23818:20160721:143731.002 query [txnlev:1] [select max(eventid) from events where eventid between 0 and 9223372036854775807] 23818:20160721:143731.002 End of DCget_nextid() table:'events' [5633173:5633228] 23818:20160721:143731.003 In correlate_events_by_default_rules() 23818:20160721:143731.003 End of correlate_events_by_default_rules() 23818:20160721:143731.003 In correlate_events_by_trigger_rules() 23818:20160721:143731.003 End of correlate_events_by_trigger_rules() 23818:20160721:143731.003 In correlate_events_by_global_rules() events:0 23818:20160721:143731.003 End of correlate_events_by_global_rules() closed:0 23818:20160721:143731.003 In DCget_nextid() table:'events' num:0 23818:20160721:143731.003 End of DCget_nextid() table:'events' [5633229:5633228] 23818:20160721:143731.003 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (5633173,3,0,13491,1469101050,955450348,1),(5633174,3,0,26521,1469101050,955484412,1),(5633175,0,0,26538,1469101050,955500756,1),(5633176,3,0,26571,1469101050,955522901,1),(5633177,3,0,26589,1469101050,955545413,1),(5633178,3,0,26640,1469101050,955551889,1),(5633179,3,0,26730,1469101050,955567034,1),(5633180,3,0,26828,1469101050,955602704,1),(5633181,3,0,26839,1469101050,955606867,1),(5633182,3,0,26846,1469101050,955615487,1),(5633183,3,0,26853,1469101050,955620578,1),(5633184,3,0,26863,1469101050,955628147,1),(5633185,3,0,26891,1469101050,955637910,1),(5633186,3,0,26907,1469101050,955644722,1),(5633187,3,0,26920,1469101050,955652670,1),(5633188,3,0,26930,1469101050,955661590,1),(5633189,3,0,26993,1469101050,955673325,1),(5633190,3,0,27077,1469101050,955682956,1),(5633191,3,0,27123,1469101050,955692629,1),(5633192,3,0,27132,1469101050,955695482,1),(5633193,3,0,27201,1469101050,955708572,1),(5633194,3,0,27392,1469101050,955722441,1),(5633195,3,0,27451,1469101050,955726431,1),(5633196,3,0,27637,1469101050,955761510,1),(5633197,3,0,27661,1469101050,955763973,1),(5633198,3,0,27725,1469101050,955769397,1),(5633199,3,0,27783,1469101050,955780731,1),(5633200,3,0,27813,1469101050,955784673,1),(5633201,3,0,27864,1469101050,955789041,1),(5633202,3,0,27872,1469101050,955791636,1),(5633203,3,0,27889,1469101050,955793283,1),(5633204,3,0,27930,1469101050,955797561,1),(5633205,3,0,27951,1469101050,955800938,1),(5633206,3,0,27976,1469101050,955805220,1),(5633207,3,0,27999,1469101050,955808480,1),(5633208,3,0,28020,1469101050,955812699,1),(5633209,3,0,28045,1469101050,955817030,1),(5633210,3,0,28100,1469101050,955821608,1),(5633211,3,0,28142,1469101050,955826257,1),(5633212,3,0,28155,1469101050,955829278,1),(5633213,3,0,28163,1469101050,955836188,1),(5633214,3,0,26761,1469101050,955581899,1),(5633215,3,0,26804,1469101050,955589434,1),(5633216,3,0,26820,1469101050,955597909,1),(5633217,3,0,26978,1469101050,955667908,1),(5633218,3,0,27072,1469101050,955680101,1),(5633219,3,0,27105,1469101050,955688249,1),(5633220,3,0,27154,1469101050,955701729,1),(5633221,3,0,27251,1469101050,955715377,1),(5633222,3,0,27499,1469101050,955731170,1),(5633223,3,0,27520,1469101050,955735625,1),(5633224,3,0,27600,1469101050,955744403,1),(5633225,3,0,27606,1469101050,955749696,1),(5633226,3,0,27612,1469101050,955754700,1),(5633227,3,0,27618,1469101050,955758234,1),(5633228,3,0,27746,1469101050,955773567,1);] 23818:20160721:143731.004 query [txnlev:1] [insert into problem (eventid,source,object,objectid,clock,ns) values (5633173,3,0,13491,1469101050,955450348),(5633174,3,0,26521,1469101050,955484412),(5633175,0,0,26538,1469101050,955500756),(5633176,3,0,26571,1469101050,955522901),(5633177,3,0,26589,1469101050,955545413),(5633178,3,0,26640,1469101050,955551889),(5633179,3,0,26730,1469101050,955567034),(5633180,3,0,26828,1469101050,955602704),(5633181,3,0,26839,1469101050,955606867),(5633182,3,0,26846,1469101050,955615487),(5633183,3,0,26853,1469101050,955620578),(5633184,3,0,26863,1469101050,955628147),(5633185,3,0,26891,1469101050,955637910),(5633186,3,0,26907,1469101050,955644722),(5633187,3,0,26920,1469101050,955652670),(5633188,3,0,26930,1469101050,955661590),(5633189,3,0,26993,1469101050,955673325),(5633190,3,0,27077,1469101050,955682956),(5633191,3,0,27123,1469101050,955692629),(5633192,3,0,27132,1469101050,955695482),(5633193,3,0,27201,1469101050,955708572),(5633194,3,0,27392,1469101050,955722441),(5633195,3,0,27451,1469101050,955726431),(5633196,3,0,27637,1469101050,955761510),(5633197,3,0,27661,1469101050,955763973),(5633198,3,0,27725,1469101050,955769397),(5633199,3,0,27783,1469101050,955780731),(5633200,3,0,27813,1469101050,955784673),(5633201,3,0,27864,1469101050,955789041),(5633202,3,0,27872,1469101050,955791636),(5633203,3,0,27889,1469101050,955793283),(5633204,3,0,27930,1469101050,955797561),(5633205,3,0,27951,1469101050,955800938),(5633206,3,0,27976,1469101050,955805220),(5633207,3,0,27999,1469101050,955808480),(5633208,3,0,28020,1469101050,955812699),(5633209,3,0,28045,1469101050,955817030),(5633210,3,0,28100,1469101050,955821608),(5633211,3,0,28142,1469101050,955826257),(5633212,3,0,28155,1469101050,955829278),(5633213,3,0,28163,1469101050,955836188),(5633214,3,0,26761,1469101050,955581899),(5633215,3,0,26804,1469101050,955589434),(5633216,3,0,26820,1469101050,955597909),(5633217,3,0,26978,1469101050,955667908),(5633218,3,0,27072,1469101050,955680101),(5633219,3,0,27105,1469101050,955688249),(5633220,3,0,27154,1469101050,955701729),(5633221,3,0,27251,1469101050,955715377),(5633222,3,0,27499,1469101050,955731170),(5633223,3,0,27520,1469101050,955735625),(5633224,3,0,27600,1469101050,955744403),(5633225,3,0,27606,1469101050,955749696),(5633226,3,0,27612,1469101050,955754700),(5633227,3,0,27618,1469101050,955758234),(5633228,3,0,27746,1469101050,955773567);] 23818:20160721:143731.038 In process_actions() events_num:56 23818:20160721:143731.038 In zbx_dc_get_actions_eval() 23818:20160721:143731.038 End of zbx_dc_get_actions_eval() actions:1 23818:20160721:143731.038 End of process_actions() .... 23877:20160721:144030.625 In process_trigger_events() events_num:37 23877:20160721:144030.625 In DCget_nextid() table:'events' num:37 23877:20160721:144030.625 End of DCget_nextid() table:'events' [5633239:5633275] 23877:20160721:144030.625 In correlate_events_by_default_rules() 23877:20160721:144030.625 query [txnlev:1] [select eventid,source,object,objectid from problem where r_eventid is null and (source=3 and object=0 and objectid in (26571,26589,26640,26828,26839,26846,26853,26863,26891,26907,26920,26930,26993,27077,27123,27132,27201,27637,27725))] 23877:20160721:144030.625 End of correlate_events_by_default_rules() 23877:20160721:144030.625 In correlate_events_by_trigger_rules() 23877:20160721:144030.625 End of correlate_events_by_trigger_rules() 23877:20160721:144030.625 In correlate_events_by_global_rules() events:0 23877:20160721:144030.625 End of correlate_events_by_global_rules() closed:0 23877:20160721:144030.625 In DCget_nextid() table:'events' num:0 23877:20160721:144030.625 End of DCget_nextid() table:'events' [5633276:5633275] 23877:20160721:144030.626 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (5633239,0,0,26571,1469101230,616182070,1),(5633240,3,0,26571,1469101230,616182070,0),(5633241,0,0,26589,1469101230,616185260,1),(5633242,3,0,26589,1469101230,616185260,0),(5633243,0,0,26640,1469101230,616188850,1),(5633244,3,0,26640,1469101230,616188850,0),(5633245,0,0,26828,1469101230,616197017,1),(5633246,3,0,26828,1469101230,616197017,0),(5633247,0,0,26839,1469101230,616200367,1),(5633248,3,0,26839,1469101230,616200367,0),(5633249,0,0,26846,1469101230,616203553,1),(5633250,3,0,26846,1469101230,616203553,0),(5633251,0,0,26853,1469101230,616206454,1),(5633252,3,0,26853,1469101230,616206454,0),(5633253,0,0,26863,1469101230,616209445,1),(5633254,3,0,26863,1469101230,616209445,0),(5633255,0,0,26891,1469101230,616212837,1),(5633256,3,0,26891,1469101230,616212837,0),(5633257,0,0,26907,1469101230,616215977,1),(5633258,3,0,26907,1469101230,616215977,0),(5633259,0,0,26920,1469101230,616219574,1),(5633260,3,0,26920,1469101230,616219574,0),(5633261,0,0,26930,1469101230,616222809,1),(5633262,3,0,26930,1469101230,616222809,0),(5633263,0,0,26993,1469101230,616226208,1),(5633264,3,0,26993,1469101230,616226208,0),(5633265,0,0,27077,1469101230,616230729,1),(5633266,3,0,27077,1469101230,616230729,0),(5633267,0,0,27123,1469101230,616239125,1),(5633268,3,0,27123,1469101230,616239125,0),(5633269,0,0,27132,1469101230,616241473,1),(5633270,3,0,27132,1469101230,616241473,0),(5633271,0,0,27201,1469101230,616244404,1),(5633272,3,0,27201,1469101230,616244404,0),(5633273,0,0,27637,1469101230,616251980,1),(5633274,3,0,27637,1469101230,616251980,0),(5633275,3,0,27725,1469101230,616256509,0);] 23877:20160721:144030.642 query [txnlev:1] [insert into problem (eventid,source,object,objectid,clock,ns) values (5633239,0,0,26571,1469101230,616182070),(5633241,0,0,26589,1469101230,616185260),(5633243,0,0,26640,1469101230,616188 850),(5633245,0,0,26828,1469101230,616197017),(5633247,0,0,26839,1469101230,616200367),(5633249,0,0,26846,1469101230,616203553),(5633251,0,0,26853,1469101230,616206454),(5633253,0,0,26863,1469101230,616209445),(5633255,0,0,26891,146 9101230,616212837),(5633257,0,0,26907,1469101230,616215977),(5633259,0,0,26920,1469101230,616219574),(5633261,0,0,26930,1469101230,616222809),(5633263,0,0,26993,1469101230,616226208),(5633265,0,0,27077,1469101230,616230729),(5633267,0,0,27123,1469101230,616239125),(5633269,0,0,27132,1469101230,616241473),(5633271,0,0,27201,1469101230,616244404),(5633273,0,0,27637,1469101230,616251980);] 23877:20160721:144030.654 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid) values (5633180,5633246,null,null),(5633184,5633254,null,null),(5633182,5633250,null,null),(5633176,5633240,null,null),(5633193,5633272,null,null),(5633190,5633266,null,null),(5633188,5633262,null,null),(5633181,5633248,null,null),(5633185,5633256,null,null),(5633191,5633268,null,null),(5633198,5633275,null,null),(5633183,5633252,null,null),(5633187,5633260,null,null),(5633192,5633270,null,null),(5633196,5633274,null,null),(5633177,5633242,null,null),(5633178,5633244,null,null),(5633189,5633264,null,null),(5633186,5633258,null,null);] 23877:20160721:144030.654 query [txnlev:1] [update problem set r_eventid=5633246, r_clock=1469101230, r_ns=616197017, correlationid=0 where eventid=5633180; update problem set r_eventid=5633254, r_clock=1469101230, r_ns=616209445, correlationid=0 where eventid=5633184; update problem set r_eventid=5633250, r_clock=1469101230, r_ns=616203553, correlationid=0 where eventid=5633182; update problem set r_eventid=5633240, r_clock=1469101230, r_ns=616182070, correlationid=0 where eventid=5633176; update problem set r_eventid=5633272, r_clock=1469101230, r_ns=616244404, correlationid=0 where eventid=5633193; update problem set r_eventid=5633266, r_clock=1469101230, r_ns=616230729, correlationid=0 where eventid=5633190; update problem set r_eventid=5633262, r_clock=1469101230, r_ns=616222809, correlationid=0 where eventid=5633188; update problem set r_eventid=5633248, r_clock=1469101230, r_ns=616200367, correlationid=0 where eventid=5633181; update problem set r_eventid=5633256, r_clock=1469101230, r_ns=616212837, correlationid=0 where eventid=5633185; update problem set r_eventid=5633268, r_clock=1469101230, r_ns=616239125, correlationid=0 where eventid=5633191; update problem set r_eventid=5633275, r_clock=1469101230, r_ns=616256509, correlationid=0 where eventid=5633198; update problem set r_eventid=5633252, r_clock=1469101230, r_ns=616206454, correlationid=0 where eventid=5633183; update problem set r_eventid=5633260, r_clock=1469101230, r_ns=616219574, correlationid=0 where eventid=5633187; update problem set r_eventid=5633270, r_clock=1469101230, r_ns=616241473, correlationid=0 where eventid=5633192; update problem set r_eventid=5633274, r_clock=1469101230, r_ns=616251980, correlationid=0 where eventid=5633196; update problem set r_eventid=5633242, r_clock=1469101230, r_ns=616185260, correlationid=0 where eventid=5633177; update problem set r_eventid=5633244, r_clock=1469101230, r_ns=616188850, correlationid=0 where eventid=5633178; update problem set r_eventid=5633264, r_clock=1469101230, r_ns=616226208, correlationid=0 where eventid=5633189; update problem set r_eventid=5633258, r_clock=1469101230, r_ns=616215977, correlationid=0 where eventid=5633186;] 23877:20160721:144030.656 In process_actions() events_num:37 23877:20160721:144030.656 In zbx_dc_get_actions_eval() 23877:20160721:144030.656 End of zbx_dc_get_actions_eval() actions:1 23877:20160721:144030.656 query [txnlev:1] [select actionid,eventid,escalationid from escalations where (eventid between 5633180 and 5633193 or eventid in (5633176,5633177,5633178,5633196,5633198))] 23877:20160721:144030.656 End of process_actions() ..... 24981:20160721:150002.685 In process_trigger_events() events_num:6 24981:20160721:150002.685 In DCget_nextid() table:'events' num:6 24981:20160721:150002.685 End of DCget_nextid() table:'events' [5633309:5633314] 24981:20160721:150002.685 In correlate_events_by_default_rules() 24981:20160721:150002.685 query [txnlev:1] [select eventid,source,object,objectid from problem where r_eventid is null and (source=0 and object=0 and objectid=26640) or (source=3 and object=0 and objectid in (26640,27600,27606,27612,27618))] 24981:20160721:150002.686 End of correlate_events_by_default_rules() 24981:20160721:150002.686 In correlate_events_by_trigger_rules() 24981:20160721:150002.686 End of correlate_events_by_trigger_rules() 24981:20160721:150002.686 In correlate_events_by_global_rules() events:0 24981:20160721:150002.686 End of correlate_events_by_global_rules() closed:0 24981:20160721:150002.686 In DCget_nextid() table:'events' num:0 24981:20160721:150002.686 End of DCget_nextid() table:'events' [5633315:5633314] 24981:20160721:150002.686 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value) values (5633309,0,0,26640,1469102295,740643629,0),(5633310,3,0,26640,1469102295,740643629,0),(5633311,3,0,27600,1469102291,464574737,0),(5633312,3,0,27606,1469102293,634898914,0),(5633313,3,0,27612,1469102295,773172200,0),(5633314,3,0,27618,1469102297,831666558,0);] 24981:20160721:150002.686 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid) values (5633226,5633313,null,null),(5633178,5633310,null,null),(5633285,5633310,null,null),(5633243,5633309,null,null),(5633227,5633314,null,null),(5633225,5633312,null,null),(5633224,5633311,null,null);] 24981:20160721:150002.687 [Z3005] query failed: [1062] Duplicate entry '5633178' for key 'PRIMARY' [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid) values (5633226,5633313,null,null),(5633178,5633310,null,null),(5633285,5633310,null,null),(5633243,5633309,null,null),(5633227,5633314,null,null),(5633225,5633312,null,null),(5633224,5633311,null,null);] 24981:20160721:150002.687 query [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid) values (5633226,5633313,null,null),(5633178,5633310,null,null),(5633285,5633310,null,null),(5633243,5633309,null,null),(5633227,5633314,null,null),(5633225,5633312,null,null),(5633224,5633311,null,null);] failed, setting transaction as failed 24981:20160721:150002.687 ignoring query [txnlev:1] [update problem set r_eventid=5633313, r_clock=1469102295, r_ns=773172200, correlationid=0 where eventid=5633226; update problem set r_eventid=5633310, r_clock=1469102295, r_ns=740643629, correlationid=0 where eventid=5633178; update problem set r_eventid=5633310, r_clock=1469102295, r_ns=740643629, correlationid=0 where eventid=5633285; update problem set r_eventid=5633309, r_clock=1469102295, r_ns=740643629, correlationid=0 where eventid=5633243; update problem set r_eventid=5633314, r_clock=1469102297, r_ns=831666558, correlationid=0 where eventid=5633227; update problem set r_eventid=5633312, r_clock=1469102293, r_ns=634898914, correlationid=0 where eventid=5633225; update problem set r_eventid=5633311, r_clock=1469102291, r_ns=464574737, correlationid=0 where eventid=5633224; ] within failed transaction 24981:20160721:150002.687 In process_actions() events_num:6 24981:20160721:150002.687 In zbx_dc_get_actions_eval() 24981:20160721:150002.687 End of zbx_dc_get_actions_eval() actions:1 24981:20160721:150002.687 ignoring query [txnlev:1] [select actionid,eventid,escalationid from escalations where eventid in (5633178,5633224,5633225,5633226,5633227,5633243,5633285)] within failed transaction 24981:20160721:150002.687 End of process_actions()