From: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
---|---|
To: | Pavan Kumar <pavan(dot)dba27(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Application outage with XX000: could not receive data from client: Connection timed out |
Date: | 2020-04-22 02:05:21 |
Message-ID: | 87tv1cqnq6.fsf@jsievers.enova.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Pavan Kumar <pavan(dot)dba27(at)gmail(dot)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(dot)consulting(at)comcast(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | raf | 2020-04-22 03:51:32 | Re: Newbie needs help with space issue |
Previous Message | Pavan Kumar | 2020-04-22 00:11:43 | Application outage with XX000: could not receive data from client: Connection timed out |