Host operating system: output of uname -a

Linux node01 5.4.0-124-generic #140-Ubuntu SMP Thu Aug 4 02:23:37 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.14.0 (branch: HEAD, revision: ca1b9af)
build user: root@401d370ca42e
build date: 20220304-16:25:15
go version: go1.17.8
platform: linux/amd64

MySQL server version

Server version: 10.8.4-MariaDB-1:10.8.4+maria~ubu2004-log mariadb.org binary distribution

mysqld_exporter command line flags

--config.my-cnf=/etc/.my.cnf
--collect.global_status
--collect.global_variables
--collect.engine_innodb_status
--collect.auto_increment.columns
--collect.binlog_size
--collect.slave_status
--collect.slave_hosts
--collect.info_schema.clientstats
--collect.info_schema.innodb_metrics
--collect.info_schema.innodb_tablespaces
--collect.info_schema.innodb_cmp
--collect.info_schema.innodb_cmpmem
--collect.info_schema.processlist
--collect.info_schema.query_response_time
--collect.info_schema.replica_host
--collect.info_schema.schemastats
--collect.info_schema.tablestats
--collect.info_schema.userstats
--collect.perf_schema.eventsstatements
--collect.perf_schema.eventsstatementssum
--collect.perf_schema.eventswaits
--collect.perf_schema.file_events
--collect.perf_schema.file_instances
--collect.perf_schema.indexiowaits
--collect.perf_schema.memory_events
--collect.perf_schema.tableiowaits
--collect.perf_schema.tablelocks

What did you do that produced an error?

Load metrics

What did you expect to see?

No errors in the log file

What did you see instead?

ts=2022-09-07T11:31:35.122Z caller=exporter.go:174 level=error msg="Error from scraper" scraper=info_schema.innodb_tablespaces err="Error 1054: Unknown column 'SPACE_TYPE' in 'field list'"