public inbox for [email protected]help / color / mirror / Atom feed
SSL SYSCALL error during logical replication 3+ messages / 2 participants [nested] [flat]
* SSL SYSCALL error during logical replication @ 2024-12-09 07:24 Rijesh TP <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Rijesh TP @ 2024-12-09 07:24 UTC (permalink / raw) To: [email protected]; +Cc: Rajin Raj <[email protected]>; Srikar Vankadaru <[email protected]> Hi Team, We are encountering an issue with logical replication on PostgreSQL version 15.10. The error message is as follows: *"ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF detectedLOG: background worker "logical replication worker" (PID 3286) exited with exit code 1."* Logical replication had been working perfectly on version 15.8, and we successfully completed multiple systems on that version. However, after upgrading to PostgreSQL 15.10, this issue has arisen. We’ve tried adjusting various parameters but haven’t had any success. We have also tried disabling the SSL and selinux etc, but no luck, same error every time. Replication fails at some point without any additional errors, leading us to suspect a potential bug in logical replication for version 15.10. Has anyone else reported a similar issue, or is there a known fix for this? Please let us know if additional details are required. PG Version : postgresql 15.10 OS Details : CentOS 7 Thanks & Regards, Rijesh ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SSL SYSCALL error during logical replication @ 2024-12-09 16:22 Tom Lane <[email protected]> parent: Rijesh TP <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Tom Lane @ 2024-12-09 16:22 UTC (permalink / raw) To: Rijesh TP <[email protected]>; +Cc: [email protected]; Rajin Raj <[email protected]>; Srikar Vankadaru <[email protected]> Rijesh TP <[email protected]> writes: > We are encountering an issue with logical replication on PostgreSQL version > 15.10. The error message is as follows: > *"ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF > detectedLOG: background worker "logical replication worker" (PID 3286) > exited with exit code 1."* This seems to be a symptom of something going wrong on the sending side. Have you looked into that postmaster's log file to see what happened? regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SSL SYSCALL error during logical replication @ 2024-12-20 10:18 Rijesh TP <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Rijesh TP @ 2024-12-20 10:18 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected]; Rajin Raj <[email protected]>; Srikar Vankadaru <[email protected]> Hi Tom, Thanks for the reply. On the source DB, we're seeing these messages coming up often, but there aren't any other errors showing up. All DB parameters including timeout we set to high, but no luck yet. Pls advise on this *user=replicator DEBUG: failed to increase restart lsn: proposed 13EB/B420DE18, after 13EB/B420DE18, current candidate 13EB/B420DD70, current after 13EB/B420DD70, flushed up to 13EB/B420DBB0* Thanks & Regards, Rijesh On Mon, Dec 9, 2024 at 9:52 PM Tom Lane <[email protected]> wrote: > Rijesh TP <[email protected]> writes: > > We are encountering an issue with logical replication on PostgreSQL > version > > 15.10. The error message is as follows: > > > *"ERROR: could not receive data from WAL stream: SSL SYSCALL error: EOF > > detectedLOG: background worker "logical replication worker" (PID 3286) > > exited with exit code 1."* > > This seems to be a symptom of something going wrong on the sending > side. Have you looked into that postmaster's log file to see what > happened? > > regards, tom lane > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-12-20 10:18 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-12-09 07:24 SSL SYSCALL error during logical replication Rijesh TP <[email protected]> 2024-12-09 16:22 ` Tom Lane <[email protected]> 2024-12-20 10:18 ` Rijesh TP <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox