pgsql: Fix relcache reload mechanism to be more robust in the face of

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix relcache reload mechanism to be more robust in the face of
Date: 2010-01-12 18:12:19
Message-ID: 20100112181219.0C9CA7541B9@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix relcache reload mechanism to be more robust in the face of errors
occurring during a reload, such as query-cancel. Instead of zeroing out
an existing relcache entry and rebuilding it in place, build a new relcache
entry, then swap its contents with the old one, then free the new entry.
This avoids problems with code believing that a previously obtained pointer
to a cache entry must still reference a valid entry, as seen in recent
failures on buildfarm member jaguar. (jaguar is using CLOBBER_CACHE_ALWAYS
which raises the probability of failure substantially, but the problem
could occur in the field without that.) The previous design was okay
when it was made, but subtransactions and the ResourceOwner mechanism
make it unsafe now.

Also, make more use of the already existing rd_isvalid flag, so that we
remember that the entry requires rebuilding even if the first attempt fails.

Back-patch as far as 8.2. Prior versions have enough issues around relcache
reload anyway (due to inadequate locking) that fixing this one doesn't seem
worthwhile.

Modified Files:
--------------
pgsql/src/backend/utils/cache:
relcache.c (r1.298 -> r1.299)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/relcache.c?r1=1.298&r2=1.299)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2010-01-12 18:12:26 pgsql: Fix relcache reload mechanism to be more robust in the face of
Previous Message User Bmomjian 2010-01-12 18:06:24 pg-migrator - pg_migrator: All building against any PG source >= 8.3.