RE: BUG #15078: Unable to receive data from WAL Stream Error

Hi Eric,

Thank you for the response. Primary is accepting the ssl connections .Stand by is in sync with primary all the time but we receive FATALS sometimes 3 to 4 times a day which make us worry if having any data corruption

This is my official email. So Raised it again. Apologies for that

Thank you
Mahesh Kolla

-----Original Message-----
From: Eric Radman [mailto:ericshane(at)eradman(dot)com]
Sent: Thursday, February 22, 2018 11:28 AM
To: Kolla, Mahesh <Mahesh(dot)Kolla(at)transunion(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15078: Unable to receive data from WAL Stream Error

On Thu, Feb 22, 2018 at 05:22:09PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15078
> Logged by: MAHESH KOLLA
> Email address: mkolla(at)transunion(dot)com
> PostgreSQL version: 9.6.3
> Operating system: RHEL
> Description:

Why are you submitting the same bug report twice?

> < 2018-02-19 01:37:48.847 CST > FATAL: could not receive data from
> WAL
> stream: SSL SYSCALL error: Connection timed out
>
> sh: dev/null: No such file or directory
> sh: dev/null: No such file or directory < 2018-02-19 01:37:48.860 CST
> > LOG: invalid resource manager ID 48 at
> 15/2D69E848
> < 2018-02-19 01:37:48.916 CST > LOG: started streaming WAL from
> primary at
> 15/2D000000 on timeline 1

Is the primary server accepting SSL connections? What does pg_isready report using the same connection parameters?

--
Eric Radman | https://urldefense.proofpoint.com/v2/url?u=http-3A__eradman.com&d=DwIBAg&c=7gn0PlAmraV3zr-k385KhKAz9NTx0dwockj5vIsr5Sw&r=soAMyKP9lXw41tqZFCOuMp8AZeFGh0j-d84gRvShwfQ&m=_ryleXxDO1WUCOpihQwT2hJC2nDbqGzBVmY6mCGsD-E&s=oHIPY0Z1XyWXNQNNq5WEubiAEVjbJo8QppVbqHvrfbk&e=