1/2 Hey , we’ve observed on 13.3 snapshot recovery conflict on standby despite hot_standby_feedback = on. That’s on "Btree/REUSE_PAGE” where the btpo xact is soo old leading to the diff in TransactionIdFollows() being >= 2^31 +1 so “wrongly” returning false.
Conversation
2/2 It looks like e5d8a999030418a1b9e53d5f15ccaca7ed674877 is fixing this as using ResolveRecoveryConflictWithSnapshotFullXid() in btree_xlog_reuse_page(). Do you agree?
1
2
Wish it could have been backported... but that's a really big non-trivial diff and likely an uncommon problem, I can see why it could be pg14 only
1
Show replies