Re: wal exist in slave but getting err requested WAL segment has already been removed

From: Kenneth Marshall <ktm(at)rice(dot)edu>
To: Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>
Cc: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: wal exist in slave but getting err requested WAL segment has already been removed
Date: 2018-07-11 13:50:53
Message-ID: 20180711135053.GU27560@aart.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mariel Cherkassky 2018-07-11 14:12:50 Re: wal exist in slave but getting err requested WAL segment has already been removed
Previous Message Mariel Cherkassky 2018-07-11 13:44:24 Re: wal exist in slave but getting err requested WAL segment has already been removed