pgbouncer_exporter
pgbouncer_exporter copied to clipboard
missing destination name total_xact_count in *[]store.stat
Hi, I installed pgbouncer_exporter ver=0.1.4 with yum in CentOS. My config file /etc/sysconfig/pgbouncer-exporter looks: OPTIONS="--web.listen-address ':9127'" DATABASE_URL="postgres://postgres:[email protected]:6432/pgbouncer?sslmode=disable"
pgbouncer-exporter.service is active (running):
pgbouncer-exporter.service - PgBouncer Exporter Loaded: loaded (/usr/lib/systemd/system/pgbouncer-exporter.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2020-03-25 11:31:26 CET; 1s ago Main PID: 25603 (pgbouncer_expor) CGroup: /system.slice/pgbouncer-exporter.service └─25603 /usr/sbin/pgbouncer_exporter --web.listen-address :9127 server Started PgBouncer Exporter.
But I'm getting error message in logs: level=error msg="unable to get store result: unable to get stats: missing destination name total_xact_count in *[]store.stat" source="exporter.go:229"
It's interesting, because I able connect to pgbouncer:
psql -U postgres -h 127.0.0.1 -p 6432 pgbouncer Password for user postgres: psql (12.2, server 1.12.0/bouncer) Type "help" for help.
Command "show stats" display for me stats and I see total_xact_count
pgbouncer=# show stats; database | total_xact_count | total_query_count | total_received | total_sent | total_xact_time | total_query_time | total_wait_time | avg_xact_count | avg_query_count | avg_recv | avg_sent | avg_xact_time | avg_query_time | avg_wait_time -----------+------------------+-------------------+----------------+------------+-----------------+------------------+-----------------+----------------+-----------------+----------+----------+---------------+----------------+--------------- pgbouncer | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 (1 row)
Where is the problem? Why pgbouncer_exporter can't get stats?
Thanks.