NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit892a0e4

committed

Avoid hot standby cancels from VAC FREEZE

VACUUM FREEZE generated false cancelations of standby queries on anotherwise idle master. Caused by an off-by-one error on cutoff_xidwhich goes back to original commit.Backpatch to all versions 9.0+Analysis and report by Marco NenciariniBug fix by Simon Riggs

1 parentd66b67f commit892a0e4Copy full SHA for 892a0e4

File tree

1 file changed

-1

lines changed

src/backend/access/heap
- heapam.c

1 file changed

-1

lines changed

`‎src/backend/access/heap/heapam.c`

Lines changed: 7 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -7064,7 +7064,13 @@ heap_xlog_freeze_page(XLogRecPtr lsn, XLogRecord *record)`
`7064`	`7064`	`* consider the frozen xids as running.`
`7065`	`7065`	`*/`
`7066`	`7066`	`if (InHotStandby)`
`7067`		`-ResolveRecoveryConflictWithSnapshot(cutoff_xid,xlrec->node);`
	`7067`	`+{`
	`7068`	`+TransactionIdlatestRemovedXid=cutoff_xid;`
	`7069`	`+`
	`7070`	`+TransactionIdRetreat(latestRemovedXid);`
	`7071`	`+`
	`7072`	`+ResolveRecoveryConflictWithSnapshot(latestRemovedXid,rnode);`
	`7073`	`+}`
`7068`	`7074`
`7069`	`7075`	`/* If we have a full-page image, restore it and we're done */`
`7070`	`7076`	`if (record->xl_info&XLR_BKP_BLOCK(0))`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit892a0e4

File tree

1 file changed

1 file changed

`‎src/backend/access/heap/heapam.c`

0 commit comments