Re: BUG #13010: After promote postgres try to send old timeline WALs to archive

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: eshkinkot(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, hlinnaka(at)iki(dot)fi
Subject: Re: BUG #13010: After promote postgres try to send old timeline WALs to archive
Date: 2015-04-13 23:14:18
Message-ID: CAB7nPqTOx-ZRWQbJJwTyv5J724EXqbpg79nZkJ98Tc_KLWnRnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Apr 10, 2015 at 2:16 PM, Michael Paquier
<michael(dot)paquier(at)gmail(dot)com> wrote:
> On Thu, Apr 9, 2015 at 11:02 PM, <eshkinkot(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message dwayne.towell 2015-04-14 21:24:54 BUG #13053: type names pollute function name space
Previous Message Alvaro Herrera 2015-04-13 21:08:01 Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)