Skip to content

Unknown column 'SUM_CPU_TIME' in 'SELECT'" #905

Closed
@nbari

Description

Host operating system: output of uname -a

Linux test 5.14.0-503.15.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Nov 14 15:45:31 EST 2024 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

mysqld_exporter, version 0.16.0 (branch: HEAD, revision: c366424252a3140838a344a6cb0d40d44f1be91d)
  build user:       root@ad5ebc2e1a44
  build date:       20241108-16:00:22
  go version:       go1.23.3
  platform:         linux/amd64
  tags:             unknown

MySQL server version

  * 11.4.4  MariaDB Server
  * 10.11.9 MariaDB Server

mysqld_exporter command line flags

/usr/local/bin/mysqld_exporter --config.my-cnf=/home/mysql/.exporter.my.cnf \
  --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.processlist \
  --collect.info_schema.query_response_time \
  --collect.perf_schema.eventsstatements \
  --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?

upgrade to latest mysqld_exporter 0.16 from 0.14

What did you expect to see?

No errors when scraping

What did you see instead?

level=ERROR source=exporter.go:160 msg="Error from scraper" scraper=perf_schema.eventsstatements target=/tmp/mysql.sock err="Error 1054 (42S22): Unknown column 'SUM_CPU_TIME' in 'SELECT'"

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions