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

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 2.1.0
    • 1.8.15rc1, 2.0.2rc1, 2.1.0
    • Proxy (P)
    • PostgreSQL 9.1

      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

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

              Created:
              Updated:
              Resolved: