1408:20241030:072324.489 slow query: 24.199561 sec, "select pp.item_preprocid,pp.itemid,pp.type,pp.params,pp.step,h.hostid,pp.error_handler,pp.error_handler_params from item_preproc pp,items i,hosts h where pp.itemid=i.itemid and i.hostid=h.hostid and (h.proxy_hostid is null or i.type in (5,15,18)) and h.status in (0,1) and i.flags<>2"
  1408:20241030:072324.489 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
  1408:20241030:072324.504 In DCsync_interfaces()
  1408:20241030:072324.525 End of DCsync_interfaces()
  1408:20241030:072324.525 In DCsync_items()
  1407:20241030:072324.585 End of zbx_ipc_service_recv():2
  1407:20241030:072324.585 In zbx_ipc_service_recv() timeout:1.000
  1405:20241030:072325.405 End of zbx_ipc_service_recv():2
  1405:20241030:072325.406 In zbx_ipc_service_recv() timeout:1.000
  1406:20241030:072325.406 End of zbx_ipc_service_recv():2
  1406:20241030:072325.406 In zbx_ipc_async_socket_send()
  1406:20241030:072325.406 In zbx_ipc_client_send() clientid:0
  1406:20241030:072325.406 End of zbx_ipc_client_send():SUCCEED
  1406:20241030:072325.406 End of zbx_ipc_async_socket_send():SUCCEED
  1406:20241030:072325.406 In zbx_ipc_async_socket_flush() timeout:10
  1406:20241030:072325.406 End of zbx_ipc_async_socket_flush():0
  1406:20241030:072325.407 In zbx_ipc_service_recv() timeout:0.987
  1405:20241030:072325.407 zbx_ipc_service_recv() code:10001 size:0 data:
  1405:20241030:072325.407 End of zbx_ipc_service_recv():1
  1405:20241030:072325.407 In zbx_ipc_service_recv() timeout:1.000
  1407:20241030:072325.591 End of zbx_ipc_service_recv():2
  1407:20241030:072325.591 zbx_setproctitle() title:'service manager #1 [processed 0 events, updated 0 event tags, deleted 0 problems, synced 0 service updates, idle 5.037327 sec during 5.037352 sec]'
  1407:20241030:072325.591 services  : 0 (1009 slots)
  1407:20241030:072325.591 service tags  : 0 (1009 slots)
  1407:20241030:072325.591 services links  : 0 (1009 slots)
  1407:20241030:072325.591 service problem tags  : 0 (1009 slots)
  1407:20241030:072325.591 service problem tag index  : 0 (1009 slots)
  1407:20241030:072325.591 service problems index  : 0 (1009 slots)
  1407:20241030:072325.591 service matches  : 0 (1009 slots)
  1407:20241030:072325.591 problem events  : 0 (1009 slots)
  1407:20241030:072325.591 recovery events  : 0 (2 slots)
  1407:20241030:072325.591 deleted events  : 0 (1009 slots)
  1407:20241030:072325.591 recovery events  : 0 (2 slots)
  1407:20241030:072325.591 events:
  1407:20241030:072325.591 actions          : 0 (1009 slots)
  1407:20241030:072325.591 action conditions: 0 (1009 slots)
  1407:20241030:072325.591 In zbx_ipc_service_recv() timeout:1.000
  1406:20241030:072326.414 End of zbx_ipc_service_recv():2
  1406:20241030:072326.415 In zbx_ipc_async_socket_send()
  1406:20241030:072326.415 In zbx_ipc_client_send() clientid:0
  1406:20241030:072326.415 End of zbx_ipc_client_send():SUCCEED
  1406:20241030:072326.415 End of zbx_ipc_async_socket_send():SUCCEED
  1406:20241030:072326.415 In zbx_ipc_async_socket_flush() timeout:10
  1406:20241030:072326.415 End of zbx_ipc_async_socket_flush():0
  1406:20241030:072326.415 In zbx_ipc_service_recv() timeout:0.978
  1405:20241030:072326.415 zbx_ipc_service_recv() code:10001 size:0 data:
  1405:20241030:072326.415 End of zbx_ipc_service_recv():1
  1405:20241030:072326.415 In zbx_ipc_service_recv() timeout:1.000
  1407:20241030:072326.603 End of zbx_ipc_service_recv():2
  1407:20241030:072326.603 In zbx_ipc_service_recv() timeout:1.000
