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