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

With very long proxy_histories, the id value of proxy_history can reach its limits

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • Proxy (P)
    • None

      The ID column of the proxy_history table in postgres is an INT. If your max id from proxy_history_id_seq reaches the limit of max::int, then your proxy won't be able to insert and your server won't receive data any more.

      Solution:

      alter table proxy_history alter column id type bigint;

            Unassigned Unassigned
            bignose Jeff MacDonald
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: