Re: BUG #13010: After promote postgres try to send old timeline WALs to archive - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #13010: After promote postgres try to send old timeline WALs to archive
Date
Msg-id CAB7nPqTOx-ZRWQbJJwTyv5J724EXqbpg79nZkJ98Tc_KLWnRnw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13010: After promote postgres try to send old timeline WALs to archive  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
On Fri, Apr 10, 2015 at 2:16 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Thu, Apr 9, 2015 at 11:02 PM,  <eshkinkot@gmail.com> wrote:
>> I do not use streaming, only WAL archive and after promote standby
>> it try to archive WALs with old timeline, but I already have it in
>> archive (from old master) and at new master WAL archiving stopped.
>>
>> [...]
>> now WAL archiving stopped with messages:
>>
>> 2015-04-08 20:49:31 MSK LOG:  archive command failed with exit code 1
>> 2015-04-08 20:49:31 MSK DETAIL:  The failed archive command was: test ! -f
>> ~/tmp/pg-slave-switch/w/000000010000000000000025 && cp
>> pg_xlog/000000010000000000000025
>> ~/tmp/pg-slave-switch/w/000000010000000000000025
>> 2015-04-08 20:49:32 MSK LOG:  archive command failed with exit code 1
>
> The standby has recycled some WAL segments ahead thinking to reuse
> them and at promotion they became actually bogus.

FYI, a fix for this issue has been committed here:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=b2a5545bd63fc94a71b1e97ecdd03c605d97a438
--
Michael

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Next
From: dwayne.towell@gmail.com
Date:
Subject: BUG #13053: type names pollute function name space