Re: pgsql: Prevent invalidation of newly synced replication slots.

From: "Greg Burd" <greg(at)burd(dot)me>
To: "Andres Freund" <andres(at)anarazel(dot)de>, "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Thomas Munro" <thomas(dot)munro(at)gmail(dot)com>, "Amit Kapila" <akapila(at)postgresql(dot)org>, "PostgreSQL Hackers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "Bryan Green" <dbryan(dot)green(at)gmail(dot)com>
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
Date: 2026-01-28 18:01:23
Message-ID: 85eb570f-ae23-4199-8f50-1772ccf63266@app.fastmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers


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

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Andrey Borodin 2026-01-28 18:09:35 Re: pgsql: Prevent invalidation of newly synced replication slots.
Previous Message Robert Haas 2026-01-28 17:08:03 pgsql: Allow for plugin control over path generation strategies.

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2026-01-28 18:09:35 Re: pgsql: Prevent invalidation of newly synced replication slots.
Previous Message Andres Freund 2026-01-28 17:52:22 Re: unnecessary executor overheads around seqscans