[ZBX-6558] PostgreSQL - profiles.value_int integer out of range Created: 2013 May 02  Updated: 2017 May 30  Resolved: 2013 May 13

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.0.5
Fix Version/s: 2.0.7rc1

Type: Incident report Priority: Minor
Reporter: Thomas Wouters Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: bigint, distributed, postgresql, schema
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

PostgreSQL


 Description   

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]

 Comments   
Comment by Oleg Egorov (Inactive) [ 2013 May 09 ]

FIXED IN svn://svn.zabbix.com/branches/dev/ZBX-6558 r35513

Comment by Alexander Vladishev [ 2013 May 16 ]

Successfully tested!

Comment by Oleg Egorov (Inactive) [ 2013 May 16 ]

FIXED IN 2.0.7 r35677
CLOSED

Generated at Fri Apr 26 21:38:45 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.