-
Incident report
-
Resolution: Fixed
-
Minor
-
2.0.5
-
PostgreSQL
Zabbix schema should be updated to make profiles.value_int a bigint since integer seems to be too small (probably only in the case of DM setups):
pg_query(): Query failed: ERROR: integer out of range [include/db.inc.php:511]
Error in query [UPDATE profiles SET value_int=100100000010089, type=2 WHERE userid=100100000000005 AND idx='web.avail_report.0.hostid' AND profileid BETWEEN 100000000000000 AND 199999999999999] [ERROR: integer out of range]
pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:511]
Error in query [UPDATE profiles SET value_id=100100000010089, type=1 WHERE userid=100100000000005 AND idx='web.latest.hostid' AND profileid BETWEEN 100000000000000 AND 199999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [include/db.inc.php:511]
Error in query [UPDATE profiles SET value_id=100100000010089, type=1 WHERE userid=100100000000005 AND idx='web.reports.hostid' AND profileid BETWEEN 100000000000000 AND 199999999999999] [ERROR: current transaction is aborted, commands ignored until end of transaction block]