Ad Widget

Collapse

History is storing wrong values

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • registration_is_lame
    Senior Member
    • Nov 2007
    • 148

    #1

    History is storing wrong values

    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)


    Click image for larger version

Name:	zabbix.PNG
Views:	216
Size:	37.3 KB
ID:	381364


  • registration_is_lame
    Senior Member
    • Nov 2007
    • 148

    #2
    Figured out the issue. There was a Preprocessing rule which was a boolean type. Removing it resolved the issue.

    Click image for larger version

Name:	zabbix.PNG
Views:	200
Size:	15.0 KB
ID:	381369

    Comment

    Working...