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

Zabbix SQL Query causing 100% Usage with MariaDB Makes Zabbix Unusable

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Duplicate
    • None
    • None
    • None
    • Three RHEL 8.5 nodes with 2 CPUs, 4 GB RAM. Web front end with MariaDB on one node, Zabbix Server on 2 other nodes in HA configuration

    Description

      Steps to reproduce:

      1. Upgrade to Zabbix 6.0.1
      2. Login into Zabbix front end
      3. Observe very slow load times on zabbix dashboard and zabbix server timeout 
      4. run top command and saw MariaDB process taking 100% of 1 CPU of a 2 CPU system
      5. Review zabbix server logs
      6. Identify query
      7. run tests while connected to zabbix database to verify log query times

      Result:
      See zabbix_server_timeout screenshot...

      See zabbix_server_logs screenshot...

      See attached zabbix_sql_query.txt...

      Expected:
      No Zabbix server timeouts and normal load times

      Attachments

        1. server.cnf
          1 kB
        2. table_size.csv
          0.8 kB
        3. trigger_query.csv
          3 kB
        4. zabbix_server_logs.png
          zabbix_server_logs.png
          48 kB
        5. zabbix_server_timeout.png
          zabbix_server_timeout.png
          23 kB
        6. zabbix_sql_query.txt
          0.3 kB

        Issue Links

          Activity

            People

              zabbix.dev Zabbix Development Team
              tjohnson Travis Johnson
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: