Re: Visibility bug with prepared transaction with subtransactions on standby

Heikki Linnakangas <hlinnaka@iki.fi>

From: Heikki Linnakangas <hlinnaka@iki.fi>

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

Cc: Konstantin Knizhnik <knizhnik@neon.tech>

Date: 2024-06-27T18:35:53Z

Lists: pgsql-hackers

On 20/06/2024 17:10, Heikki Linnakangas wrote:
> 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.

All I heard is crickets, so committed and backported to all supported 
versions.

-- 
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