Invalid command occurred because macro variable could not be read in the template.
Hi, I'm using Zabbix 3.0 Server and Proxy.
A special problem occurred yesterday.
That is Zabbix Passive Item failed to read the Macro variable declared in the template.
So, the agent encountered an error executing an invalid command.
As a result of examining the Postgre Query Log, a number of hosts table deletion and hosts_templates insertion occurred at that time.
It is estimated that Macro read failed in the above operation, but I want to know why these querys occurred.
Have a happy day.
A special problem occurred yesterday.
That is Zabbix Passive Item failed to read the Macro variable declared in the template.
So, the agent encountered an error executing an invalid command.
As a result of examining the Postgre Query Log, a number of hosts table deletion and hosts_templates insertion occurred at that time.
It is estimated that Macro read failed in the above operation, but I want to know why these querys occurred.
Have a happy day.
# pg_log
2023-02-07 14:15:24 delete from hosts where (hostid between 29861 and 29865 or hostid between 3995 and 34000 or ...
2023-02-07 14:18:43 insert into hosts_templates (hosttemplateid,hostid,templateid) values (1,10122,10086), ...
# zabbix agent log
normal : Executing command 'ps -ef | grep BBL | grep -v grep | wc -l'
abnormal : Executing command 'ps -ef | grep {$BBL_PROCESS} | grep -v grep | wc -l'
2023-02-07 14:15:24 delete from hosts where (hostid between 29861 and 29865 or hostid between 3995 and 34000 or ...
2023-02-07 14:18:43 insert into hosts_templates (hosttemplateid,hostid,templateid) values (1,10122,10086), ...
# zabbix agent log
normal : Executing command 'ps -ef | grep BBL | grep -v grep | wc -l'
abnormal : Executing command 'ps -ef | grep {$BBL_PROCESS} | grep -v grep | wc -l'