Horton

Re: Old row version in hot chain become visible after a freeze

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: "Wong, Yi Wen" <yiwong@amazon.com>
Cc: Michael Paquier <michael.paquier@gmail.com>, Peter Geoghegan <pg@bowt.ie>, "Wood, Dan" <hexpert@amazon.com>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>, Andres Freund <andres@anarazel.de>
Date: 2017-09-28T14:56:57Z
Lists: pgsql-bugs 
Okay, I have pushed this patch now backpatched to all branches since
9.3, after staring at this code for way too long.  I spent a lot of time
testing it to ensure things are correct, but please double-check.

Many thanks to Dan Wood for the initial diagnosys, and to Yi Wen and
Michael for the review and discussion.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Fix freezing of a dead HOT-updated tuple

  2. Fix potential data corruption during freeze

  3. Clarify the contract of partition_rbound_cmp().