Application outage with XX000: could not receive data from client: Connection timed out

From: Pavan Kumar <pavan(dot)dba27(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Application outage with XX000: could not receive data from client: Connection timed out
Date: 2020-04-22 00:11:43
Message-ID: CA+M0sHFyFFUbx4wiq3hjUpwgHCXk8DZp7aOmxVqLVNrUNzhaDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 *

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jerry Sievers 2020-04-22 02:05:21 Re: Application outage with XX000: could not receive data from client: Connection timed out
Previous Message John Scalia 2020-04-21 23:49:15 Re: Newbie needs help with space issue