Re: Visibility bug with prepared transaction with subtransactions on standby

Heikki Linnakangas <hlinnaka@iki.fi>

View thread

From: Heikki Linnakangas <hlinnaka@iki.fi>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Cc: Konstantin Knizhnik <knizhnik@neon.tech>

Date: 2024-06-20T14:10:17Z

Lists: pgsql-hackers

Attachments

v2-0001-tests-Trim-newline-from-result-returned-by-Backgr.patch (text/x-patch) patch v2-0001
v2-0002-Fix-MVCC-bug-with-prepared-xact-with-subxacts-on-.patch (text/x-patch) patch v2-0002

On 20/06/2024 16:41, Heikki Linnakangas wrote:
> Attached is a patch to fix this, with a test case.

The patch did not compile, thanks to a last-minute change in a field 
name. Here's a fixed version.

-- 
Heikki Linnakangas
Neon (https://neon.tech)

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Make 009_twophase.pl test pass with recovery_min_apply_delay set
- e438b0f4241e 13.19 landed
- f5f5e7b47351 14.16 landed
- 2af2457fa6d8 15.11 landed
- 3231cb57d886 16.7 landed
- d1253c67fa29 17.3 landed
- 1dfeb6af7f87 18.0 landed
Fix MVCC bug with prepared xact with subxacts on standby
- 9dbf8ab48c21 14.13 landed
- 0e2f3d78bf5a 15.8 landed
- b5b418b689ec 16.4 landed
- cbfbda78413a 17.0 landed
- 5dea6628b32d 12.20 landed
- e9c8747ee934 13.16 landed
Rework handling of subtransactions in 2PC recovery
- 49e928154978 10.0 cited