Zabbix Proxy - proxy_history database growing uncontrollably

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Major
    • None
    • Affects Version/s: 4.2.5, 4.2.6
    • Component/s: Proxy (P)
    • Environment:
      CentOS Linux release 7.6.1810 (Core), MariaDB 10.0.38-1.el7.centos , Zabbix-Proxy 4.2.6.

      Steps to reproduce:

      1. Installed Proxy in an environment with 57 hosts. Works normally for a few weeks.
      2. Rapid use of diskspace occurs. The culprit is the table proxy_history , which fills the root partition. The size is over 35GB.
      3. The Zabbix proxy halts as the root partition is full.

      Result:

      select count(itemid) from proxy_history;
      
      +---------------+
      | count(itemid) |
      +---------------+
      | 222263503     |
      +---------------+
      
      1 row in set (2 min 56.82 sec)
      

      between UNIX timestamps 1563522801 and 1569842893.

      Expected:
      Consistent use of disk space, not perpetual growth.

       

      Possible cause:

      Zabbix sender items in template. 

            Assignee:
            Elina Kuzyutkina (Inactive)
            Reporter:
            Antti Koskenvoima
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: