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

Hello Tom ,

Please let me know why we are getting below associated LOGS saying invalid resource manager with the FATAL message Unable to receive data from WAL Stream Error

> 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

Please kindly suggest us a value for tcp_keepalives_idle as it is presently set to 0

Thank you
Mahesh Kolla
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 22, 2018 12:19 PM
To: Kolla, Mahesh <Mahesh(dot)Kolla(at)transunion(dot)com>
Cc: Eric Radman <ericshane(at)eradman(dot)com>; pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15078: Unable to receive data from WAL Stream Error

"Kolla, Mahesh" <Mahesh(dot)Kolla(at)transunion(dot)com> writes:
> 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

I doubt this is a PG bug; it sounds more like a networking problem.
Maybe there's a router or firewall in between that is timing out your connections too easily. If you can't adjust the network infrastructure, you could try enabling TCP keepalives (with a shorter repeat interval than the default) on the replication connections.

regards, tom lane