Postgres Pro
Downloads
Home   >   mailing lists

Re: wal exist in slave but getting err requested WAL segment hasalready been removed - Mailing list pgsql-admin

From Kenneth Marshall
Subject Re: wal exist in slave but getting err requested WAL segment hasalready been removed
Date
Msg-id 20180711135053.GU27560@aart.rice.edu
Whole thread Raw
In response to Re: wal exist in slave but getting err requested WAL segment hasalready been removed  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Responses Re: wal exist in slave but getting err requested WAL segment hasalready been removed  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
List pgsql-admin
Tree view 
On Wed, Jul 11, 2018 at 04:44:24PM +0300, Mariel Cherkassky wrote:
> Yes i can see its content. However in the end of its content I'm getting
> the next msg :
> pg_xlogdump: FATAL:  error in WAL record at 2E61/BDF59950: invalid magic
> number 0000 in log segment 0000000000002E61000000BD, offset 16105472
> Maybe this is the reason behind it ?
> 

Hi Mariel,

I do not know if this applies to your case, but 9.6.9 has this
in the release notes:

Fix a corner case where a streaming standby gets stuck at a WAL continuation record (Kyotaro Horiguchi)

Regards,
Ken

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: wal exist in slave but getting err requested WAL segment hasalready been removed
Next
From: Mariel Cherkassky
Date:
Subject: Re: wal exist in slave but getting err requested WAL segment hasalready been removed