prometheus-pgbouncer-exporter is incompatible with pgbouncer (Remove from mantic/SRU)

[Juan Felipe García Catalán]

Remove from mantic as it is unmaintained and broken, potentially SRU LTS.

[Original bug report]
Release: 20.04
prometheus-pgbouncer-exporter: 1.7-1

This pgbouncer exporter is incompatible with any pgbouncer version after 1.8. Ubuntu 20 installs 1.12.0 and the postgres repos 1.13.0

From version 1.8 pgbouncer stopped returning the "total_requests" field to the STATS command and the exporter fails when it can't find the obsolete field in the query results.

A temporary workaround is replacing the "total_requests" reference in /usr/lib/python3/dist-packages/prometheus_pgbouncer_exporter/collectors.py with, for example total_query_count

A better solution would be replacing the exporter with one with proper suppport for different pgbouncer versions like https://github.com/spreaker/prometheus-pgbouncer-exporter

[Joi Owen (jlellis)]

I second the motion. The sources this package is built from have not been updated since 2016 and are no longer functional. This package needs to be removed if it can't be updated.

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Joi Owen (jlellis)]

The Prometheus community has a much more current version written in GO. https://github.com/prometheus-community/pgbouncer_exporter

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "0001-Correct-name-of-pgbouncer-metric.-Fixes-LP-1887656.patch" seems to be a debdiff. The ubuntu-sponsors team has been subscribed to the bug report so that they can review and hopefully sponsor the debdiff. If the attachment isn't a patch, please remove the "patch" flag from the attachment, remove the "patch" tag, and if you are member of the ~ubuntu-sponsors, unsubscribe the team.

[This is an automated message performed by a Launchpad user owned by ~brian-murray, for any issue please contact him.]

[Julian Andres Klode (juliank)]

So I understand the package has not been maintained in 8 years or so, I'd favor removing it from the archive over fixing it. Then people can introduce the new pgbouncer exporter from the prometheus community

[Julian Andres Klode (juliank)]

My concrete suggestion would be to

1. remove that from mantic as it is unmaintained
2. SRU the fix to 20.04 and 22.04 as it's already been shipped there

I'll subscribe ubuntu-archive to perform removal from mantic, and debdiffs for SRUs are welcome, please follow the process outlined in https://wiki.ubuntu.com/StableReleaseUpdates to submit a SRU debdiff and resubscribe ubuntu-sponsors when ready for review.

[Steve Langasek (vorlon)]

Removing packages from mantic:
 prometheus-pgbouncer-exporter 1.7-2.1 in mantic
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic amd64
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic arm64
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic armhf
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic i386
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic ppc64el
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic riscv64
  prometheus-pgbouncer-exporter 1.7-2.1 in mantic s390x
Comment: Incompatible with current prometheus; removed from Debian testing; LP: #1887656
1 package successfully removed.