Re: CLOSE_WAIT pileup and Application Timeout

2024-10-07 Thread Alvaro Herrera
On 2024-Oct-07, KK CHN wrote: > On Mon, Oct 7, 2024 at 12:07 AM Alvaro Herrera > wrote: > Where do I have to introduce the TCP keepalives ? in the OS level or > application code level ? > > [root@dbch wildfly-27.0.0.Final]# cat /proc/sys/net/ipv4/tcp_keepalive_time > 7200 > [root@dbch wildfly-2

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-07 Thread KK CHN
On Mon, Oct 7, 2024 at 12:07 AM Alvaro Herrera wrote: > On 2024-Oct-04, KK CHN wrote: > > > 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 thr

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-06 Thread Alvaro Herrera
On 2024-Oct-04, KK CHN wrote: > 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

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-06 Thread Adrian Klaver
On 10/6/24 06:26, KK CHN wrote: On Fri, Oct 4, 2024 at 9:17 PM Adrian Klaver 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 s

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-06 Thread KK CHN
On Fri, Oct 4, 2024 at 9:17 PM Adrian Klaver wrote: > 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 i

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-04 Thread Adrian Klaver
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  app

Re: CLOSE_WAIT pileup and Application Timeout

2024-10-04 Thread Francesco Benetton
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