Hi Eric,
Thank you for the response. Primary is accepting the ssl connections .Stand by is in sync with primary all the time but
wereceive 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@eradman.com]
Sent: Thursday, February 22, 2018 11:28 AM
To: Kolla, Mahesh <Mahesh.Kolla@transunion.com>; pgsql-bugs@lists.postgresql.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@transunion.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=