Re: PG 9.3.12: Replication appears to have worked, but getting error messages in logs - Mailing list pgsql-general

From Michael Paquier
Subject Re: PG 9.3.12: Replication appears to have worked, but getting error messages in logs
Date
Msg-id CAB7nPqTBeXH2qQ2_3Zc4AR2Lh8ms0=Zjv45FLkW0GjGnsOHdPQ@mail.gmail.com
Whole thread Raw
In response to PG 9.3.12: Replication appears to have worked, but getting error messages in logs  (David Caldwell <david@porkrind.org>)
Responses Re: PG 9.3.12: Replication appears to have worked, but getting error messages in logs
List pgsql-general
On Sun, Apr 3, 2016 at 2:50 PM, David Caldwell <david@porkrind.org> wrote:
> Hello,
>
> We're using streaming replication. Our technique for spinning up a db
> slave is this:
>
> rsync from master (gross copy)
> pg_start_backup() on server
> rsync from master (correct copy)
> pg_stop_backup()
> drop in recovery.conf into slave directory
> enable hot_standby in slave conf
> start slave
>
> After starting the slave, I'm getting this error every 5 seconds in the log:
>
> ERROR:  requested WAL segment 0000000100000E2200000005 has already been
> removed

Are you sure that this is from the slave and not another not
requesting it? If this log entry has just ERROR, it means that the WAL
sender generated it. So don't you have a cascading slave connecting to
this new slave and requested for this WAL segment that has already
been removed?

Should the error come from the WAL receiver, you would have something like that.
FATAL:  could not receive data from WAL stream: ERROR:  requested WAL
segment 00000001000000000000001C has already been removed
--
Michael


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: template1 being accessed
Next
From: Luca Ferrari
Date:
Subject: Re: template1 being accessed