Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6558

PostgreSQL - profiles.value_int integer out of range

    Details

      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]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              twouters Thomas Wouters
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: