CLOSE_WAIT pileup and Application Timeout

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: CLOSE_WAIT pileup and Application Timeout
Date: 2024-10-04 04:29:33
Message-ID: CAKgGyB91QVCOFp+3vAcMDAauAPQ+TOVWrJxwcVAtYxaLxXaz4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francesco Benetton 2024-10-04 11:41:16 Re: CLOSE_WAIT pileup and Application Timeout
Previous Message Adrian Klaver 2024-10-03 15:31:53 Re: How to handle "could not find function xml_is_well_formed" when restoring database in Version 17