postgres.git / summary / log / commit / refs

commit    9e23d05b256adb0964f13464f9be5ae6e856cd19
Author:   Simon Riggs <simon@2ndQuadrant.com>
Date:     Fri Jun 26 23:48:06 2015 +0000

    Avoid hot standby cancels from VAC FREEZE
    
    VACUUM FREEZE generated false cancelations of standby queries on an
    otherwise idle master. Caused by an off-by-one error on cutoff_xid
    which goes back to original commit.
    
    Backpatch to all versions 9.0+
    
    Analysis and report by Marco Nenciarini
    
    Bug fix by Simon Riggs


src/backend/access/heap/heapam.c | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/src/backend/access/heap/heapam.c b/src/backend/access/heap/heapam.c index 6645732f74c..634c0313c94 100644 --- a/src/backend/access/heap/heapam.c +++ b/src/backend/access/heap/heapam.c @@ -4307,7 +4307,13 @@ heap_xlog_freeze(XLogRecPtr lsn, XLogRecord *record) * consider the frozen xids as running. */ if (InHotStandby) - ResolveRecoveryConflictWithSnapshot(cutoff_xid, xlrec->node); + { + TransactionId latestRemovedXid = cutoff_xid; + + TransactionIdRetreat(latestRemovedXid); + + ResolveRecoveryConflictWithSnapshot(latestRemovedXid, rnode); + } /* If we have a full-page image, restore it and we're done */ if (record->xl_info & XLR_BKP_BLOCK(0)) [parent: a9b7bf82fab9]