zabbix_server doesn't check data type, returned by client.
Test case:
zabbix agent active check. Data type -- numeric fload.
returned value "1203205254000.000000".
zabbix_server die with log message:
46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.
After changing Data type to Numeric (64bit) zabbix_server die, when updating trends table.
Test case:
zabbix agent active check. Data type -- numeric fload.
returned value "1203205254000.000000".
zabbix_server die with log message:
46208:20080216:235011 Query::insert into history (clock,itemid,value) values (1203205811,25536,1203205254000.000000)
46208:20080216:235011 Query failed:PGRES_FATAL_ERROR:ERROR: numeric field overflow
DETAIL: A field with precision 16, scale 4 must round to an absolute value less than 10^12.
After changing Data type to Numeric (64bit) zabbix_server die, when updating trends table.
Comment