pgsql: Fix and document lock handling for in-memory replication slotda - Mailing list pgsql-committers

From Michael Paquier
Subject pgsql: Fix and document lock handling for in-memory replication slotda
Date
Msg-id E1fRxqK-0005pI-IA@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix and document lock handling for in-memory replication slot data

While debugging issues on HEAD for the new slot forwarding feature of
Postgres 11, some monitoring of the code surrounding in-memory slot data
has proved that the lock handling may cause inconsistent data to be read
by read-only callers of slot functions, particularly
pg_get_replication_slots() which fetches data for the system view
pg_replication_slots, or modules looking directly at slot information.

The code paths involved in those problems concern logical decoding
initialization (down to 9.4) and WAL reservation for slots (new as of
10).

A set of comments documenting all the lock handlings, particularly the
dependency with LW locks for slots and the in_use flag as well as the
internal mutex lock is added, based on a suggested by Simon Riggs.

Some of the fixed code exists down to 9.4 where WAL decoding has been
introduced, but as those race conditions are really unlikely going to
happen as those concern code paths for slot and decoding creation, just
fix the problem on HEAD.

Author: Michael Paquier

Discussion: https://postgr.es/m/20180528085747.GA27845@paquier.xyz

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/9e149c847f398793ec1641885434dcd10837d89d

Modified Files
--------------
src/backend/replication/logical/logical.c | 13 +++++++++----
src/backend/replication/slot.c            |  4 ++++
src/include/replication/slot.h            | 13 +++++++++++++
3 files changed, 26 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Thomas Munro
Date:
Subject: pgsql: Limit Parallel Hash's bucket array to MaxAllocSize.
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix grammar in REVOKE documentation