From: Jerry Sievers <gsievers19@comcast.net>
To: Pavan Kumar <pavan.dba27@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Application outage with XX000: could not receive data from client: Connection timed out
Date: Tue, 21 Apr 2020 21:05:21 -0500
Message-ID: <87tv1cqnq6.fsf@jsievers.enova.com> (raw)
In-Reply-To: <CA+M0sHFyFFUbx4wiq3hjUpwgHCXk8DZp7aOmxVqLVNrUNzhaDA@mail.gmail.com>
References: <CA+M0sHFyFFUbx4wiq3hjUpwgHCXk8DZp7aOmxVqLVNrUNzhaDA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, pavan.dba27@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Application outage with XX000: could not receive data from client: Connection timed out
In-Reply-To: <87tv1cqnq6.fsf@jsievers.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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