-
Type:
Problem report
-
Resolution: Duplicate
-
Priority:
Critical
-
None
-
Affects Version/s: 7.0.32
-
Component/s: Server (S)
-
None
-
Support backlog
A DB configuration backup has been, made without transporting historical data. These tables are empty:
history_uint history history_str history_text history_log
Size of instance is CacheSize=5G
After booting up the application layer, the "history syncer" process generates a loop
747:20261105:071132.638 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock>1792559492] 747:20261105:071132.755 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=0 order by clock desc limit 2] 747:20261105:071132.755 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=1 order by clock desc limit 2] 747:20261105:071132.757 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=2 order by clock desc limit 2] 747:20261105:071132.757 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=3 order by clock desc limit 2] 747:20261105:071132.758 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=4 order by clock desc limit 2] 747:20261105:071132.758 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=5 order by clock desc limit 2] 747:20261105:071132.758 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=6 order by clock desc limit 2] 747:20261105:071132.758 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=7 order by clock desc limit 2] 747:20261105:071132.758 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=8 order by clock desc limit 2]
The itemid=10906375 is "Zabbix trapper" item with trigger logic:
length(last(/hostName/dynamic_blackout))>0
"systemctl stop zabbix-server" does not have enough priority to stop:
525:20261105:071158.167 Got signal [signal:15(SIGTERM),sender_pid:787,sender_uid:0,reason:0]. Exiting ... 525:20261105:071158.167 In zbx_ipc_client_send() clientid:2 747:20261105:071158.167 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=173787 order by clock desc limit 2] 529:20261105:071158.167 End of zbx_ipc_async_socket_recv():0 529:20261105:071158.167 In zbx_ipc_async_socket_close() 525:20261105:071158.167 End of zbx_ipc_client_send():SUCCEED 525:20261105:071158.167 In zbx_ipc_socket_open() 529:20261105:071158.167 In zbx_ipc_socket_close() 528:20261105:071158.167 In ipc_service_accept() 528:20261105:071158.167 In ipc_service_add_client() 528:20261105:071158.167 End of ipc_service_add_client() clientid:3 528:20261105:071158.167 End of ipc_service_accept() 528:20261105:071158.167 End of zbx_ipc_service_recv():2 528:20261105:071158.167 In zbx_ipc_service_recv() timeout:1.000 747:20261105:071158.167 query [txnlev:1] [select clock,ns,value from history_text where itemid=10906375 and clock<=173788 order by clock desc limit 2]
The simulation has been done with 1:1 these zabbix_server.conf settings:
CacheSize=5G
DBName=zabbix
DBPassword=password
DBUser=zabbix
DebugLevel=4
EnableGlobalScripts=0
HousekeepingFrequency=0
LogFileSize=0
LogFile=/var/log/zabbix/zabbix_server.log
MaxConcurrentChecksPerPoller=1
PidFile=/run/zabbix/zabbix_server.pid
SocketDir=/run/zabbix
StartAgentPollers=0
StartAlerters=1
StartBrowserPollers=0
StartDBSyncers=1
StartDiscoverers=0
StartEscalators=1
StartHistoryPollers=0
StartHTTPAgentPollers=0
StartHTTPPollers=0
StartJavaPollers=0
StartLLDProcessors=1
StartODBCPollers=0
StartPingers=0
StartPollers=0
StartPollersUnreachable=0
StartPreprocessors=1
StartProxyPollers=0
StartSNMPPollers=0
StartTimers=1
StartTrappers=0
StartVMwareCollectors=0
StatsAllowedIP=127.0.0.1
For this example because "StartTrappers" is 0, there are no input points for "Zabbix trapper" item. Trigger should not evaluate.
"StartHistoryPollers=0" should not allow "Calculated" item to fetch data.