public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: CLOSE_WAIT pileup and Application Timeout
Date: Fri, 4 Oct 2024 08:47:11 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKgGyB91QVCOFp+3vAcMDAauAPQ+TOVWrJxwcVAtYxaLxXaz4Q@mail.gmail.com>
References: <CAKgGyB91QVCOFp+3vAcMDAauAPQ+TOVWrJxwcVAtYxaLxXaz4Q@mail.gmail.com>

On 10/3/24 21:29, KK CHN wrote:
> List,
> 
> I am facing a  network (TCP IP connection closing issue) .
> 
> Running a  mobile tablet application, Android application to update the 
> status of vehicles fleet say around 1000 numbers installed with the app 
> on each vehicle along  with a  vehicle tracking  application server 
> solution based on Java and Wildfly with  PosrgreSQL16 backend.
> 

> 
> The  running vehicles may disconnect  or be unable to send the location 
> data in between if the mobile data coverage is less or absent in a 
> particular area where data coverage is nil or signal strength less.
> 
> The server on which the backend application runs most often ( a week's 
> time  or so) shows connection timeout and is unable to serve tracking  
> of  the vehicles further.
> 
> When we restart the  Wildfly server  the application returns to normal.  
> again the issue repeats  after a week or two.

Seems the issue is in the application server. What is not clear to me is 
whether the connection timeout you refer to is from the mobile devices 
to the application or the application to the Postgres server? I'm 
guessing the latter as I would expect the mobile devices to drop 
connections more often then weekly.
> 
> In the Server machine when this bottleneck occurs  I am seeing  a lot 
> of  TCP/IP CLOSE_WAIT   ( 3000 to 5000 ) when the server backend becomes 
> unresponsive.

Again not clear, are you referring to the application or the Postgres 
database running on the server?

> 
> What is the root cause of this issue ?   Is it due to the android 
> application unable to send the CLOSE_WAIT ACK due to poor mobile data 
> connectivity ?
> 
> 
>   If so, how do people  address this issue ?  and what may be a fix ?
> 
>   Any  directions / or reference material most welcome.
> 
> Thank you,
> Krishane
> 
> 
> 
> 
> 

-- 
Adrian Klaver
[email protected]

view thread (3+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: CLOSE_WAIT pileup and Application Timeout
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox