NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitd6a3dbe

committed

Fix theoretical torn page hazard.

The original report was concerned with a possible inconsistencybetween the heap and the visibility map, which I was unable toconfirm. The concern has been retracted.However, there did seem to be a torn page hazard when usingchecksums. By not setting the heap page LSN during redo, theprotections of minRecoveryPoint were bypassed. Fixed, along with amisleading comment.It may have been impossible to hit this problem in practice, becauseit would require a page tear between the checksum and the flags, so Iam marking this as a theoretical risk. But, as discussed, it didviolate expectations about the page LSN, so it may have otherconsequences.Backpatch to all supported versions.Reported-by: Konstantin KnizhnikReviewed-by: Konstantin KnizhnikDiscussion:https://postgr.es/m/fed17dac-8cb8-4f5b-d462-1bb4908c029e@garret.ruBackpatch-through: 11

1 parent3eb8eec commitd6a3dbeCopy full SHA for d6a3dbe

File tree

1 file changed

-2

lines changed

src/backend/access/heap
- heapam.c

1 file changed

-2

lines changed

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

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -8823,15 +8823,17 @@ heap_xlog_visible(XLogReaderState *record)`
`8823`	`8823`	`/*`
`8824`	`8824`	`* We don't bump the LSN of the heap page when setting the visibility`
`8825`	`8825`	`* map bit (unless checksums or wal_hint_bits is enabled, in which`
`8826`		`- * case we must), because that would generate an unworkable volume of`
`8827`		`- * full-page writes. This exposes us to torn page hazards, but since`
	`8826`	`+ * case we must). This exposes us to torn page hazards, but since`
`8828`	`8827`	`* we're not inspecting the existing page contents in any way, we`
`8829`	`8828`	`* don't care.`
`8830`	`8829`	`*/`
`8831`	`8830`	`page=BufferGetPage(buffer);`
`8832`	`8831`
`8833`	`8832`	`PageSetAllVisible(page);`
`8834`	`8833`
	`8834`	`+if (XLogHintBitIsNeeded())`
	`8835`	`+PageSetLSN(page,lsn);`
	`8836`	`+`
`8835`	`8837`	`MarkBufferDirty(buffer);`
`8836`	`8838`	`}`
`8837`	`8839`	`elseif (action==BLK_RESTORED)`

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!

Commitd6a3dbe

File tree

1 file changed

1 file changed

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

0 commit comments