Package: pgbouncer
Version: 1.17.0-3.pgdg110+1
Severity: minor
Dear Maintainer,
After upgrading pgbouncer from pgdg and stopping pgbouncer service, that
service is reported as failed, triggering monitoring notifications we have set
up:
```
$ systemctl status pgbouncer.service
● pgbouncer.service - pgbouncer PostgreSQL connection pooler
Loaded: loaded (/lib/systemd/system/pgbouncer.service; disabled; vendor
preset: enabled)
Active: failed (Result: exit-code) since Wed 2022-04-06 11:01:22 EEST;
7min ago
Process: 13070 ExecStart=/usr/sbin/pgbouncer /etc/pgbouncer/pgbouncer.ini
(code=exited, status=1/FAILURE)
Main PID: 13070 (code=exited, status=1/FAILURE)
CPU: 17ms
Apr 06 11:01:19 hostname pgbouncer[13070]: listening on 127.0.0.1:6432
Apr 06 11:01:19 hostname pgbouncer[13070]: cannot listen on [::1]:6432:
socket(): Address family not supported by protocol
Apr 06 11:01:19 hostname pgbouncer[13070]: listening on
unix:/var/run/postgresql/.s.PGSQL.6432
Apr 06 11:01:19 hostname pgbouncer[13070]: process up: PgBouncer 1.17.0,
libevent 2.1.12-stable (epoll), adns: c-ares 1.17.1, tls: OpenSSL 1.1.1n 15
Mar 2022
Apr 06 11:01:19 hostname systemd[1]: Started pgbouncer PostgreSQL connection
pooler.
Apr 06 11:01:22 hostname pgbouncer[13070]: got SIGTERM, fast exit
Apr 06 11:01:22 hostname systemd[1]: Stopping pgbouncer PostgreSQL connection
pooler...
Apr 06 11:01:22 hostname systemd[1]: pgbouncer.service: Main process exited,
code=exited, status=1/FAILURE
Apr 06 11:01:22 hostname systemd[1]: pgbouncer.service: Failed with result
'exit-code'.
Apr 06 11:01:22 hostname systemd[1]: Stopped pgbouncer PostgreSQL connection
pooler.
```
It's rather unexpected to get manually stopped service marked as
"failed". apache2, for example, exits "fine":
```
Process: 19317 ExecStop=/usr/sbin/apachectl graceful-stop (code=exited,
status=0/SUCCESS)
```
-- System Information:
Debian Release: 11.3
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable-security'), (500,
'stable-debug'), (500, 'stable'), (100, 'bullseye-fasttrack')
Architecture: amd64 (x86_64)
Kernel: Linux 5.10.0-13-amd64 (SMP w/16 CPU threads)
Kernel taint flags: TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) (ignored: LC_ALL
set to en_US.UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages pgbouncer depends on:
ii libc-ares2 1.17.1-1+deb11u1
ii libc6 2.31-13+deb11u3
ii libevent-2.1-7 2.1.12-stable-1
ii libpam0g 1.4.0-9+deb11u1
ii libssl1.1 1.1.1n-0+deb11u1
ii libsystemd0 247.3-7
ii lsb-base 11.1.0
ii postgresql-common 238.pgdg110+1
pgbouncer recommends no packages.
Versions of packages pgbouncer suggests:
ii python3 3.9.2-3
pn python3-psycopg2 <none>
-- Configuration Files:
/etc/pgbouncer/pgbouncer.ini [Errno 13] Permission denied:
'/etc/pgbouncer/pgbouncer.ini'
/etc/pgbouncer/userlist.txt [Errno 13] Permission denied:
'/etc/pgbouncer/userlist.txt'
-- no debconf information
