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

zabbix-agent2 mysql status monitoring

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 5.0.1
    • Agent (G)
    • None
    • Centos 8, MariaDB

      Steps to reproduce:

      1. Deployed zabbix-agent2 in MariaDB instance to monitor database related services. Most parameter updates are wokring but the MySQL status is not working as expected. Able to show DOWN status but status remains DOWN eventhough the service is already running on the monitored host. Status is only updated after the zabbix-agent2 on the host is restarted
      2. Stop MariaDB service on monitored host
      3. Status shown as DOWN on Zabbix server dashboard
      4. Started MariaDB service on monitored host and verified status running locally
      5. Status on Zabbix server still remains down even after few hours
      6. Restarted zabbix-agent2 on monitored host
      7. Status on Zabbix server upated to up
      8. ...

      Result:
      Screenshot below showing the status in zabbix server for mariadb services stopped

      Real status of MariaDB service on the monitored host:

      The log below showing the zabbix-agent2 activity

      2020/07/09 16:32:35.945539 failed to execute direct exporter task for key 'mysql.get_status_variables["tcp://localhost:3306","<username>","<password>"]' error: 'sql: database is closed'
      2020/07/09 16:32:36.947989 received passive check request: 'mysql.ping["tcp://localhost:3306","<username>","<password>"]' from '<zabbix_server_IP>'
      2020/07/09 16:32:36.948069 [1] adding new request for key: 'mysql.ping["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:36.948075 [1] created direct exporter task for plugin 'Mysql' itemid:0 key 'mysql.ping["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:36.948108 executing direct exporter task for key 'mysql.ping["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:36.948128 executed direct exporter task for key 'mysql.ping["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:37.949634 received passive check request: 'mysql.version["tcp://localhost:3306","<username>","<password>"]' from '<zabbix_server_IP>'
      2020/07/09 16:32:37.949728 [1] adding new request for key: 'mysql.version["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:37.949738 [1] created direct exporter task for plugin 'Mysql' itemid:0 key 'mysql.version["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:37.949791 executing direct exporter task for key 'mysql.version["tcp://localhost:3306","<username>","<password>"]'
      2020/07/09 16:32:37.949813 failed to execute direct exporter task for key 'mysql.version["tcp://localhost:3306","<username>","<password>"]' error: 'sql: database is closed'

      When running the command shown in logs, able to get value of the service running

      [root@clusternode1-db ~]# zabbix_agent2 -t mysql.ping["tcp://localhost:3306","<username>","<password>"]
      mysql.ping[tcp://localhost:3306,<username>,<password>][s|1]

       

      Testing from zabbix server template gave different results

      Expected:
      The status should show up like how it is for zabbix-agentd

        1. image-2020-07-09-17-44-24-443.png
          image-2020-07-09-17-44-24-443.png
          55 kB
        2. image-2020-07-09-17-45-33-416.png
          image-2020-07-09-17-45-33-416.png
          59 kB
        3. image-2020-07-09-17-52-32-463.png
          image-2020-07-09-17-52-32-463.png
          48 kB
        4. image-2020-07-13-11-09-05-695.png
          image-2020-07-13-11-09-05-695.png
          75 kB
        5. image-2020-07-13-11-09-43-962.png
          image-2020-07-13-11-09-43-962.png
          89 kB
        6. image-2020-07-13-11-10-39-593.png
          image-2020-07-13-11-10-39-593.png
          78 kB
        7. zabbix_agent2.conf
          17 kB
        8. zabbix_agent2.log
          8.30 MB
        9. zabbix_agent2-1.conf
          17 kB

            esneiders Eriks Sneiders
            awis Mohammad Awis Rusli
            Team INT
            Votes:
            4 Vote for this issue
            Watchers:
            11 Start watching this issue

              Created:
              Updated:
              Resolved: