pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Application outage with XX000: could not receive data from client: Connection timed out 2+ messages / 2 participants [nested] [flat]
* Application outage with XX000: could not receive data from client: Connection timed out @ 2020-04-22 00:11 Pavan Kumar <pavan.dba27@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Pavan Kumar @ 2020-04-22 00:11 UTC (permalink / raw) To: Pgsql-admin <pgsql-admin@lists.postgresql.org> 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, 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 * ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Application outage with XX000: could not receive data from client: Connection timed out @ 2020-04-22 02:05 Jerry Sievers <gsievers19@comcast.net> parent: Pavan Kumar <pavan.dba27@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Jerry Sievers @ 2020-04-22 02:05 UTC (permalink / raw) To: Pavan Kumar <pavan.dba27@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-04-22 02:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-04-22 00:11 Application outage with XX000: could not receive data from client: Connection timed out Pavan Kumar <pavan.dba27@gmail.com> 2020-04-22 02:05 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox