From: David Steele <david@pgmasters.net>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: zsolt.ero@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Cc: michael@paquier.xyz
Subject: Re: could not link file in wal restore lines
Date: Tue, 26 Jul 2022 07:33:09 -0400
Message-ID: <8bc21242-6a7c-47b3-5af1-e6c9956d5ffa@pgmasters.net> (raw)
In-Reply-To: <20220726.150311.891076428649612904.horikyota.ntt@gmail.com>
References: <CAKw-smA-0yhaJJQxqjmYn+dMzLmWoCbwiS7P5jeKe5DjzvM2xA@mail.gmail.com>
<4b392ab1-d4a5-5557-adf0-ae319e723da5@pgmasters.net>
<20220726.114814.306729894656662536.horikyota.ntt@gmail.com>
<20220726.150311.891076428649612904.horikyota.ntt@gmail.com>
On 7/26/22 02:03, Kyotaro Horiguchi wrote:
> At Tue, 26 Jul 2022 11:48:14 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in
>> Ah, sorry for posting following too-early messages in the thread.
>>
>> At Mon, 25 Jul 2022 08:40:12 -0400, David Steele <david@pgmasters.net> wrote in
>>> Your system seems to be doing recovery pretty quickly. I wonder if
>>> there is a race condition in WAL recycling?
>
> And it has been fixed by cc2c7d65fc in PG15. That discussion [1]
> concluded that we don't back-patch it.
>
> [1] https://www.postgresql.org/message-id/flat/20210202151416.GB3304930%40rfd.leadboat.com
>> Does anyone prefer some alternative? It's probably not worth
>> back-patching anything for a restartpoint failure this rare, because
>> most restartpoint outcomes are not user-visible.
I have responded on that thread to see if Noah can have a look and
decide if it would be worth back-patching cc2c7d65fc.
There have been other changes in this area (e.g. removing
durable_rename_excl) so it would be good to know if back-patching just
cc2c7d65fc will work.
Kyotaro, since you can reproduce the issue would you be willing to test
that?
Regards,
-David
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-bugs@postgresql.org
Cc: david@pgmasters.net, horikyota.ntt@gmail.com, zsolt.ero@gmail.com, pgsql-bugs@lists.postgresql.org, michael@paquier.xyz
Subject: Re: could not link file in wal restore lines
In-Reply-To: <8bc21242-6a7c-47b3-5af1-e6c9956d5ffa@pgmasters.net>
* 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