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