uint64: value out of range

[lyvivian0077]

Host operating system: output of uname -a

Linux mysql-test 3.10.0-1160.42.2.el7.x86_64 #1 SMP Tue Sep 7 14:49:57 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux

mysqld_exporter version: output of mysqld_exporter --version

[root@mysql-test ~]# mysqld_exporter --version
mysqld_exporter, version 0.15.1 (branch: HEAD, revision: cc349684494b5038ec5a52233bdca9eb9291e6f2)
  build user:       root@d89c15b9f5ad
  build date:       20231212-07:55:09
  go version:       go1.21.5
  platform:         linux/amd64
  tags:             unknown

MySQL server version

mysql  Ver 14.14 Distrib 5.7.40, for Linux (x86_64) using  EditLine wrapper

mysqld_exporter command line flags

ExecStart=/opt/prometheus/mysqld_exporter/mysqld_exporter \
          --collect.info_schema.processlist \
          --collect.info_schema.innodb_cmp \
          --collect.info_schema.innodb_cmpmem \
          --collect.mysql.user \
          --collect.perf_schema.eventsstatements \
          --collect.perf_schema.eventsstatements.digest_text_limit=10 \
          --collect.perf_schema.eventsstatementssum \
          --collect.perf_schema.eventswaits \
          --collect.perf_schema.file_events \
          --collect.perf_schema.file_instances.remove_prefix="/data/mysql/" \
          --collect.perf_schema.memory_events

Error output

Jun 18 15:51:13 mysql-test mysqld_exporter[30644]: ts=2024-06-18T06:51:13.643Z caller=exporter.go:173 level=error msg="Error from scraper" scraper=perf_schema.eventsstatementssum target=/tmp/mysql.sock err="sql: Scan error on column index 19, name \"SUM_SUM_TIMER_WAIT\": converting driver.Value type []uint8 (\"36463827771516430384\") to a uint64: value out of range"
Jun 18 15:51:30 mysql-test mysqld_exporter[30644]: ts=2024-06-18T06:51:30.535Z caller=exporter.go:173 level=error msg="Error from scraper" scraper=perf_schema.eventsstatementssum target=/tmp/mysql.sock err="sql: Scan error on column index 19, name \"SUM_SUM_TIMER_WAIT\": converting driver.Value type []uint8 (\"36464125564353364384\") to a uint64: value out of range"
Jun 18 15:51:44 mysql-test mysqld_exporter[30644]: ts=2024-06-18T06:51:44.244Z caller=exporter.go:173 level=error msg="Error from scraper" scraper=perf_schema.eventsstatementssum target=/tmp/mysql.sock err="sql: Scan error on column index 19, name \"SUM_SUM_TIMER_WAIT\": converting driver.Value type []uint8 (\"36464265664751892384\") to a uint64: value out of range"
Jun 18 15:51:59 mysql-test mysqld_exporter[30644]: ts=2024-06-18T06:51:59.121Z caller=exporter.go:173 level=error msg="Error from scraper" scraper=perf_schema.eventsstatementssum target=/tmp/mysql.sock err="sql: Scan error on column index 19, name \"SUM_SUM_TIMER_WAIT\": converting driver.Value type []uint8 (\"36464361035532091384\") to a uint64: value out of range"

SELECT performance_schema.events_statements_summary_by_digest

 root@localhost[(none)]> SELECT SUM(COUNT_STAR) AS SUM_COUNT_STAR, SUM(SUM_CREATED_TMP_DISK_TABLES) AS SUM_SUM_CREATED_TMP_DISK_TABLES, SUM(SUM_CREATED_TMP_TABLES) AS SUM_SUM_CREATED_TMP_TABLES, SUM(SUM_ERRORS) AS SUM_SUM_ERRORS, SUM(SUM_LOCK_TIME) AS SUM_SUM_LOCK_TIME, SUM(SUM_NO_GOOD_INDEX_USED) AS SUM_SUM_NO_GOOD_INDEX_USED, SUM(SUM_NO_INDEX_USED) AS SUM_SUM_NO_INDEX_USED, SUM(SUM_ROWS_AFFECTED) AS SUM_SUM_ROWS_AFFECTED, SUM(SUM_ROWS_EXAMINED) AS SUM_SUM_ROWS_EXAMINED, SUM(SUM_ROWS_SENT) AS SUM_SUM_ROWS_SENT, SUM(SUM_SELECT_FULL_JOIN) AS SUM_SUM_SELECT_FULL_JOIN, SUM(SUM_SELECT_FULL_RANGE_JOIN) AS SUM_SUM_SELECT_FULL_RANGE_JOIN, SUM(SUM_SELECT_RANGE) AS SUM_SUM_SELECT_RANGE, SUM(SUM_SELECT_RANGE_CHECK) AS SUM_SUM_SELECT_RANGE_CHECK, SUM(SUM_SELECT_SCAN) AS SUM_SUM_SELECT_SCAN, SUM(SUM_SORT_MERGE_PASSES) AS SUM_SUM_SORT_MERGE_PASSES, SUM(SUM_SORT_RANGE) AS SUM_SUM_SORT_RANGE, SUM(SUM_SORT_ROWS) AS SUM_SUM_SORT_ROWS, SUM(SUM_SORT_SCAN) AS SUM_SUM_SORT_SCAN, SUM(SUM_TIMER_WAIT) AS SUM_SUM_TIMER_WAIT, SUM(SUM_WARNINGS) AS SUM_SUM_WARNINGS FROM performance_schema.events_statements_summary_by_digest\G
*************************** 1. row ***************************
                 SUM_COUNT_STAR: 45179316331
SUM_SUM_CREATED_TMP_DISK_TABLES: 581653469
     SUM_SUM_CREATED_TMP_TABLES: 1604464233
                 SUM_SUM_ERRORS: 11185325836
              SUM_SUM_LOCK_TIME: 9798939901881000000
     SUM_SUM_NO_GOOD_INDEX_USED: 381858
          SUM_SUM_NO_INDEX_USED: 1280981274
          SUM_SUM_ROWS_AFFECTED: 743888258
          SUM_SUM_ROWS_EXAMINED: 13788624870537
              SUM_SUM_ROWS_SENT: 427907597349
       SUM_SUM_SELECT_FULL_JOIN: 29320538
 SUM_SUM_SELECT_FULL_RANGE_JOIN: 17365161
           SUM_SUM_SELECT_RANGE: 1410164385
     SUM_SUM_SELECT_RANGE_CHECK: 381855
            SUM_SUM_SELECT_SCAN: 1522314144
      SUM_SUM_SORT_MERGE_PASSES: 5374721
             SUM_SUM_SORT_RANGE: 1253643217
              SUM_SUM_SORT_ROWS: 124486219254
              SUM_SUM_SORT_SCAN: 1415213125
             SUM_SUM_TIMER_WAIT: 36443568215735705384
               SUM_SUM_WARNINGS: 509300572

reason

In my case the SUM_SUM_TIMER_WAIT is bigger than uint64(18446744073709551615), so i got an error.

• https://github.com/prometheus/mysqld_exporter/blob/main/collector/perf_schema_events_statements_sum.go#L194

WANT

change uint64 to uint128, maybe it's can fix it. ( I did't try
or something other way.