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
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) |