Re: pg_rewind and xlogtemp files - Mailing list pgsql-hackers

From Vladimir Borodin
Subject Re: pg_rewind and xlogtemp files
Date
Msg-id FAD4FB4F-9C7C-4D7F-8BC1-BC61861F006A@simply.name
Whole thread Raw
In response to Re: pg_rewind and xlogtemp files  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: pg_rewind and xlogtemp files  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers

17 июня 2015 г., в 9:48, Michael Paquier <michael.paquier@gmail.com> написал(а):

On Wed, Jun 17, 2015 at 3:17 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
As pointed by dev1ant on the original bug report, process_remote_file
should ignore files named as pg_xlog/xlogtemp.*, and I think that this
is the right thing to do. Any objections for a patch that at the same
time makes "xlogtemp." a define declaration in xlog_internal.h?

Declaration seems to be the right thing.

Another problem I’ve caught twice already in the same test:

error reading xlog record: record with zero length at 0/78000090
unexpected result while fetching remote files: ERROR:  could not open file "base/13003/t6_2424967" for reading: No such file or directory
The servers diverged at WAL position 0/76BADD50 on timeline 303.
Rewinding from Last common checkpoint at 0/7651F870 on timeline 303

I don’t know if this problem could be solved the same way (by skipping such files)… Should I start a new thread for that?


And attached is a patch following those lines.
--
Michael
<20150617_rewind_xlogtemp.patch>
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


--
May the force be with you…

pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Auto-vacuum is not running in 9.1.12
Next
From: Brendan Jurd
Date:
Subject: [PATCH] Function to get size of asynchronous notification queue