From: Greg Burd <greg@burd.me>
To: Andres Freund <andres@anarazel.de>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Amit Kapila <akapila@postgresql.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Bryan Green <dbryan.green@gmail.com>
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
Date: Wed, 28 Jan 2026 13:01:23 -0500
Message-ID: <85eb570f-ae23-4199-8f50-1772ccf63266@app.fastmail.com> (raw)
In-Reply-To: <y2tddikdvhr47nkybp457l7czr5alsosx2237n2eb4jkpcj4hr@wygnzz3kpqxl>
References: <E1vkc3p-002uNr-0e@gemulon.postgresql.org>
<CA+TgmobdVhO0ckZfsBZ0wqDO4qHVCwZZx8sf=EinafvUam-dsQ@mail.gmail.com>
<CA+hUKGJotCdMdhrwVST4xbsPzr-csDgzveNhKu4UAXEmCDJ4iA@mail.gmail.com>
<jqliu25wuvlxcjybekrpvmflgaod4iytlwekjyag2q43ml76fg@tfna2hbyhw4s>
<CA+TgmobkmUMBocv0hxKiBj_5ZoTRE=qPz7QOu7voJ_j=dWNaaA@mail.gmail.com>
<y2tddikdvhr47nkybp457l7czr5alsosx2237n2eb4jkpcj4hr@wygnzz3kpqxl>
On Tue, Jan 27, 2026, at 1:17 PM, Andres Freund wrote:
> Hi,
>
> On 2026-01-27 12:42:51 -0500, Robert Haas wrote:
>> I tried sticking a pg_sleep(30) in just before starting the standby
>> node, and that didn't help, so it doesn't seem like it's a race
>> condition.
>
> Interesting.
>
> It could be worth trying to run the test in isolation, without all the other
> concurrent tests.
>
> Greg, have you tried to repro it interactively?
Nope, not yet. I'm working on my ailing animals now and updated unicorn to include injection points.
-greg
> Bryan, you seem to have become the resident windows expert...
>
>
>> 2026-01-27 17:19:25.337 GMT startup[2488] LOG: starting backup
>> recovery with redo LSN 0/2A000028, checkpoint LSN 0/2A000080, on
>> timeline ID 1
>> The system cannot find the file specified.
>> 2026-01-27 17:19:25.352 GMT startup[2488] DEBUG: could not restore
>> file "00000001000000000000002A" from archive: child process exited
>> with exit code 1
>
> I think that must be a message from "copy" (which we seem to be using for
> restore_command on windows).
>
> I don't know why the standby is created with has_restoring => 1. But it
> shouldn't be related to the issue, I think?
>
> Greetings,
>
> Andres Freund
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: greg@burd.me, andres@anarazel.de, robertmhaas@gmail.com, thomas.munro@gmail.com, akapila@postgresql.org, pgsql-hackers@lists.postgresql.org, dbryan.green@gmail.com
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
In-Reply-To: <85eb570f-ae23-4199-8f50-1772ccf63266@app.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox