-
Type:
Incident report
-
Resolution: Fixed
-
Priority:
Minor
-
Affects Version/s: 2.0.5
-
Component/s: Server (S)
-
Environment: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]