# Metricbeat: Error 1054: Unknown column 'quantile\_95' in 'field list'

**URL:** <https://discuss.elastic.co/t/metricbeat-error-1054-unknown-column-quantile-95-in-field-list/258190>\
**Category:** Beats\
**Tags:** metricbeat\
**Created:** [December 9, 2020, 9:32pm UTC](https://discuss.elastic.co/t/metricbeat-error-1054-unknown-column-quantile-95-in-field-list/258190 "2020-12-09T21:32:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gnumoksha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gnumoksha/32/37220_2.png) [@gnumoksha](https://discuss.elastic.co/u/gnumoksha)\
**Post date:** [December 9, 2020, 9:32pm UTC](https://discuss.elastic.co/t/metricbeat-error-1054-unknown-column-quantile-95-in-field-list/258190/1 "2020-12-09T21:32:50Z")

</div>

- 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

```auto

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

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

```

```auto
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]

```

```auto
$ 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')

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 6, 2021, 11:32pm UTC](https://discuss.elastic.co/t/metricbeat-error-1054-unknown-column-quantile-95-in-field-list/258190/2 "2021-01-06T23:32:51Z")

</div>

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