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

PostgreSQL - profiles.value_int integer out of range

    XMLWordPrintable

    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: