Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SPACE_TYPE Error while querying innodb_tablespaces #528

Open
jzielke84 opened this issue Feb 2, 2021 · 1 comment
Open

SPACE_TYPE Error while querying innodb_tablespaces #528

jzielke84 opened this issue Feb 2, 2021 · 1 comment

Comments

@jzielke84
Copy link

Host operating system: output of uname -a

Linux myhost01 4.9.0-14-amd64 #1 SMP Debian 4.9.246-2 (2020-12-17) x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.12.1 (branch: HEAD, revision: 48667bf)
build user: root@0b3e56a7bc0a
build date: 20190729-12:35:58
go version: go1.12.7

MySQL server version

mysql Ver 15.1 Distrib 10.1.48-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

mysqld_exporter command line flags

        --collect.auto_increment.columns \
        --collect.binlog_size \
        --collect.engine_innodb_status \
        --collect.global_status \
        --collect.global_variables \
        --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.tables \
        --collect.info_schema.tablestats \
        --collect.info_schema.schemastats \
        --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.tableiowaits \
        --collect.perf_schema.tablelocks

What did you do that produced an error?

Starte the exporter

What did you expect to see?

No errors

What did you see instead?

mysql_exporter[6826]: time="2021-02-02T10:16:22+01:00" level=error msg="Error scraping for collect.info_schema.innodb_tablespaces: Error 1054: Unknown column 'SPACE_TYPE' in 'field list'" source="expor

@Guzzi
Copy link

Guzzi commented Apr 29, 2021

I observe the same error with 0.13.0.rc0 on mariadb 10.5.8
Diasabling info_schema.innodb_tablespaces makes the error line disappear.

hggh pushed a commit to hggh/mysqld_exporter that referenced this issue Feb 24, 2022
The SPACE_TYPE column was introduced in MariaDB 10.2.1 and removed
in MariaDB 10.5.0.
hggh pushed a commit to hggh/mysqld_exporter that referenced this issue Feb 24, 2022
The SPACE_TYPE column was introduced in MariaDB 10.2.1 and removed
in MariaDB 10.5.0.

Signed-off-by: Jonas Genannt <jge@scireum.de>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants