From: Jerry Sievers <gsievers19@comcast.net>
To: Pavan Kumar <pavan.dba27@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Application outage with XX000: could not receive data from
 client: Connection timed out
References: 
 <CA+M0sHFyFFUbx4wiq3hjUpwgHCXk8DZp7aOmxVqLVNrUNzhaDA@mail.gmail.com>
Date: Tue, 21 Apr 2020 21:05:21 -0500
In-Reply-To: 
 <CA+M0sHFyFFUbx4wiq3hjUpwgHCXk8DZp7aOmxVqLVNrUNzhaDA@mail.gmail.com>
	(Pavan Kumar's message of "Tue, 21 Apr 2020 19:11:43 -0500")
Message-ID: <87tv1cqnq6.fsf@jsievers.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Pavan Kumar <pavan.dba27@gmail.com> writes:

> Hello Experts,
>
> one of our application=C2=A0is getting intermittent outage=C2=A0and they
> are=C2=A0saying database=C2=A0issue. we can=C2=A0only see=C2=A0below mess=
age from the
> postgreSQL log file. Apart from this No "FATAL|ERROR|WARNING"
> message.=C2=A0

I'd suspect firewall and/other network gear idle socket timeouts.

Check for and verify tcp keepalive is enabled at both ends and
aggressive enough to overcome the above, if applicable.

HTH

>
> =C2=A0 2020-04-21 04:26:58.066 GMT [119043] [PostgreSQL JDBC Driver]
> [(51724)] [idle] LOG: =C2=A0XX000: could not receive data from client:
> Connection timed out
> 2020-04-21 04:26:58.066 GMT [119043]=C2=A0 [PostgreSQL JDBC Driver]
> (51724)] [idle] LOCATION: =C2=A0pq_recvbuf, pqcomm.c:978
>
> based on the error message connecting is timing out. i am not sure
> which is triggering time out.=C2=A0
> there is no fire wall between app to database and database side we
> are not keeping any time out.
>
> Any one ran into same issue ? if yes please help us narrow down the
> problem and the possible solution.
>
>
>
>
>
> --
> Regards,
>
> #!=C2=A0 Pavan Kumar
> -----------------------------------------------
> Sr. Database Administrator..!
> NEXT GENERATION PROFESSIONALS, LLC
> Cell =C2=A0 =C2=A0#=C2=A0 267-799-3182 #=C2=A0 pavan.dba27 (Gtalk)=C2=A0=
=C2=A0
> India =C2=A0 # 9000459083
>
>
>     Take Risks; if you win, you will be very happy. If you lose you
>     will be Wise =C2=A0
>
>
>

--=20
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net