Ad Widget

Collapse

min function not working

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cpowers
    Junior Member
    • Mar 2006
    • 5

    #1

    min function not working

    As far as I can tell the min function will not work with the current zabbix 1.1beta. I have the issue on beta8 and have looked at the code in beta9 and the problem still exists. My history values are split across multiple tables depending on what type of data is stored, e.g. uint data is in the history_uint table. However the min function does a query just on the history table so the result will always be null for an item of data type uint. See src/zabbix_server/evalfunc.c:399 which contains the following line in 1.1beta9

    snprintf(sql,sizeof(sql)-1,"select min(value) from history where clock>%d and itemid=%d",now-parameter,item->itemid);


    Please let me know if I am missing something.
Working...