Horton
Menu

Re: Visibility bug with prepared transaction with subtransactions on standby

a.kozhemyakin <a.kozhemyakin@postgrespro.ru>

View thread
From: "a.kozhemyakin" <a.kozhemyakin@postgrespro.ru>
To: pgsql-hackers@lists.postgresql.org
Date: 2024-07-29T07:37:34Z
Lists: pgsql-hackers 
Hi,
I'm trying to run REL_13_STABLE recovey tests for windows and I get the 
error

waiting for server to shut down.............. failed
pg_ctl: server does not shut down
# pg_ctl stop failed: 256
# Stale postmaster.pid file for node "paris": PID 1868 no longer exists
Bail out! pg_ctl stop failed

I noticed that on buildfarm recovey tests are disabled for windows, was 
this done intentionally?

'invocation_args' => [
'--config',
'./bowerbird.conf',
'--skip-steps',
'recovery-check',
'--verbose',
'REL_13_STABLE'
],

REL_13_STABLE (071e19a36) - test passed
REL_13_STABLE(e9c8747ee) - test failed

28.06.2024 1:35, Heikki Linnakangas пишет:
> 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.
>

Commits

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

  1. Make 009_twophase.pl test pass with recovery_min_apply_delay set

  2. Fix MVCC bug with prepared xact with subxacts on standby

  3. Rework handling of subtransactions in 2PC recovery