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

Report > Audit hang in Zabbix FE with GW Timeout when Auditlog Table have a big size

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.0.4
    • Frontend (F)
    • None
    • Zabbix 6.0.4
      Oracle Linux Server release 8.5
      PostgreSQL 13.6 + TimescaleDB 2.3.1

      Hi there, we upgrade ZABBIX from 5.0.4 to 6.0.4, but we don't change after that Data storage period for Audit table, and leave it to 365d. Now our auditlog table have 184.180.549 records (80GB), because of that ZBX FE hang (Error 604 GW Timeout) whent try use Report>Audit.

      Now we update the data storage to 30d but the housekeeper is runnig all the time and delete only a few records every 2 or 3 hours.

      To solve the FE issue, is possible segmente the query in Report>Audit and only return a few records every time?

      To solve de problem with HK, it-s possible use TSDB with auditlog table like history and trends?

      Like a Workarround Is possible force a truncate audit talbe?

      By the way, we use Postgres with TSDB over Oracle Linux8.

            zabbix.support Zabbix Support Team
            mobarrio Mariano Obarrio Miles
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: