Re[2]: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284

From: Дмитрий <dsolik(at)mail(dot)ru>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re[2]: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284
Date: 2025-01-25 17:03:16
Message-ID: 1737824596.412916010@f733.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


1) What sort of replication?
- Streaming replication
2) Where are the two servers located relative to each other?
- The servers are located in different data centers.
3) Has there been any software upgrades/network changes recently?
- I don't know any information about the  software upgrades/network суббота, 25 января 2025г., 19:31 +03:00 от Adrian Klaver adrian(dot)klaver(at)aklaver(dot)com :

>On 1/25/25 06:58, Дмитрий wrote:
> Hello everyone!
>
> Please help me with the error: FATAL: could not send data to WAL stream:
> lost synchronization with server: got message type "0", length 892351284 .
> Replication worked for more than a month and now there is such a
> problem. Restarting PostgreSQL helps.
> How can I fix this error?
>This is going to need more information:
>
>1) What sort of replication?
>
>2) Where are the two servers located relative to each other?
>
>3) Has there been any software upgrades/network changes recently?
>
>
> Source:
> PostgreSQL 15.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
> 20150623 (Red Hat 4.8.5-44), 64-bit
> CentOS Linux release 7.8.2003 (Core)
> Filesystem type ext4
>
> Receiver:
> PostgreSQL 15.10 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0
> 20240719 (Red Hat 11.5.0-2), 64-bit
> Red Hat Enterprise Linux release 9.5 (Plow)
> Filesystem type xfs
>
>
> Thank you.
>
>
>--
>Adrian Klaver
>adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-01-25 17:32:27 Re: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284
Previous Message Adrian Klaver 2025-01-25 16:31:45 Re: FATAL: could not send data to WAL stream: lost synchronization with server: got message type "0", length 892351284