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

From: Jeff Beck <becked(at)fastmail(dot)fm>
To: pgsql-general(at)postgresql(dot)org
Subject: Slave claims requested WAL segment already removed - but it wasn't
Date: 2016-06-02 01:43:19
Message-ID: 1464831799.2928650.625412873.4E3DCC43@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-06-02 04:11:19 Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Previous Message David G. Johnston 2016-06-02 01:12:43 Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3