Skip to content

Scan error on column index 2, name "checkpoint_write_time #707

New issue

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

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

Already on GitHub? # to your account

Closed
copolycube opened this issue Oct 27, 2022 · 3 comments
Closed

Scan error on column index 2, name "checkpoint_write_time #707

copolycube opened this issue Oct 27, 2022 · 3 comments

Comments

@copolycube
Copy link

What did you do?
started postgres-exporter
What did you expect to see?
no error
What did you see instead? Under which circumstances?
repeated errors

postgres-exporter_1  | 2022-10-27T22:13:02.895786224Z ts=2022-10-27T22:13:02.895Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010612212 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.654199102e+09\") to a int: invalid syntax"

Environment
docker-compose environment

  • System information:

    insert output of uname -srm here
    Linux 5.15.0-52-generic x86_64

  • postgres_exporter version:

    insert output of postgres_exporter --version here

c3f4e88ea08f                                                                      Up 2 days (healthy)   mainnet_postgres-exporter_1
  • postgres_exporter flags:
insert list of flags used here
  • PostgreSQL version:

    insert PostgreSQL version here

postgres:14-alpine

  • Logs:
postgres-exporter_1  | 2022-10-27T22:04:28.674561053Z ts=2022-10-27T22:04:28.674Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010603187 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:04:38.769158586Z ts=2022-10-27T22:04:38.769Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010610871 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:04:48.854785223Z ts=2022-10-27T22:04:48.854Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010743651 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:04:58.953229632Z ts=2022-10-27T22:04:58.953Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010662268 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:09.055384564Z ts=2022-10-27T22:05:09.055Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010670253 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:15.874119308Z ts=2022-10-27T22:05:15.873Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010823771 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:19.143337857Z ts=2022-10-27T22:05:19.143Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010649213 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:29.243588788Z ts=2022-10-27T22:05:29.243Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010648652 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:39.319286036Z ts=2022-10-27T22:05:39.319Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.005675049 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
postgres-exporter_1  | 2022-10-27T22:05:49.426788589Z ts=2022-10-27T22:05:49.426Z caller=collector.go:196 level=error msg="collector failed" name=bgwriter duration_seconds=0.010623444 err="sql: Scan error on column index 2, name \"checkpoint_write_time\": converting driver.Value type float64 (\"7.65365925e+09\") to a int: invalid syntax"
@copolycube
Copy link
Author

with docker image
docker.io/bitnami/postgres-exporter@sha256:eba56617404069a44f0310136c4b01efbceb9edeca1089ecded16f37312ad6b9: Pulling from bitnami/postgres-exporter

@sysadmind
Copy link
Contributor

This was fixed in #666 and released in postgres_exporter v0.11.1. The bitnami docker image is not official and I'm not very sure what version of the exporter that image ships with. Official images can be found here: https://quay.io/repository/prometheuscommunity/postgres-exporter?tab=tags&tag=latest

@copolycube
Copy link
Author

I confirm that not using the bitnami version helped solve this issue. Thanks !

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants