prometheus/mysqld_exporter

`sql: Scan error on column index 0, name \"SUM_COUNT_STAR\": converting NULL to uint64 is unsupported`

fzyzcjy opened this issue · 1 comments

Host operating system: output of uname -a

ubuntu

mysqld_exporter version: output of mysqld_exporter --version

latest

MySQL server version

latest

mysqld_exporter command line flags

            --config.my-cnf="/tmp/.my.cnf" \
            --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.query_response_time \
            --collect.info_schema.replica_host \
            --collect.info_schema.tables \
            --collect.info_schema.tablestats \
            --collect.info_schema.schemastats \
            --collect.info_schema.userstats \
            --collect.mysql.user \
            --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 \
            --collect.perf_schema.replication_group_members \
            --collect.perf_schema.replication_group_member_stats \
            --collect.perf_schema.replication_applier_status_by_worker \
            --collect.slave_status \
            --collect.slave_hosts \
            --collect.sys.user_summary

What did you do that produced an error?

look at it

What did you expect to see?

no error

What did you see instead?

ts=2023-07-20T06:33:34.765Z caller=exporter.go:173 level=error msg="Error from scraper" scraper=perf_schema.eventsstatementssum target=... err="sql: Scan error on column index 0, name "SUM_COUNT_STAR": converting NULL to uint64 is unsupported"

I am encountering same error when attempting to run the exporter using the latest docker image. However, building the exe file does not produce any errors.