Moin all.
We use bitnami/mysqld-exporter:0.12.1-debian-10-r10
to scrape our mariadb:10.5.8
container for metrics. Most metrics are successfully read, however a few seem to cause issues. We get the following errors in the logs for every scrape run:
time="2021-04-27T11:34:56Z" level=error msg="Error scraping for collect.info_schema.innodb_cmpmem: Error 1227: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation" source="exporter.go:171"
time="2021-04-27T11:34:56Z" level=error msg="Error scraping for collect.info_schema.innodb_cmp: Error 1227: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation" source="exporter.go:171"
time="2021-04-27T11:34:56Z" level=error msg="Error scraping for collect.slave_status: Error 1227: Access denied; you need (at least one of) the SUPER, REPLICATION SLAVE ADMIN privilege(s) for this operation" source="exporter.go:171"
There is nothing fancy about the MariaDB deployment, and the mysqld_exporter
is configured as outlined in GitHub - prometheus/mysqld_exporter: Exporter for MySQL server metrics So we’re a bit puzzled why these errors show up.
Did anyone else run into this and solve it?
Thanks for any hints!