pgsql: Avoid testing tuple visibility without buffer lock in RI_FKey_ch
От | Tom Lane |
---|---|
Тема | pgsql: Avoid testing tuple visibility without buffer lock in RI_FKey_ch |
Дата | |
Msg-id | E1byO2Y-00040n-1s@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Avoid testing tuple visibility without buffer lock in RI_FKey_check(). Despite the argumentation I wrote in commit 7a2fe85b0, it's unsafe to do this, because in corner cases it's possible for HeapTupleSatisfiesSelf to try to set hint bits on the target tuple; and at least since 8.2 we have required the buffer content lock to be held while setting hint bits. The added regression test exercises one such corner case. Unpatched, it causes an assertion failure in assert-enabled builds, or otherwise would cause a hint bit change in a buffer we don't hold lock on, which given the right race condition could result in checksum failures or other data consistency problems. The odds of a problem in the field are probably pretty small, but nonetheless back-patch to all supported branches. Report: <19391.1477244876@sss.pgh.pa.us> Branch ------ REL9_2_STABLE Details ------- http://git.postgresql.org/pg/commitdiff/9bc01e7a4cd4d5ac0c9447a5885f3a5b1bd46dd0 Modified Files -------------- src/backend/utils/adt/ri_triggers.c | 20 +++++++++----------- src/test/regress/expected/foreign_key.out | 22 ++++++++++++++++++++++ src/test/regress/sql/foreign_key.sql | 23 +++++++++++++++++++++++ 3 files changed, 54 insertions(+), 11 deletions(-)
В списке pgsql-committers по дате отправления: