-
Problem report
-
Resolution: Fixed
-
Minor
-
6.0.35
-
None
-
S24-W44/45, S24-W46/47
-
0.25
"zabbix-server" does not boot up and shows the logs:
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).