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

    • Incident report
    • Resolution: Fixed
    • Major
    • 2.1.0
    • 1.8.15rc1, 2.0.2rc1, 2.1.0
    • Proxy (P)
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: