pgsql: injection_points: Clear waiter slot on error and exit - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: injection_points: Clear waiter slot on error and exit
Date
Msg-id E1wmm8K-00000000Oaz-0zct@gemulon.postgresql.org
Whole thread
List pgsql-committers
injection_points: Clear waiter slot on error and exit

injection_wait() only clears its slot in the waiter array after the
wait loop finishes.  When the waiting query is canceled or the backend
is terminated (wait look has a CHECK_FOR_INTERRUPS), the slot leaks.
Later wakeups of the same point then bump the counter of the leaked slot
instead of the real waiter, that sleeps forever.  Repeated leaks can
exhaust all the slots.

The code is changed so as the waiting loop is wrapped with
PG_ENSURE_ERROR_CLEANUP, so as the injection point slots, that are
shared resources, can be cleaned up on ERROR as much as a FATAL.

An isolation test is added: cancel one waiter, terminate another waiter,
then check that a later waiter still receives a wakeup.  Without the
fixed code, the test would fail on timeout.

Author: Zsolt Parragi <zsolt.parragi@percona.com>
Discussion: https://postgr.es/m/CAN4CZFO+KF=cc0-iEg28RhqRBp_fTs6D4b8b7D7DB-pGYP3Ccg@mail.gmail.com
Backpatch-through: 17

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/703859d7c649fc44da94fe1f1b9c24dcd58d9372

Modified Files
--------------
src/test/modules/injection_points/Makefile         |  1 +
.../injection_points/expected/wait_cleanup.out     | 87 ++++++++++++++++++++++
.../modules/injection_points/injection_points.c    | 39 +++++++---
src/test/modules/injection_points/meson.build      |  1 +
.../injection_points/specs/wait_cleanup.spec       | 50 +++++++++++++
5 files changed, 166 insertions(+), 12 deletions(-)


Attachment

pgsql-committers by date:

Previous
From: Amit Kapila
Date:
Subject: pgsql: Reject sequence synchronization against pre-PostgreSQL 19 publis
Next
From: Fujii Masao
Date:
Subject: pgsql: Fix EXCEPT publication test to check subscriber