Re: [GENERAL] wal_retrieve_retry_interval - Mailing list pgsql-general

From Michael Paquier
Subject Re: [GENERAL] wal_retrieve_retry_interval
Date
Msg-id CAB7nPqT3jzH_9Z7h=ou1Pkfzbt5+5sepCQbRZkOz29Ev6vVCLg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] wal_retrieve_retry_interval  (Ludovic Vaugeois-Pepin <ludovicvp@gmail.com>)
Responses Re: [GENERAL] wal_retrieve_retry_interval  (Ludovic Vaugeois-Pepin <ludovicvp@gmail.com>)
List pgsql-general
On Sun, May 28, 2017 at 9:41 AM, Ludovic Vaugeois-Pepin
<ludovicvp@gmail.com> wrote:
> On Sun, May 28, 2017 at 9:49 AM, Ludovic Vaugeois-Pepin
> <ludovicvp@gmail.com> wrote:
>> It really is set at 3s on all servers (master and standbies) earlier in the "deployment" process at the same time
"listen_addresses","hot_standby", and others are set. This doesn't seem to happen every time I run tests. I increased
loggingto DEBUG1. This is what I got when the problem occurred again. Note that the empty line is there in the log
file.

Aren't those logs coming from a standby that is being reconnected to a
promoted standby? In short you restarted this standby with a fresh
recovery.conf. The WAL receiver would try to fetch history file data
for validity checks when it notices that there is a timeline jump,
when it needs to itself jump to a new timeline, and the logs you are
showing highlight that.
--
Michael


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Does NUMERIC lose precision?
Next
From: Ludovic Vaugeois-Pepin
Date:
Subject: Re: [GENERAL] wal_retrieve_retry_interval