MariaDB 10.6.* - 10.8.* - Unknown column 'SPACE_TYPE'

[rtuk]

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: ca1b9af82a471c849c529eb8aadb1aac73e7b68c) 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'"

[tuananh170489]

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'"

You could disable metric innodb_tablespaces because SPACE_TYPE had been removed from MariaDB 10.5.0 Ref https://mariadb.com/kb/en/mariadb-1050-release-notes/