Page 1 of 1

Clients not shutting down

PostPosted: Mon Nov 01, 2021 3:42 pm
by francisco.garcia
Hi, we are running Servoy 2020.12.1 -releaseNumber 3623 over Apache Tomcat/7.0.76 and we are facing a problem.
When clients close our solutions from the "x" button on the navigator those clients kept connected and the Servoy Admin page shows them with status "No Websockets".
This behaviour did not happen in the past, clients could close their sessions whenever they want and it didn't matter if they did this from the "x" button nor from the "Close Session" button.
This causes the accumulation of bunch of clients and at some point the server freezes.
Please help.
Thanks in advance.
I attach our network settings.

Re: Clients not shutting down

PostPosted: Wed Nov 03, 2021 9:12 pm
by Richard1521662995
Hi,

Get the exact same problem from time to time. Hit the problem this morning, had imported my solution yesterday. Restarted Tomcat and users now disconnecting as expected. Beginning to wonder if this behaviour is linked to importing a solution.

Servoy 2021.3.0.3642
Tomcat 9.0.53

Richard

Re: Clients not shutting down

PostPosted: Fri Nov 12, 2021 9:09 am
by Andrei Costescu
It looks like you are using NG client. In this case the setting "sablo.window.timeout.secs" from "NG Client Settings" is the one that should matter.
But that "No Websockets" message is unexpected indeed. Something seems to keep those clients from getting cleaned up.

If you have this happen again please take a sequence of a 2-3 stackdumps some time (let's say 30 sec) apart from the "Dump the current stack/systeminfo" link of the admin page. It should show what the solution or clean-up code is doing.
And then either create a case or post it here if you like.

But you are not using the latest version, so there is a possibility that this problem is already fixed.

Re: Clients not shutting down

PostPosted: Wed Nov 24, 2021 10:02 am
by steve1376656734
Could this be the same issue we are experiencing and logged as SVY-15862? It is caused by a deadlock in the hsqldb driver and clients can’t drop any in-mem tables that they have created on exit. This also results in clients “hanging around” with the “No websockets” message until eventually the server dies and needs a restart.

Re: Clients not shutting down

PostPosted: Wed Nov 24, 2021 10:40 am
by Andrei Costescu
It is possible, but we cannot know for sure without stack dumps.

Re: Clients not shutting down

PostPosted: Wed Nov 24, 2021 10:49 am
by jcompagner
if you are using in mem tables then yes this could happen especially when also using transactions.

if you are using 2021.06 you can try to use this update.zip on top of a 06 installation: https://build.servoy.com/latest/servoy_ ... update.zip (this zip works for 09 until around 1st of december then this link won't work anymore for 09)