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

DB eats memory on Zabbix server stop if StartReportWriters and WebServiceURL are activated

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 5.4.0rc2
    • Server (S)
    • None
    • Debian 10.9
      CPU: Intel Core i3-4350
      Mem: 7,6Gi
      Swap: 30Gi
      DB: postgresql 11.12-0+deb10u1

      Steps to reproduce:

      1. Changes in configuration /etc/zabbix/zabbix_server.conf:
        StartReportWriters=1
        WebServiceURL=http://localhost:10053/report
      2. Stop zabbix-server

      Result:

      1. Zabbix-server log has a lot of records like
        update trends set num=41,value_min=52,value_avg=55.878048780487809,value_max=59 where itemid=27341 and clock=1621051200;
        update trends set num=42,value_min=0,value_avg=0,value_max=0 where itemid=27371 and clock=1621051200;
        update trends set num=41,value_min=0,value_avg=0,value_max=0 where itemid=24948 and clock=1621051200;
        update trends set num=42,value_min=0,value_avg=0,value_max=0 where itemid=24545 and clock=1621051200;
        update trends set num=42,value_min=99.072913999999997,value_avg=99.483465809523793,value_max=99.783007999999995 where itemid=26343 and clock=1621051200;
        update trends set num=41,value_min=0,value_avg=0,value_max=0 where itemid=25599 and clock=1621051200;
        update trends set num=41,value_min=0,value_avg=0,value_max=0 where itemid=25433 and clock=1621051200;
        update trends set num=41,value_min=55,value_avg=58.804878048780488,value_max=63 where itemid=27338 and clock=1621051200;
      2. postgres zabbix zabbix UPDATE process eats memory (RAM+SWAP) until OOM takes place
      3. after that postgres fails with 'FATAL: the database system is in recovery mode' messages
      4. Deactivating StartReportWriters or WebServiceURL lead to normal working.

      Expected:
      Zabbix server start/stops normally of StartReportWriters and WebServiceURL are active.

            zabbix.support Zabbix Support Team
            Islamov Damir
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: