zabbix agent returns big value (>10 trillions)

[dakol]

I realized one of my counter changed to "unsupported" a few days ago:

Item:
type: float
store as: delta (speed per second)

The Zabbix Server log says:

16254:20100419:173338.711 Item
[zabbix-dbostgresql.alldatabase.stats[tup_returned]]
error: Type of received value [1091552245463] is not suitable for value type [Numeric (float)]

zabbix_get works and returns (without space): 1 091 663 520 114

I suspect i got caught by:

src/libs/zbxsysinfo/sysinfo.c:622
=> if (SUCCEED != DBchk_double(value_double))
=> break;

which complains when value is < -1*10^12 or > 1*10^12

[alixen]

Hi,

There are several bug reports on this topic:

https://support.zabbix.com/browse/ZBX-1126

https://support.zabbix.com/browse/ZBX-2272

However, first one is still open, and second one closed with "Won't fix".

Due to this bug, network monitoring is broken for some of our servers since we upgraded to 1.8.2.
So I hope that Zabbix development team will really fix it.

Regards,
Alixen

[dakol]

Hi,

There are several bug reports on this topic:

https://support.zabbix.com/browse/ZBX-1126

https://support.zabbix.com/browse/ZBX-2272

However, first one is still open, and second one closed with "Won't fix".

Due to this bug, network monitoring is broken for some of our servers since we upgraded to 1.8.2.
So I hope that Zabbix development team will really fix it.

ok, i patched my rc/libs/zbxsysinfo/sysinfo.c and it works again
Hope there is no collateral dammage.

- register double pg_min_numeric = (double)-1E12;
- register double pg_max_numeric = (double)1E12;
+ register double pg_min_numeric = (double)-1E15;
+ register double pg_max_numeric = (double)1E15;

[kmradke]

I changed my network values to "Numeric (Unsigned)" in my Solaris OS template. Also seems to work around the range problem, but is truncating the returned values. (I'm not too concerned about the fractional bytes per second though...)