zabbix "is too small or too large."

[glardz]

hello,

in zabbix server, i have this message :


10196:20190722:143038.827 error reason for "serverroc_info[oracle.exe,io_read_b,min]" changed: Value 2932490660328.000000 is too small or too large.



i put numeric(float)

[Atsushi]

The value seems to be too large in this case. Numeric(float) can only handle values from -999999999999.9999 to 999999999999.9999. Since the value acquired as an item is larger than this range, it may not have been saved as the item's value.
It seems to be a large value, so you can truncate it after the decimal point into an integer value and use Numeric(unsigned) to handle larger values.

https://www.zabbix.com/documentation/4.0/manual/config/items/item

[glardz]

i put Numeric(unsigned) but i have an error, 10194:20190723:065703.618 item "" became not supported: Value "11575224049.500000" of type "string" is not suitable for value type "Numeric (unsigned)", so i put Numeric(float) with preprocessing "custom multiplier" with 0.1 of value, that work but this is not real value, i have 1157522404.95 and i want 11575224049.5 , do you have an idea ?

[Atsushi]

The string must be an integer. As I wrote in yesterday's answer, it is necessary to cut off the decimal point.

ex.
from
11575224049.500000
change to
11575224049

If your version of Zabbix is 4.0 or later, you can use preprocessing to make the regular expression just a string before the decimal point.

[glardz]

thanks, can you give me the regular expression for pattern and output please

[Hamardaban]

pattern = ^(\d*)\.\d*$ output = \1

[glardz]

thanks but now i have this error with Type of information
Numeric (unsigned)Numeric (float)CharacterLogText :

4776:20190725:111925.817 error reason for "" changed: Preprocessing failed for: 39056000
1. Failed: cannot perform regular expression "^(\d*)\.\d*$" match for value of type "string": pattern does not match

[Hamardaban]

It's a value without a dot and the pattern did not fit. Use pattern ^(\d*)\.?\d*$

[glardz]

i have this message for all my host:

14370:20190725:134729.214 error reason for "serverroc_info[titi.exe,io_read_b,min]" changed: Value 71992140899512.000000 is too small or too large.


14371:20190725:140458.410 error reason for "" changed: Preprocessing failed for: 84
14372:20190725:140534.264 error reason for "" changed: Preprocessing failed for: 74
14370:20190725:140640.750 error reason for "]" changed: Value 1181552037615.000000 is too small or too large.
14372:20190725:140710.689 error reason for "" changed: Value 1181552529135.000000 is too small or too large.

i don't know what put, do you have an idea ?

[Hamardaban]

Numeric(float) can only handle values from -999999999999.9999 to 999999999999.9999.
https://www.zabbix.com/documentation...fig/items/item

Try change Type of information to Numeric (unsigned) - 64bit unsigned integer (after deleting a dot)