agent is sending value 3 but in history table the value is stored as 1. Checked latest data and it shows 1. Zabbix_get returns value 3 as well.
Item type: Zabbix agent
Type of information: Numeric (unsigned).
3861:20190626:054914.535 In zbx_popen() command:'mysql -uzabbix_agent -p'zabbix' -e "show slave status\G" | awk 'BEGIN {output=0} /Slave_IO_Running.*No/ {output+=1} /Slave_SQL_Running.*No/ {output +=2} END {if(output==3) print 0; else if (NR==0) print 4; else if(output==0) print 3; else print output}''
3861:20190626:054914.535 End of zbx_popen():6
3942:20190626:054914.536 zbx_popen(): executing script
3861:20190626:054914.559 In zbx_waitpid()
3861:20190626:054914.559 zbx_waitpid() exited, status:0
3861:20190626:054914.559 End of zbx_waitpid():3942
3861:20190626:054914.560 EXECUTE_STR() command:'mysql -uzabbix_agent -p'zabbix' -e "show slave status\G" | awk 'BEGIN {output=0} /Slave_IO_Running.*No/ {output+=1} /Slave_SQL_Running.*No/ {output +=2} END {if(output==3) print 0; else if (NR==0) print 4; else if(output==0) print 3; else print output}'' len:1 cmd_result:'3'
3861:20190626:054914.560 Sending back [3]
3861:20190626:054914.560 __zbx_zbx_setproctitle() title:'listener
History log:
(59474,1561531934,948089183,1)

Item type: Zabbix agent
Type of information: Numeric (unsigned).
3861:20190626:054914.535 In zbx_popen() command:'mysql -uzabbix_agent -p'zabbix' -e "show slave status\G" | awk 'BEGIN {output=0} /Slave_IO_Running.*No/ {output+=1} /Slave_SQL_Running.*No/ {output +=2} END {if(output==3) print 0; else if (NR==0) print 4; else if(output==0) print 3; else print output}''
3861:20190626:054914.535 End of zbx_popen():6
3942:20190626:054914.536 zbx_popen(): executing script
3861:20190626:054914.559 In zbx_waitpid()
3861:20190626:054914.559 zbx_waitpid() exited, status:0
3861:20190626:054914.559 End of zbx_waitpid():3942
3861:20190626:054914.560 EXECUTE_STR() command:'mysql -uzabbix_agent -p'zabbix' -e "show slave status\G" | awk 'BEGIN {output=0} /Slave_IO_Running.*No/ {output+=1} /Slave_SQL_Running.*No/ {output +=2} END {if(output==3) print 0; else if (NR==0) print 4; else if(output==0) print 3; else print output}'' len:1 cmd_result:'3'
3861:20190626:054914.560 Sending back [3]
3861:20190626:054914.560 __zbx_zbx_setproctitle() title:'listener
History log:
(59474,1561531934,948089183,1)
Comment