how value is store in DB - type of data

[Gigoudt]

Hi,

i am facing to a problem and want to figure out how tha data is store in de database.


Item used

zabbix agent key ssh,22 numeric (unsigned)

data is store in history_uint and trends_uint

the problem is when i have a value that is 0 the whole hour goes to 0 in trend_uint_avg.

history

1 08.00
1 08.10
1 ..
1 ..
0 08.40
1 08.50

trends_uint.value_avg for that hour is 0

trends_uint.value_avg goes to 0 not to 1 that is how i guess it could be.
(mathematical average is 0,8333)

That is because zabbix store value as integer not as float. Do i have to change to float the item to use history and trend ? I create a item to see if this works.

I believe that zabbix use integer part cuting numers befor the "," instead of rounding to 1 the number.

thanks for help or any thread to read !!

bye

[richlv]

that's probably bug https://support.zabbix.com/browse/ZBX-3643

[Gigoudt]

Thanks Rich for reply !

we also made some new items and figure out that changing to float the error is solved. trends.value_avg is similar to real value !!!!

In you case it was even worse from the one that reported the bug because que had only 1 and 0 in the DB.

We are going to change items in templates. We had made improvements in availability with little effort!!!

We also see that when changing the type of data information is not lost in the DB. That is good , we dont want to lost avalability information . From the moment of the change, data before is in trend_uint and afterward data is in trends.

Thanks for response bye