Pavan Kumar <pavan.dba27@xxxxxxxxx> 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@xxxxxxxxxxx
