Re: Slave claims requested WAL segment already removed - but it wasn't

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Jeff Beck <becked(at)fastmail(dot)fm>, pgsql-general(at)postgresql(dot)org
Subject: Re: Slave claims requested WAL segment already removed - but it wasn't
Date: 2016-06-02 23:55:05
Message-ID: 2112712f-af1c-9e51-5b02-3f7c648d71e3@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 06/01/2016 06:43 PM, Jeff Beck wrote:
> Hi-
> We have a master (pg 9.4.4 on Ubuntu 14.10) and a slave (pg 9.4.8 on
> Centos 7). During a period of heavy use, the slave began complaining
> that the “requested WAL segment xxxxxx has already been removed”. But
> the WAL segment was still on the master. The issue was resolved by
> manually copying the pg_xlog directory over to the slave.

What is your setup?:

1) Streaming

2) WAL archiving

3) Both

4) Do you have more then one standby?

>
> I don’t see any errors on the master log file, or any other messages on
> the slave’s. What happened? How can this be prevented in the future?
>
> Thanks,
> Jeff
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2016-06-02 23:56:08 Re: psql remote shell command
Previous Message Stephen Frost 2016-06-02 23:54:50 Re: psql remote shell command