Feedback-ID: i675e48f3:Fastmail
MIME-Version: 1.0
Date: Wed, 28 Jan 2026 13:01:23 -0500
From: "Greg Burd" <greg@burd.me>
To: "Andres Freund" <andres@anarazel.de>,
 "Robert Haas" <robertmhaas@gmail.com>
Cc: "Thomas Munro" <thomas.munro@gmail.com>,
 "Amit Kapila" <akapila@postgresql.org>,
 "PostgreSQL Hackers" <pgsql-hackers@lists.postgresql.org>,
 "Bryan Green" <dbryan.green@gmail.com>
Message-Id: <85eb570f-ae23-4199-8f50-1772ccf63266@app.fastmail.com>
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>
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/85eb570f-ae23-4199-8f50-1772ccf63266%40app.fastmail.com>
Precedence: bulk


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