pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Kenneth Marshall <ktm@rice.edu>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: wal exist in slave but getting err requested WAL segment has already been removed
Date: Wed, 11 Jul 2018 08:50:53 -0500
Message-ID: <20180711135053.GU27560@aart.rice.edu> (raw)
In-Reply-To: <CA+t6e1n==PHG525gTGAPmx+W8YC4khnT4aL6zeke6FH51q-ECA@mail.gmail.com>
References: <CA+t6e1kW7vihQesZhwToxa2HQ1zMj5Jr=mM=Rh0cXC+SofkKig@mail.gmail.com>
	<9f931b88-725f-7020-ebb2-a2446b7ff9e6@matrix.gatewaynet.com>
	<CA+t6e1ng9Jx8quMWimfGKyTuaSiL3azj6woDEeix-r1mtgzP1w@mail.gmail.com>
	<49a8b5fc-e181-ff57-ea51-f9a2753b4dbc@matrix.gatewaynet.com>
	<CA+t6e1n==PHG525gTGAPmx+W8YC4khnT4aL6zeke6FH51q-ECA@mail.gmail.com>

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

view thread (7+ messages)  latest in thread

Message-ID: <20180711135053.GU27560@aart.rice.edu>
Permalink:  ../20180711135053.GU27560@aart.rice.edu/
Also on:    postgresql.org/message-id/20180711135053.GU27560@aart.rice.edu

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ktm@rice.edu, mariel.cherkassky@gmail.com, achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
  Subject: Re: wal exist in slave but getting err requested WAL segment has already been removed
  In-Reply-To: <20180711135053.GU27560@aart.rice.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox