使用 Metricbeat 监控 Mysql 状态出现报错。

Question

报错信息

配置信息

# Module: mysql
# Docs: https://www.elastic.co/guide/en/beats/metricbeat/7.x/metricbeat-module-mysql.html

- module: mysql
  metricsets:
    - status 
    - galera_status
    - performance
    - query
  period: 10s

  # Host DSN should be defined as "user:pass@tcp(127.0.0.1:3306)/"
  # or "unix(/var/lib/mysql/mysql.sock)/",
  # or another DSN format supported by <https://github.com/Go-SQL-Driver/MySQL/>.
  # The username and password can either be set in the DSN or using the username
  # and password config options. Those specified in the DSN take precedence.
  hosts: ["tcp(127.0.0.1:3306)/"]
  username: root
  password: 123456

  # Username of hosts. Empty by default.
  #username: root

  # Password of hosts. Empty by default.
  #password: secret

暂时解决办法

把 query 注释掉就行了，但是不清楚原因，请大佬解答

- module: mysql
  metricsets:
    - status 
    - galera_status
    - performance
    # - query # 注释掉这行就行了