Re: pg_rewind and xlogtemp files

From: Vladimir Borodin <root(at)simply(dot)name>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_rewind and xlogtemp files
Date: 2015-06-17 07:57:51
Message-ID: FAD4FB4F-9C7C-4D7F-8BC1-BC61861F006A@simply.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 17 июня 2015 г., в 9:48, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> написал(а):
>
> On Wed, Jun 17, 2015 at 3:17 PM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--
May the force be with you…
https://simply.name

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Haribabu Kommi 2015-06-17 07:59:05 Re: Auto-vacuum is not running in 9.1.12
Previous Message Prakash Itnal 2015-06-17 07:36:28 Is Postgres database server works fine if there is a change in system time?