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

    • Icon: Problem report Problem report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • 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

      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

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

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

              Created:
              Updated:
              Resolved: