public inbox for [email protected]
help / color / mirror / Atom feedFrom: Francesco Benetton <[email protected]>
To: KK CHN <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: CLOSE_WAIT pileup and Application Timeout
Date: Fri, 4 Oct 2024 13:41:16 +0200
Message-ID: <CACJJLizTMX=yYfScuoPZ0=tfh5wdd3P09pSYnBu+Bsh6C6=CLw@mail.gmail.com> (raw)
In-Reply-To: <CAKgGyB91QVCOFp+3vAcMDAauAPQ+TOVWrJxwcVAtYxaLxXaz4Q@mail.gmail.com>
References: <CAKgGyB91QVCOFp+3vAcMDAauAPQ+TOVWrJxwcVAtYxaLxXaz4Q@mail.gmail.com>
If I understand clearly, postgresql is used as a Data server for the
backend, and so the Android app does not connect directly to postgresql.
The first idea is a problem on closing or recycling the connection by the
backend after executing the request. Maybe wrong client connection pooling
settings?
Il ven 4 ott 2024, 06:29 KK CHN <[email protected]> ha scritto:
> 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 mobile tablets are installed with the android based vehicle
> tracking app which updated every 30 seconds its location fitted inside the
> vehicle ( lat long coordinates) to the PostgreSQL DB through the java
> backend application to know the latest location of the vehicle and its
> movement which will be rendered in a map based front end.
>
> The vehicles on the field communicate via 443 to 8080 of the Wildfly
> (version 27 ) deployed with the vehicle tracking application developed with
> Java(version 17).
>
>
> * The mobile tablet communicates to the backend application over mobile
> data (4G/5G SIMS). *
>
> 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.
>
> 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.
>
> 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
>
>
>
>
>
>
view thread (5+ 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: <CACJJLizTMX=yYfScuoPZ0=tfh5wdd3P09pSYnBu+Bsh6C6=CLw@mail.gmail.com>
* 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