pgbouncer_exporter icon indicating copy to clipboard operation
pgbouncer_exporter copied to clipboard

missing destination name total_xact_count in *[]store.stat

Open bimcas opened this issue 4 years ago • 0 comments

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.

bimcas avatar Mar 25 '20 10:03 bimcas