44629:20220927:171120.920 zbx_setproctitle() title:'task manager [processing tasks]' 44629:20220927:171120.920 query [txnlev:0] [select taskid,type,clock,ttl from task where status in (1,2) order by taskid] 44629:20220927:171120.922 In tm_try_task_close_problem() taskid:37643 44629:20220927:171120.922 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=37643] 44629:20220927:171120.928 In tm_execute_task_close_problem() eventid:14262301 44629:20220927:171120.928 query [txnlev:0] [select null from problem where eventid=14262301 and r_eventid is null] 44629:20220927:171120.931 In substitute_simple_macros_impl() data:EMPTY 44629:20220927:171120.931 In substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - {ITEM.LASTVALUE1}' 44629:20220927:171120.931 In DBitem_lastvalue() 44629:20220927:171120.931 In DBitem_value() 44629:20220927:171120.931 In DBitem_get_value() 44629:20220927:171120.931 query [txnlev:1] [select value_type,valuemapid,units from items where itemid=222380] 44629:20220927:171120.932 In zbx_vc_get_values() itemid:222380 value_type:2 count:1 period:1664313080 end_timestamp '2022.09.27 17:11:20.999999999' 44629:20220927:171120.932 End of zbx_vc_get_values():SUCCEED count:1 cached:1 44629:20220927:171120.932 In zbx_format_value() 44629:20220927:171120.932 End of zbx_format_value() 44629:20220927:171120.932 End of DBitem_get_value():SUCCEED 44629:20220927:171120.932 End of DBitem_value():SUCCEED 44629:20220927:171120.932 End of DBitem_lastvalue():SUCCEED 44629:20220927:171120.932 End substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'PURE' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'y' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'Application' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'***' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'Object' 44629:20220927:171120.932 In substitute_simple_macros_impl() data:'US' 44629:20220927:171120.932 In DCget_nextid() table:'events' num:1 44629:20220927:171120.932 End of DCget_nextid() table:'events' [14262318:14262318] 44629:20220927:171120.932 In DCget_nextid() table:'events' num:0 44629:20220927:171120.932 End of DCget_nextid() table:'events' [14262319:14262318] 44629:20220927:171120.932 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,name,severity) values (:1,:2,:3,:4,:5,:6,:7,:8,:9)] 44629:20220927:171120.933 insert [txnlev:1] [14262318,0,0,100190,1664313080,931345867,0,'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000',0] 44629:20220927:171120.934 zbx_db_statement_execute():1 44629:20220927:171120.934 In DCget_nextid() table:'event_tag' num:3 44629:20220927:171120.934 End of DCget_nextid() table:'event_tag' [358246:358248] 44629:20220927:171120.934 query [txnlev:1] [insert into event_tag (eventtagid,eventid,tag,value) values (:1,:2,:3,:4)] 44629:20220927:171120.934 insert [txnlev:1] [358246,14262318,'PURE','y'] 44629:20220927:171120.934 insert [txnlev:1] [358247,14262318,'Application','***'] 44629:20220927:171120.934 insert [txnlev:1] [358248,14262318,'Object','US'] 44629:20220927:171120.935 zbx_db_statement_execute():3 44629:20220927:171120.935 query [txnlev:1] [update problem set r_eventid=14262318,r_clock=1664313080,r_ns=931345867,userid=5 where eventid=14262301] 44629:20220927:171120.937 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (:1,:2,:3,:4,:5)] 44629:20220927:171120.937 insert [txnlev:1] [14262301,14262318,0,0,5] 44629:20220927:171120.937 zbx_db_statement_execute():1 44629:20220927:171120.938 In process_actions() events_num:1 44629:20220927:171120.938 In zbx_dc_get_actions_eval() 44629:20220927:171120.938 End of zbx_dc_get_actions_eval() actions:10 44629:20220927:171120.938 query [txnlev:1] [select eventid,escalationid from escalations where eventid=14262301] 44629:20220927:171120.939 query [txnlev:1] [update escalations set r_eventid=14262318,nextcheck=0 where escalationid=68053] 44629:20220927:171120.941 query [txnlev:1] [update escalations set r_eventid=14262318,nextcheck=0 where escalationid=68054] 44629:20220927:171120.942 End of process_actions() 44629:20220927:171120.942 query [txnlev:1] [select objectid,count(objectid) from problem where r_eventid is null and source=0 and object=0 and objectid=100190 group by objectid] zabbix_server [44629]: ERROR [file and function: , revision:c7c3044a4a2, line:1562] Something impossible has just happened. 44629:20220927:171120.944 === Backtrace: === 44629:20220927:171120.944 11: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_backtrace+0x35) [0x596635] 44629:20220927:171120.944 10: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x51c956] 44629:20220927:171120.945 9: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_close_problem+0x14a) [0x520bda] 44629:20220927:171120.945 8: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x4a06da] 44629:20220927:171120.945 7: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](taskmanager_thread+0x195) [0x4a0da5] 44629:20220927:171120.945 6: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_thread_start+0x3e) [0x5a190e] 44629:20220927:171120.945 5: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x44acda] 44629:20220927:171120.945 4: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](MAIN_ZABBIX_ENTRY+0x9f6) [0x44bb56] 44629:20220927:171120.945 3: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](daemon_start+0x1b2) [0x5963f2] 44629:20220927:171120.945 2: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](main+0x4dc) [0x449c7c] 44629:20220927:171120.945 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fd258249555] 44629:20220927:171120.945 0: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x44a06a] 44629:20220927:171120.945 In zbx_db_save_trigger_changes() 44629:20220927:171120.945 query [txnlev:1] [update triggers set lastchange=1664313080,value=0 where triggerid=100190] 44629:20220927:171120.948 End of zbx_db_save_trigger_changes() 44629:20220927:171120.949 In zbx_ipc_socket_write() 44629:20220927:171120.949 End of zbx_ipc_socket_write():SUCCEED 44629:20220927:171120.949 query without transaction detected 44629:20220927:171120.949 query [txnlev:0] [update task set status=3 where taskid=37643] 44629:20220927:171120.953 End of tm_execute_task_close_problem() 44629:20220927:171120.953 End of tm_try_task_close_problem():SUCCEED 44629:20220927:171120.953 In tm_try_task_close_problem() taskid:37645 44629:20220927:171120.953 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=37645] 44629:20220927:171120.957 In tm_execute_task_close_problem() eventid:14262302 44629:20220927:171120.957 query [txnlev:0] [select null from problem where eventid=14262302 and r_eventid is null] 44629:20220927:171120.960 In substitute_simple_macros_impl() data:EMPTY 44629:20220927:171120.960 In substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - {ITEM.LASTVALUE1}' 44629:20220927:171120.960 In DBitem_lastvalue() 44629:20220927:171120.960 In DBitem_value() 44629:20220927:171120.960 In DBitem_get_value() 44629:20220927:171120.960 query [txnlev:1] [select value_type,valuemapid,units from items where itemid=222380] 44629:20220927:171120.960 In zbx_vc_get_values() itemid:222380 value_type:2 count:1 period:1664313080 end_timestamp '2022.09.27 17:11:20.999999999' 44629:20220927:171120.960 End of zbx_vc_get_values():SUCCEED count:1 cached:1 44629:20220927:171120.960 In zbx_format_value() 44629:20220927:171120.960 End of zbx_format_value() 44629:20220927:171120.960 End of DBitem_get_value():SUCCEED 44629:20220927:171120.960 End of DBitem_value():SUCCEED 44629:20220927:171120.960 End of DBitem_lastvalue():SUCCEED 44629:20220927:171120.961 End substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'PURE' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'y' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'Application' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'***' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'Object' 44629:20220927:171120.961 In substitute_simple_macros_impl() data:'US' 44629:20220927:171120.961 In DCget_nextid() table:'events' num:1 44629:20220927:171120.961 End of DCget_nextid() table:'events' [14262319:14262319] 44629:20220927:171120.961 In DCget_nextid() table:'events' num:0 44629:20220927:171120.961 End of DCget_nextid() table:'events' [14262320:14262319] 44629:20220927:171120.961 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,name,severity) values (:1,:2,:3,:4,:5,:6,:7,:8,:9)] 44629:20220927:171120.961 insert [txnlev:1] [14262319,0,0,100190,1664313080,959993430,0,'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000',0] 44629:20220927:171120.962 zbx_db_statement_execute():1 44629:20220927:171120.962 In DCget_nextid() table:'event_tag' num:3 44629:20220927:171120.962 End of DCget_nextid() table:'event_tag' [358249:358251] 44629:20220927:171120.962 query [txnlev:1] [insert into event_tag (eventtagid,eventid,tag,value) values (:1,:2,:3,:4)] 44629:20220927:171120.962 insert [txnlev:1] [358249,14262319,'PURE','y'] 44629:20220927:171120.962 insert [txnlev:1] [358250,14262319,'Application','***'] 44629:20220927:171120.962 insert [txnlev:1] [358251,14262319,'Object','US'] 44629:20220927:171120.963 zbx_db_statement_execute():3 44629:20220927:171120.963 query [txnlev:1] [update problem set r_eventid=14262319,r_clock=1664313080,r_ns=959993430,userid=5 where eventid=14262302] 44629:20220927:171120.965 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (:1,:2,:3,:4,:5)] 44629:20220927:171120.965 insert [txnlev:1] [14262302,14262319,0,0,5] 44629:20220927:171120.965 zbx_db_statement_execute():1 44629:20220927:171120.966 In process_actions() events_num:1 44629:20220927:171120.966 In zbx_dc_get_actions_eval() 44629:20220927:171120.966 End of zbx_dc_get_actions_eval() actions:10 44629:20220927:171120.966 query [txnlev:1] [select eventid,escalationid from escalations where eventid=14262302] 44629:20220927:171120.968 query [txnlev:1] [update escalations set r_eventid=14262319,nextcheck=0 where escalationid=68055] 44629:20220927:171120.970 query [txnlev:1] [update escalations set r_eventid=14262319,nextcheck=0 where escalationid=68056] 44629:20220927:171120.972 End of process_actions() 44629:20220927:171120.972 query [txnlev:1] [select objectid,count(objectid) from problem where r_eventid is null and source=0 and object=0 and objectid=100190 group by objectid] zabbix_server [44629]: ERROR [file and function: , revision:c7c3044a4a2, line:1562] Something impossible has just happened. 44629:20220927:171120.973 === Backtrace: === 44629:20220927:171120.973 11: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_backtrace+0x35) [0x596635] 44629:20220927:171120.973 10: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x51c956] 44629:20220927:171120.973 9: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_close_problem+0x14a) [0x520bda] 44629:20220927:171120.973 8: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x4a06da] 44629:20220927:171120.973 7: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](taskmanager_thread+0x195) [0x4a0da5] 44629:20220927:171120.973 6: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](zbx_thread_start+0x3e) [0x5a190e] 44629:20220927:171120.973 5: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x44acda] 44629:20220927:171120.974 4: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](MAIN_ZABBIX_ENTRY+0x9f6) [0x44bb56] 44629:20220927:171120.974 3: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](daemon_start+0x1b2) [0x5963f2] 44629:20220927:171120.974 2: /data/zabbix/sbin/zabbix_server: task manager [processing tasks](main+0x4dc) [0x449c7c] 44629:20220927:171120.974 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fd258249555] 44629:20220927:171120.974 0: /data/zabbix/sbin/zabbix_server: task manager [processing tasks]() [0x44a06a] 44629:20220927:171120.974 In zbx_db_save_trigger_changes() 44629:20220927:171120.974 query [txnlev:1] [update triggers set lastchange=1664313080 where triggerid=100190] 44629:20220927:171120.976 End of zbx_db_save_trigger_changes() 44629:20220927:171120.977 In zbx_ipc_socket_write() 44629:20220927:171120.977 End of zbx_ipc_socket_write():SUCCEED 44629:20220927:171120.977 query without transaction detected 44629:20220927:171120.977 query [txnlev:0] [update task set status=3 where taskid=37645] 44629:20220927:171120.979 End of tm_execute_task_close_problem() 44629:20220927:171120.979 End of tm_try_task_close_problem():SUCCEED 44629:20220927:171120.979 In tm_try_task_close_problem() taskid:37647 44629:20220927:171120.980 query [txnlev:0] [select a.userid,a.eventid,e.objectid from task_close_problem tcp left join acknowledges a on tcp.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid where tcp.taskid=37647] 44629:20220927:171120.982 In tm_execute_task_close_problem() eventid:14262303 44629:20220927:171120.982 query [txnlev:0] [select null from problem where eventid=14262303 and r_eventid is null] 44629:20220927:171120.985 In substitute_simple_macros_impl() data:EMPTY 44629:20220927:171120.985 In substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - {ITEM.LASTVALUE1}' 44629:20220927:171120.985 In DBitem_lastvalue() 44629:20220927:171120.985 In DBitem_value() 44629:20220927:171120.985 In DBitem_get_value() 44629:20220927:171120.985 query [txnlev:1] [select value_type,valuemapid,units from items where itemid=222380] 44629:20220927:171120.986 In zbx_vc_get_values() itemid:222380 value_type:2 count:1 period:1664313080 end_timestamp '2022.09.27 17:11:20.999999999' 44629:20220927:171120.986 End of zbx_vc_get_values():SUCCEED count:1 cached:1 44629:20220927:171120.986 In zbx_format_value() 44629:20220927:171120.986 End of zbx_format_value() 44629:20220927:171120.986 End of DBitem_get_value():SUCCEED 44629:20220927:171120.986 End of DBitem_value():SUCCEED 44629:20220927:171120.986 End of DBitem_lastvalue():SUCCEED 44629:20220927:171120.986 End substitute_simple_macros_impl() data:'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'PURE' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'y' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'Application' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'***' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'Object' 44629:20220927:171120.986 In substitute_simple_macros_impl() data:'US' 44629:20220927:171120.986 In DCget_nextid() table:'events' num:1 44629:20220927:171120.986 End of DCget_nextid() table:'events' [14262320:14262320] 44629:20220927:171120.986 In DCget_nextid() table:'events' num:0 44629:20220927:171120.987 End of DCget_nextid() table:'events' [14262321:14262320] 44629:20220927:171120.987 query [txnlev:1] [insert into events (eventid,source,object,objectid,clock,ns,value,name,severity) values (:1,:2,:3,:4,:5,:6,:7,:8,:9)] 44629:20220927:171120.987 insert [txnlev:1] [14262320,0,0,100190,1664313080,985537921,0,'Alarm found in *** TestLogs2.txt - \*** 2022-09-27 17:10 00000 *** |STMP+07|Volume - Current Volume 247.000000 - Expected Value 351.400000',0] 44629:20220927:171120.987 zbx_db_statement_execute():1 44629:20220927:171120.987 In DCget_nextid() table:'event_tag' num:3 44629:20220927:171120.987 End of DCget_nextid() table:'event_tag' [358252:358254] 44629:20220927:171120.987 query [txnlev:1] [insert into event_tag (eventtagid,eventid,tag,value) values (:1,:2,:3,:4)] 44629:20220927:171120.987 insert [txnlev:1] [358252,14262320,'PURE','y'] 44629:20220927:171120.988 insert [txnlev:1] [358253,14262320,'Application','***'] 44629:20220927:171120.988 insert [txnlev:1] [358254,14262320,'Object','US'] 44629:20220927:171120.988 zbx_db_statement_execute():3 44629:20220927:171120.988 query [txnlev:1] [update problem set r_eventid=14262320,r_clock=1664313080,r_ns=985537921,userid=5 where eventid=14262303] 44629:20220927:171120.990 query [txnlev:1] [insert into event_recovery (eventid,r_eventid,correlationid,c_eventid,userid) values (:1,:2,:3,:4,:5)] 44629:20220927:171120.990 insert [txnlev:1] [14262303,14262320,0,0,5] 44629:20220927:171120.991 zbx_db_statement_execute():1 44629:20220927:171120.991 In process_actions() events_num:1 44629:20220927:171120.991 In zbx_dc_get_actions_eval() 44629:20220927:171120.991 End of zbx_dc_get_actions_eval() actions:10 44629:20220927:171120.991 query [txnlev:1] [select eventid,escalationid from escalations where eventid=14262303] 44629:20220927:171120.993 query [txnlev:1] [update escalations set r_eventid=14262320,nextcheck=0 where escalationid=68057] 44629:20220927:171120.994 query [txnlev:1] [update escalations set r_eventid=14262320,nextcheck=0 where escalationid=68058] 44629:20220927:171120.996 End of process_actions() 44629:20220927:171120.996 query [txnlev:1] [select objectid,count(objectid) from problem where r_eventid is null and source=0 and object=0 and objectid=100190 group by objectid] 44629:20220927:171120.997 In zbx_db_save_trigger_changes() 44629:20220927:171120.997 query [txnlev:1] [update triggers set lastchange=1664313080 where triggerid=100190] 44629:20220927:171120.998 End of zbx_db_save_trigger_changes() 44629:20220927:171120.999 In zbx_ipc_socket_write() 44629:20220927:171120.999 End of zbx_ipc_socket_write():SUCCEED 44629:20220927:171120.999 query without transaction detected 44629:20220927:171120.999 query [txnlev:0] [update task set status=3 where taskid=37647] 44629:20220927:171121.002 End of tm_execute_task_close_problem() 44629:20220927:171121.002 End of tm_try_task_close_problem():SUCCEED 44629:20220927:171121.003 In tm_process_acknowledgments() tasks_num:3 44629:20220927:171121.003 query [txnlev:0] [select a.eventid,ta.acknowledgeid,ta.taskid,a.old_severity,a.new_severity from task_acknowledge ta left join acknowledges a on ta.acknowledgeid=a.acknowledgeid left join events e on a.eventid=e.eventid left join task t on ta.taskid=t.taskid where t.status=1 and t.taskid in (37644,37646,37648)] 44629:20220927:171121.009 In process_actions_by_acknowledgments() 44629:20220927:171121.009 In zbx_dc_get_actions_eval() 44629:20220927:171121.009 End of zbx_dc_get_actions_eval() actions:0 44629:20220927:171121.009 End of process_actions_by_acknowledgments() processed_num:0 44629:20220927:171121.009 query without transaction detected 44629:20220927:171121.009 query [txnlev:0] [update task set status=3 where taskid in (37644,37646,37648)] 44629:20220927:171121.012 End of tm_process_acknowledgments() processed:0 44629:20220927:171121.012 zbx_setproctitle() title:'task manager [processed 3 task(s) in 0.091891 sec, idle 4 sec]'