[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: could not link file in wal restore lines
From: Zsolt Ero <zsolt.ero () gmail ! com>
Date: 2022-07-21 22:28:18
Message-ID: CAKw-smBhcQ0BGcNxzDcb_-_dMXMdbD3Lm_3tfPvxTvYOf4TcCA () mail ! gmail ! com
[Download RAW message or body]
Can someone with knowledge about PG tell me if this is a bug and if there
is any need to worry about data corruption?
Here is the issue which I've opened for pgbackrest, the developer confirmed
that pgbackrest doesn't change those files at all.
https://github.com/pgbackrest/pgbackrest/issues/1815
It's PG 12 on Ubuntu 18.04. I always start with a clean data folder and can
replicate this 100% any time I do a restore. Single master, no cluster or
replication, backup/restore is from the same partition.
Thanks,
Zsolt
On 15. Jul 2022 at 22:11:09, Zsolt Ero <zsolt.ero@gmail.com> wrote:
> Hi,
>
> I'm testing pgbackrest restore.
>
> It works well, but in the pg logs I get the following lines:
>
> could not link file "pg_wal/000000010000015600000098" to
> "pg_wal/00000001000001570000006E": File exists
>
> In total, I get 18 lines of "could not link file" and 932 lines of
> "restored log file" lines.
>
> At the end it finishes with:
>
> redo done at 15A/A001710
> last completed transaction was at log time 2022-07-15 19:41:05.175573+00
> restored log file "000000030000015A0000000A" from archive
> selected new timeline ID: 4
> archive recovery complete
> restored log file "00000003.history" from archive
> database system is ready to accept connections
>
> Before going in production, I wanted to ask, if this is correct like this?
> I mean are those "could not link file" lines anything to worry about?
>
> Thanks and regards,
> Zsolt
>
>
>
>
[Attachment #3 (text/html)]
<html><body><div dir="ltr">
Can someone with knowledge about PG tell me if this is a bug and if there is any \
need to worry about data corruption?</div><div dir="ltr"><br></div><div \
dir="ltr">Here is the issue which I've opened for pgbackrest, the developer \
confirmed that pgbackrest doesn't change those files at all.</div><div \
dir="ltr"><br></div><div dir="ltr"><a \
href="https://github.com/pgbackrest/pgbackrest/issues/1815">https://github.com/pgbackrest/pgbackrest/issues/1815</a><br></div><div \
dir="ltr"><br></div><div dir="ltr">It's PG 12 on Ubuntu 18.04. I always start \
with a clean data folder and can replicate this 100% any time I do a restore. Single \
master, no cluster or replication, backup/restore is from the same \
partition.</div><div dir="ltr"><br></div><div dir="ltr">Thanks,</div><div \
dir="ltr">Zsolt</div><div dir="ltr"><br></div><div dir="ltr"><br></div><div \
dir="ltr"><br></div> <br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On 15. Jul 2022 at 22:11:09, Zsolt Ero <<a \
href="mailto:zsolt.ero@gmail.com">zsolt.ero@gmail.com</a>> wrote:<br></div> \
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex" type="cite"> <div><div><div dir="ltr">Hi, \
<div><br></div><div>I'm testing pgbackrest restore.<div><br></div><div>It works \
well, but in the pg logs I get the following lines:<div><br></div><div>could not link \
file "pg_wal/000000010000015600000098" to \
"pg_wal/00000001000001570000006E": File exists<br></div><div><br></div><div \
dir="ltr">In total, I get 18 lines of "could not link file" and 932 lines \
of "restored log file" lines.</div><div dir="ltr"><br></div><div \
dir="ltr">At the end it finishes with:</div><div dir="ltr"><br></div><div \
dir="ltr"><div dir="ltr">redo done at 15A/A001710</div><div dir="ltr">last completed \
transaction was at log time 2022-07-15 19:41:05.175573+00</div><div \
dir="ltr">restored log file "000000030000015A0000000A" from \
archive</div><div dir="ltr">selected new timeline ID: 4</div><div dir="ltr">archive \
recovery complete</div><div dir="ltr">restored log file "00000003.history" \
from archive</div><div dir="ltr">database system is ready to accept \
connections</div></div><div dir="ltr"><br></div><div dir="ltr">Before going in \
production, I wanted to ask, if this is correct like this? I mean are those \
"could not link file" lines anything to worry about?</div><div \
dir="ltr"><br></div><div dir="ltr">Thanks and regards,</div><div \
dir="ltr">Zsolt</div><div dir="ltr"><br></div><div dir="ltr"><br></div><div \
dir="ltr"><br></div></div></div></div></div></div> </blockquote>
</div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic