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

Details

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

    Description

      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;

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: