Bug 2403541 - pgbouncer reload is misleading
Summary: pgbouncer reload is misleading
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Fedora EPEL
Classification: Fedora
Component: pgbouncer
Version: epel9
Hardware: x86_64
OS: Linux
unspecified
medium
Target Milestone: ---
Assignee: Devrim Gündüz
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2025-10-13 13:47 UTC by Prashant S
Modified: 2025-11-26 01:53 UTC (History)
3 users (show)

Fixed In Version: pgbouncer-1.25.0-5.fc43 pgbouncer-1.25.0-4.el9 pgbouncer-1.25.0-5.fc42 pgbouncer-1.25.0-4.fc41 pgbouncer-1.25.0-4.el10_1 pgbouncer-1.25.0-4.el10_2
Clone Of:
Environment:
Last Closed: 2025-11-26 00:50:27 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Prashant S 2025-10-13 13:47:33 UTC
Description of problem:
The `systemctl reload` commands may cause restart of the service rather than a config reload.

Version-Release number of selected component (if applicable):
pgbouncer-1.24.1-2.el9.x86_6

How reproducible:
If pgbouncer is running with TLS enabled, a service reload will trigger a restart under the hood. 

Steps to Reproduce:
1. Make any config change to the pgbouncer.ini file
2. Reload the service - `systemctl reload pgbouncer`

Actual results:
1. All connections are terminated 

Expected results:
1. Connections should not terminate. Service should reload with no impact to client.

Additional info:

The reload command in the pgbouncer service file uses the -R flag. 

This can mean a restart of the service, especially if using TLS. 

This flag is also marked as deprecated in the pgbouncer documentation now. 

-R, --reboot
    DEPRECATED: Instead of this option use a rolling restart with multiple pgbouncer processes listening on the same port using so_reuseport instead Do an online restart. That means connecting to the running process, loading the open sockets from it, and then using them. If there is no active process, boot normally. Note: Works only if OS supports Unix sockets and the unix_socket_dir is not disabled in configuration. Does not work on Windows. Does not work with TLS connections, they are dropped.

Propose using 
`ExecReload=/usr/bin/kill -HUP $MAINPID`
as in the pgdg-common (postgres) repo.

Comment 1 Simone Caronni 2025-11-11 09:59:01 UTC
Changes are in the branches, waiting for this to be fixed to publish the update: https://pagure.io/releng/issue/13073

Comment 2 Fedora Update System 2025-11-17 11:09:36 UTC
FEDORA-2025-34773babcd (pgbouncer-1.25.0-4.fc41) has been submitted as an update to Fedora 41.
https://bodhi.fedoraproject.org/updates/FEDORA-2025-34773babcd

Comment 3 Fedora Update System 2025-11-17 11:09:39 UTC
FEDORA-2025-24f14430ea (pgbouncer-1.25.0-5.fc42) has been submitted as an update to Fedora 42.
https://bodhi.fedoraproject.org/updates/FEDORA-2025-24f14430ea

Comment 4 Fedora Update System 2025-11-17 11:09:41 UTC
FEDORA-2025-6421c2f4da (pgbouncer-1.25.0-5.fc43) has been submitted as an update to Fedora 43.
https://bodhi.fedoraproject.org/updates/FEDORA-2025-6421c2f4da

Comment 5 Fedora Update System 2025-11-17 11:09:44 UTC
FEDORA-EPEL-2025-22fc24e2ed (pgbouncer-1.25.0-4.el10_1) has been submitted as an update to Fedora EPEL 10.1.
https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-22fc24e2ed

Comment 6 Fedora Update System 2025-11-17 11:09:47 UTC
FEDORA-EPEL-2025-968a76d07e (pgbouncer-1.25.0-4.el9) has been submitted as an update to Fedora EPEL 9.
https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-968a76d07e

Comment 7 Fedora Update System 2025-11-17 11:09:50 UTC
FEDORA-EPEL-2025-2937411d89 (pgbouncer-1.25.0-4.el10_2) has been submitted as an update to Fedora EPEL 10.2.
https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-2937411d89

Comment 8 Fedora Update System 2025-11-18 00:46:35 UTC
FEDORA-2025-24f14430ea has been pushed to the Fedora 42 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-24f14430ea`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-24f14430ea

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 9 Fedora Update System 2025-11-18 01:29:31 UTC
FEDORA-EPEL-2025-968a76d07e has been pushed to the Fedora EPEL 9 testing repository.

You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-968a76d07e

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 10 Fedora Update System 2025-11-18 01:38:15 UTC
FEDORA-2025-6421c2f4da has been pushed to the Fedora 43 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-6421c2f4da`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-6421c2f4da

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 11 Fedora Update System 2025-11-18 02:13:21 UTC
FEDORA-2025-34773babcd has been pushed to the Fedora 41 testing repository.
Soon you'll be able to install the update with the following command:
`sudo dnf upgrade --enablerepo=updates-testing --refresh --advisory=FEDORA-2025-34773babcd`
You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-2025-34773babcd

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 12 Fedora Update System 2025-11-18 02:23:41 UTC
FEDORA-EPEL-2025-2937411d89 has been pushed to the Fedora EPEL 10.2 testing repository.

You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-2937411d89

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 13 Fedora Update System 2025-11-18 02:24:27 UTC
FEDORA-EPEL-2025-22fc24e2ed has been pushed to the Fedora EPEL 10.1 testing repository.

You can provide feedback for this update here: https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2025-22fc24e2ed

See also https://fedoraproject.org/wiki/QA:Updates_Testing for more information on how to test updates.

Comment 14 Fedora Update System 2025-11-26 00:50:27 UTC
FEDORA-2025-6421c2f4da (pgbouncer-1.25.0-5.fc43) has been pushed to the Fedora 43 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 15 Fedora Update System 2025-11-26 01:04:45 UTC
FEDORA-EPEL-2025-968a76d07e (pgbouncer-1.25.0-4.el9) has been pushed to the Fedora EPEL 9 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 16 Fedora Update System 2025-11-26 01:04:53 UTC
FEDORA-2025-24f14430ea (pgbouncer-1.25.0-5.fc42) has been pushed to the Fedora 42 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 17 Fedora Update System 2025-11-26 01:21:38 UTC
FEDORA-2025-34773babcd (pgbouncer-1.25.0-4.fc41) has been pushed to the Fedora 41 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 18 Fedora Update System 2025-11-26 01:52:56 UTC
FEDORA-EPEL-2025-22fc24e2ed (pgbouncer-1.25.0-4.el10_1) has been pushed to the Fedora EPEL 10.1 stable repository.
If problem still persists, please make note of it in this bug report.

Comment 19 Fedora Update System 2025-11-26 01:53:57 UTC
FEDORA-EPEL-2025-2937411d89 (pgbouncer-1.25.0-4.el10_2) has been pushed to the Fedora EPEL 10.2 stable repository.
If problem still persists, please make note of it in this bug report.


Note You need to log in before you can comment on or make changes to this bug.