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
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 |