Re: Add errdetail() with PID and UID about source of termination signal
Jakub Wartak <jakub.wartak@enterprisedb.com>
From: Jakub Wartak <jakub.wartak@enterprisedb.com>
To: Jacob Champion <jacob.champion@enterprisedb.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Chao Li <li.evan.chao@gmail.com>, Andres Freund <andres@anarazel.de>, Jim Jones <jim.jones@uni-muenster.de>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-16T05:50:25Z
Lists: pgsql-hackers
On Wed, Apr 15, 2026 at 6:23 PM Jacob Champion <jacob.champion@enterprisedb.com> wrote: > > On Wed, Apr 15, 2026 at 7:17 AM Andrew Dunstan <andrew@dunslane.net> wrote: > > OK, pushed. Thanks. > > I hit the following in the pg_basebackup tests just now, running on Linux: > > [08:41:21.621](0.377s) ok 196 - Walsender killed > [09:09:11.134](1669.513s) # pump_until: timeout expired when > searching for "(?^:background process terminated unexpectedly)" with > stream: "pg_basebackup: error: unexpected termination of replication > stream: FATAL: terminating connection due to administrator command > # DETAIL: Signal sent by PID 155573, UID 1000. > # " > [09:09:11.134](0.000s) not ok 197 - background process exit message > [09:09:11.134](0.000s) # Failed test 'background process exit message' > # at src/postgres/src/bin/pg_basebackup/t/010_pg_basebackup.pl line 1049. > > But I haven't been able to reproduce since, so I don't know if this is > a new race, or the commit just exposed one that was there before? Hi Jacob, the time baseback took seems strange to me (27mins?!). It was properly killed by a timeout, and the new code added the exact PID that caused the issue. If you happen to spot it again long running it might make some sense to find where the time is spent there during that basebackup (in this test we shouldn't be taking large backups). Alternative would be to check pg server logs of that specific failed run to see exactly where it was stuck after 08:41 (but before 09:09). -J.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Only show signal-sender PID/UID detail in server log
- b772f3fcad18 19 (unreleased) landed
-
Make psql DETAIL line test unconditionally optional.
- 446c400fd89b 19 (unreleased) landed
-
Rework signal handler infrastructure to pass sender info as argument.
- 3e2a1496bae6 19 (unreleased) landed
-
Add errdetail() with PID and UID about source of termination signal.
- 55890a919454 19 (unreleased) landed