requested timeline ... does not contain minimum recovery point ... - Mailing list pgsql-hackers

From Christophe Pettus
Subject requested timeline ... does not contain minimum recovery point ...
Date
Msg-id 5A7F0B60-28BC-4EF0-B2EF-9D6AA47A0378@thebuild.com
Whole thread Raw
Responses Re: requested timeline ... does not contain minimum recovery point...  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
PostgreSQL 9.6.9, Windows Server 2012 Datacenter (64-bit).

We're trying to diagnose the error:

    requested timeline 105 does not contain minimum recovery point A58/6B109F28 on timeline 103

The error occurs when a WAL-shipping (not streaming) secondary starts up.

These two machines have been part of a stress-test where, repeatedly, the secondary is promoted, the old primary is
rewoundusing pg_rewind, and then attached to the new primary.  This has worked for multiple iterations, but this error
poppedup.  The last cycle was particularly fast: the new primary was only up for about 10 seconds (although it had
completedrecovery) before being shut down again, and pg_rewind applied to it to reconnect it with the promoted
secondary.

--
-- Christophe Pettus
   xof@thebuild.com



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Cannot dump foreign key constraints on partitioned table
Next
From: Andres Freund
Date:
Subject: Re: requested timeline ... does not contain minimum recovery point...