prometheus-community / postgres_exporter

A PostgreSQL metric exporter for Prometheus
Apache License 2.0
2.83k stars 745 forks source link

Error on postgres_exporter: cat /var/log/messages after upgrading PostgreSQL version from 12.9 to 12.15 #1023

Open Raouia-db opened 7 months ago

Raouia-db commented 7 months ago

Apr 25 06:15:24 [localhost] postgres_exporter: ts=2024-04-25T04:15:24.706Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication write_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:24 [localhost] postgres_exporter: ts=2024-04-25T04:15:24.707Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication flush_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:25 [localhost] postgres_exporter: ts=2024-04-25T04:15:25.360Z caller=util.go:85 level=info msg="Could not parse []byte" err="strconv.ParseFloat: parsing \"00:00:00.103146\": invalid syntax" Apr 25 06:15:25 [localhost] postgres_exporter: ts=2024-04-25T04:15:25.360Z caller=util.go:85 level=info msg="Could not parse []byte" err="strconv.ParseFloat: parsing \"00:00:00.103146\": invalid syntax" Apr 25 06:15:25 [localhost] postgres_exporter: ts=2024-04-25T04:15:25.360Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication write_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:25 [localhost] postgres_exporter: ts=2024-04-25T04:15:25.360Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication flush_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:26 [localhost] postgres_exporter: ts=2024-04-25T04:15:26.515Z caller=util.go:85 level=info msg="Could not parse []byte" err="strconv.ParseFloat: parsing \"00:00:00.103146\": invalid syntax" Apr 25 06:15:26 [localhost] postgres_exporter: ts=2024-04-25T04:15:26.515Z caller=util.go:85 level=info msg="Could not parse []byte" err="strconv.ParseFloat: parsing \"00:00:00.103146\": invalid syntax" Apr 25 06:15:26 [localhost] postgres_exporter: ts=2024-04-25T04:15:26.516Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication write_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:26 [localhost] postgres_exporter: ts=2024-04-25T04:15:26.516Z caller=namespace.go:241 level=info err="Unexpected error parsing column: pg_stat_replication flush_lag [48 48 58 48 48 58 48 48 46 49 48 51 49 52 54]\n" Apr 25 06:15:28 [localhost] postgres_exporter: ts=2024-04-25T04:15:28.321Z caller=util.go:85 level=info msg="Could not parse []byte" err="strconv.ParseFloat: parsing \"00:00:00.103146\": invalid syntax" @ 11837,1 84%

template1=# SELECT flush_lag FROM pg_stat_replication; flush_lag

(1 row)