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.
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, LLCCell # 267-799-3182 # pavan.dba27 (Gtalk) India # 9000459083Take Risks; if you win, you will be very happy. If you lose you will be Wise