Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication failed - Mailing list pgsql-admin

From Rambabu V
Subject Re: Replication failed
Date
Msg-id CADtiZxo_rQDTMX0iHhFutihjs=Q2UOAcgdGYisfT9B+hQCD6Dg@mail.gmail.com
Whole thread Raw
In response to Re: Replication failed  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Replication failed  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
Hi Laurenz,

please let us know how to apply the patch, we are able to see below attachments , once downloaded how to apply this patch.

AttachmentContent-TypeSize
repro_helper.patchapplication/octet-stream1.3 KB
ready_file_fix.patchapplication/octet-stream

On Fri, Dec 18, 2020 at 2:13 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2020-12-18 at 00:56 +0530, Sreejith P wrote:
> We had 1 M x 4 slave server streaming replication using Postgres 10. Was working successfully for long time.
>
> Suddenly all replication servers got failed and getting following message.
>
> 2020-12-17 22:24:32 +04 [1587]: [357-1] db=,user=LOG:  invalid contrecord length 2722 at AEA/A1FFF9E0.
>
> Requesting help for identifying root cause.

Looks like this problem:
https://postgr.es/m/77734732-44A4-4209-8C2F-3AF36C9D4D18%40amazon.com

Was there a crash on the primary sever?

There is a patch under development at this thread:
https://postgr.es/m/CBDDFA01-6E40-46BB-9F98-9340F4379505%40amazon.com

Yours,
Laurenz Albe



pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Grant request
Next
From: Laurenz Albe
Date:
Subject: Re: Replication failed