pgsql: Fix race condition in TupleDescCompactAttr assert code - Mailing list pgsql-committers

From David Rowley
Subject pgsql: Fix race condition in TupleDescCompactAttr assert code
Date
Msg-id E1tPu94-0011Qv-NZ@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix race condition in TupleDescCompactAttr assert code

5983a4cff added CompactAttribute as an abbreviated alternative to
FormData_pg_attribute to allow more cache-friendly processing in tasks
related to TupleDescs.  That commit contained some assert-only code to
check that the CompactAttribute had been populated correctly, however,
the method used to do that checking caused the TupleDesc's
CompactAttribute to be zeroed before it was repopulated and compared to
the snapshot taken before the memset call.  This caused issues as the type
cache caches TupleDescs in shared memory which can be used by multiple
backend processes at the same time.  There was a window of time between
the zero and repopulation of the CompactAttribute where another process
would mistakenly think that the CompactAttribute is invalid due to the
memset.

To fix this, instead of taking a snapshot of the CompactAttribute and
calling populate_compact_attribute() and comparing the snapshot to the
freshly populated TupleDesc's CompactAttribute, refactor things so we
can just populate a temporary CompactAttribute on the stack.  This way
we don't touch the TupleDesc's memory.

Reported-by: Alexander Lakhin, SQLsmith
Discussion: https://postgr.es/m/ca3a256a-5d12-42db-aabe-a75a030d9fb9@gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/6f3820f37aba94232468365bae7ba5de697fe993

Modified Files
--------------
src/backend/access/common/tupdesc.c | 71 ++++++++++++++++++++++++++++++++-----
src/include/access/tupdesc.h        | 29 ++++-----------
2 files changed, 69 insertions(+), 31 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Try to avoid semaphore-related test failures on NetBSD/OpenBSD.
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Remove pgrminclude annotations