realloc(): invalid next size
  1405:20241030:072327.012 One child process died (PID:1408,exitcode/signal:6). Exiting ...
  1405:20241030:072327.012 End of zbx_ipc_service_recv():1
  1405:20241030:072327.013 In zbx_ipc_socket_close()
  1405:20241030:072327.013 End of zbx_ipc_socket_close()
  1405:20241030:072327.013 In zbx_ha_pause()
  1405:20241030:072327.013 In zbx_ipc_async_exchange() service:'haservice' code:1 timeout:10
  1405:20241030:072327.013 In zbx_ipc_async_socket_open()
  1405:20241030:072327.013 In zbx_ipc_socket_open()
  1405:20241030:072327.013 End of zbx_ipc_socket_open():SUCCEED
  1405:20241030:072327.013 End of zbx_ipc_async_socket_open():SUCCEED
  1405:20241030:072327.013 In zbx_ipc_async_socket_send()
  1405:20241030:072327.013 In zbx_ipc_client_send() clientid:0
  1405:20241030:072327.013 End of zbx_ipc_client_send():SUCCEED
  1405:20241030:072327.013 End of zbx_ipc_async_socket_send():SUCCEED
  1405:20241030:072327.013 In zbx_ipc_async_socket_flush() timeout:10
  1405:20241030:072327.013 End of zbx_ipc_async_socket_flush():0
  1405:20241030:072327.013 In zbx_ipc_async_socket_recv() timeout:10
  1406:20241030:072327.013 In ipc_service_accept()
  1406:20241030:072327.013 In ipc_service_add_client()
  1406:20241030:072327.013 End of ipc_service_add_client() clientid:2
  1406:20241030:072327.013 End of ipc_service_accept()
  1406:20241030:072327.013 End of zbx_ipc_service_recv():2
  1406:20241030:072327.013 In zbx_ipc_service_recv() timeout:0.380
  1406:20241030:072327.013 zbx_ipc_service_recv() code:1 size:0 data:
  1406:20241030:072327.013 End of zbx_ipc_service_recv():1
  1406:20241030:072327.013 In zbx_ipc_client_send() clientid:2
  1406:20241030:072327.013 End of zbx_ipc_client_send():SUCCEED
  1406:20241030:072327.013 HA manager has been paused
  1406:20241030:072327.013 In zbx_ipc_service_recv() timeout:5.000
  1405:20241030:072327.013 zbx_ipc_async_socket_recv() code:1 size:0 data:
  1405:20241030:072327.013 End of zbx_ipc_async_socket_recv():0
  1405:20241030:072327.013 In zbx_ipc_async_socket_close()
  1405:20241030:072327.013 In zbx_ipc_socket_close()
  1405:20241030:072327.013 End of zbx_ipc_socket_close()
  1405:20241030:072327.013 End of zbx_ipc_async_socket_close()
  1405:20241030:072327.013 End of zbx_ipc_async_exchange():SUCCEED
  1405:20241030:072327.013 End of zbx_ha_pause():SUCCEED
  1405:20241030:072327.013 zbx_on_exit() called with ret:-1
  1406:20241030:072327.014 End of zbx_ipc_service_recv():1
  1406:20241030:072327.014 In ha_db_update_lastaccess() ha_status:active
  1406:20241030:072327.014 query [txnlev:1] [begin;]
  1405:20241030:072327.014 In zbx_ha_stop()
  1405:20241030:072327.014 In zbx_ipc_async_exchange() service:'haservice' code:2 timeout:10
  1405:20241030:072327.014 In zbx_ipc_async_socket_open()
  1405:20241030:072327.014 In zbx_ipc_socket_open()
  1405:20241030:072327.014 End of zbx_ipc_socket_open():SUCCEED
  1405:20241030:072327.014 End of zbx_ipc_async_socket_open():SUCCEED
  1405:20241030:072327.014 In zbx_ipc_async_socket_send()
  1405:20241030:072327.014 In zbx_ipc_client_send() clientid:0
  1405:20241030:072327.014 End of zbx_ipc_client_send():SUCCEED
  1405:20241030:072327.014 End of zbx_ipc_async_socket_send():SUCCEED
  1405:20241030:072327.014 In zbx_ipc_async_socket_flush() timeout:10
  1405:20241030:072327.014 End of zbx_ipc_async_socket_flush():0
  1405:20241030:072327.014 In zbx_ipc_async_socket_recv() timeout:10
  1406:20241030:072327.015 query [txnlev:1] [select null from ha_node order by ha_nodeid for update]
  1406:20241030:072327.021 query [txnlev:1] [update ha_node set lastaccess=unix_timestamp() where ha_nodeid='cm162wiza0001slr3m80xc61t']
  1406:20241030:072327.025 query [txnlev:1] [commit;]
  1406:20241030:072327.027 End of ha_db_update_lastaccess()
  1406:20241030:072327.027 In zbx_ipc_socket_close()
  1406:20241030:072327.027 End of zbx_ipc_socket_close()
  1406:20241030:072327.027 In zbx_ipc_service_recv() timeout:5.000
  1406:20241030:072327.028 In ipc_service_accept()
  1406:20241030:072327.028 In ipc_service_add_client()
  1406:20241030:072327.028 End of ipc_service_add_client() clientid:3
  1406:20241030:072327.028 End of ipc_service_accept()
  1406:20241030:072327.028 End of zbx_ipc_service_recv():2
  1406:20241030:072327.028 In ha_db_update_lastaccess() ha_status:active
  1406:20241030:072327.028 query [txnlev:1] [begin;]
  1406:20241030:072327.028 query [txnlev:1] [select null from ha_node order by ha_nodeid for update]
  1406:20241030:072327.029 query [txnlev:1] [update ha_node set lastaccess=unix_timestamp() where ha_nodeid='cm162wiza0001slr3m80xc61t']
  1406:20241030:072327.031 query [txnlev:1] [commit;]
  1406:20241030:072327.031 End of ha_db_update_lastaccess()
  1406:20241030:072327.032 In zbx_ipc_service_recv() timeout:5.000
  1406:20241030:072327.032 zbx_ipc_service_recv() code:2 size:0 data:
  1406:20241030:072327.032 End of zbx_ipc_service_recv():1
  1406:20241030:072327.032 In ha_db_update_lastaccess() ha_status:active
  1406:20241030:072327.032 query [txnlev:1] [begin;]
  1406:20241030:072327.032 query [txnlev:1] [select null from ha_node order by ha_nodeid for update]
  1406:20241030:072327.033 query [txnlev:1] [update ha_node set lastaccess=unix_timestamp() where ha_nodeid='cm162wiza0001slr3m80xc61t']
  1406:20241030:072327.034 query [txnlev:1] [commit;]
  1406:20241030:072327.036 End of ha_db_update_lastaccess()
  1406:20241030:072327.036 In zbx_ipc_client_send() clientid:3
  1406:20241030:072327.036 End of zbx_ipc_client_send():SUCCEED
  1406:20241030:072327.036 query [txnlev:1] [begin;]
  1405:20241030:072327.036 zbx_ipc_async_socket_recv() code:2 size:0 data:
  1405:20241030:072327.036 End of zbx_ipc_async_socket_recv():0
  1405:20241030:072327.036 In zbx_ipc_async_socket_close()
  1405:20241030:072327.036 In zbx_ipc_socket_close()
  1405:20241030:072327.036 End of zbx_ipc_socket_close()
  1405:20241030:072327.036 End of zbx_ipc_async_socket_close()
  1405:20241030:072327.036 End of zbx_ipc_async_exchange():SUCCEED
  1406:20241030:072327.036 query [txnlev:1] [select null from ha_node order by ha_nodeid for update]
  1406:20241030:072327.037 query [txnlev:1] [update ha_node set status=1 where ha_nodeid='cm162wiza0001slr3m80xc61t']
  1406:20241030:072327.040 query [txnlev:1] [insert into auditlog (auditid,userid,username,clock,action,ip,resource_cuid,resourcename,resourcetype,recordsetid,details) values ('cm2vjvgsg000e32rev6vebln3',null,'System','1730273007','1','','cm162wiza0001slr3m80xc61t','',47,'cm2vjvgsg000f32reddhfppm6','{"hanode.status":["update",1,3]}')]
  1406:20241030:072327.045 query [txnlev:1] [commit;]
  1406:20241030:072327.046 In zbx_ipc_async_socket_close()
  1406:20241030:072327.046 In zbx_ipc_socket_close()
  1406:20241030:072327.046 End of zbx_ipc_socket_close()
  1406:20241030:072327.046 End of zbx_ipc_async_socket_close()
  1406:20241030:072327.046 In zbx_ipc_service_close() path:/run/zabbix/zabbix_server_haservice.sock
  1406:20241030:072327.046 In zbx_ipc_socket_close()
  1406:20241030:072327.046 End of zbx_ipc_socket_close()
  1406:20241030:072327.046 End of zbx_ipc_service_close()
  1406:20241030:072327.046 HA manager has been stopped
  1405:20241030:072327.049 End of zbx_ha_stop():SUCCEED
  1405:20241030:072327.049 In free_selfmon_collector() collector:0x7f1668ef9000
  1405:20241030:072327.049 End of free_selfmon_collector()
  1405:20241030:072327.049 In zbx_unload_modules()
  1405:20241030:072327.049 End of zbx_unload_modules()
  1405:20241030:072327.049 Zabbix Server stopped. Zabbix 6.0.35 (revision 8a9017e52e7).