Обсуждение: Application outage with XX000: could not receive data from client:Connection timed out

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

> Hello Experts,
>
> one of our application is getting intermittent outage and they
> are saying database issue. we can only see below message from the
> postgreSQL log file. Apart from this No "FATAL|ERROR|WARNING"
> message. 

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

>
>   2020-04-21 04:26:58.066 GMT [119043] [PostgreSQL JDBC Driver]
> [(51724)] [idle] LOG:  XX000: could not receive data from client:
> Connection timed out
> 2020-04-21 04:26:58.066 GMT [119043]  [PostgreSQL JDBC Driver]
> (51724)] [idle] LOCATION:  pq_recvbuf, pqcomm.c:978
>
> based on the error message connecting is timing out. i am not sure
> which is triggering time out. 
> 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,
>
> #!  Pavan Kumar
> -----------------------------------------------
> Sr. Database Administrator..!
> NEXT GENERATION PROFESSIONALS, LLC
> Cell    #  267-799-3182 #  pavan.dba27 (Gtalk)  
> India   # 9000459083
>
>
>     Take Risks; if you win, you will be very happy. If you lose you
>     will be Wise  
>
>
>

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