Metricbeat: Error 1054: Unknown column 'quantile_95' in 'field list'

Elastic Stack Beats
1
  • Version: metricbeat 7.10.0
  • Operating System: Linux agent01.monitoring.tflux.local 4.19.0-13-cloud-amd64 #1 SMP Debian 4.19.160-2 (2020-11-28) x86_64 GNU/Linux
  • Steps to Reproduce:

/etc/metricbeat/modules.d/mysql.yml


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

  hosts: ["user:pass@tcp(foo1.rds.amazonaws.com:3306)/", "user:pass@tcp(foo2.rds.amazonaws.com:3306)/"]

root@agent01:/etc/metricbeat# metricbeat version
metricbeat version 7.10.0 (amd64), libbeat 7.10.0 [1428d58cf2ed945441fb2ed03961cafa9e4ad3eb built 2020-11-09 20:08:47 +0000 UTC]

$ journalctl -f -u metricbeat
[...]
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]: 2020-12-09T21:25:20.120Z        ERROR        [mysql.performance]        query/query.go:92        error doing query {events_statements SELECT digest_text, count_star, avg_timer_wait, max_timer_wait, last_seen, quantile_95
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   FROM performance_schema.events_statements_summary_by_digest
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   ORDER BY avg_timer_wait DESC
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   LIMIT 10
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:  table %!s(bool=true)}%!(EXTRA *mysql.MySQLError=Error 1054: Unknown column 'quantile_95' in 'field list')
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]: 2020-12-09T21:25:20.169Z        ERROR        [mysql.performance]        query/query.go:92        error doing query {events_statements SELECT digest_text, count_star, avg_timer_wait, max_timer_wait, last_seen, quantile_95
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   FROM performance_schema.events_statements_summary_by_digest
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   ORDER BY avg_timer_wait DESC
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:   LIMIT 10
Dec 09 21:25:20 agent01.monitoring.foo.local metricbeat[903]:  table %!s(bool=true)}%!(EXTRA *mysql.MySQLError=Error 1054: Unknown column 'quantile_95' in 'field list')
2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.