Thread: could not link file in wal restore lines
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
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.
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 existsIn 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/A001710last completed transaction was at log time 2022-07-15 19:41:05.175573+00restored log file "000000030000015A0000000A" from archiveselected new timeline ID: 4archive recovery completerestored log file "00000003.history" from archivedatabase system is ready to accept connectionsBefore 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