Re: BUG #4854: Problems with replaying WAL files on Warm Standby - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4854: Problems with replaying WAL files on Warm Standby
Date
Msg-id 27715.1245108907@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4854: Problems with replaying WAL files on Warm Standby  (Keith Pierno <kpierno@lulu.com>)
Responses Re: BUG #4854: Problems with replaying WAL files on Warm Standby  (Keith Pierno <kpierno@lulu.com>)
List pgsql-bugs
Keith Pierno <kpierno@lulu.com> writes:
> The backup used was from well after the failover time which is why I
> was concerned. Interestingly enough the logs are still all prefixed
> with 00000004... That just makes this problem extremely bizarre.

Hmm, that *is* weird.  It seems like the new primary must have reverted
its decision to go from timeline 4 to timeline 6.  (Which in itself is
a bit odd; why not timeline 5?)

Can you give us an exact sequence of events on the slave server/new
primary around the time of the failover?  Also, what was in the .history
file when you found it, and are there any other history files?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Keith Pierno
Date:
Subject: Re: BUG #4854: Problems with replaying WAL files on Warm Standby
Next
From: "Jim Michaels"
Date:
Subject: BUG #4855: Explain errors on drop table if exists