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

Possiblity for overloading id value in proxy_history table for PostgreSQL

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.15rc1, 2.0.2rc1, 2.1.0
    • Fix Version/s: 2.1.0
    • Component/s: Proxy (P)
    • Labels:
    • Environment:
      PostgreSQL 9.1

      Description

      We use serial4 for id column in the proxy_history table. That data type has 2147483647 (2^31-1) max value. When this values will been reached, zabbix proxy will stop with error "ERROR: integer out of range".

      For example:
      zabbix=# select currval('proxy_history_id_seq'::regclass);
      currval
      ------------
      2147521882
      (1 row)

      zabbix=# select (2147483647-2147521882);
      ?column?
      ----------
      -38235
      (1 row)

      zabbix=# insert into proxy_history (itemid,clock,value) values (691037,1341975437,'13.000000') RETURNING id;
      ERROR: integer out of range
      zabbix=# insert into proxy_history (itemid,clock,value) values (60438,1341975438,'285.000000') RETURNING id;
      ERROR: integer out of range

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dotneft Alexey Pustovalov
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: