Hi!
A little story in front of....
I have to configure the OperatorConsole Server behind a F5-Loadbalancer, no its only one Server, no Loadbalancing, its our policy to put webserver behind that full-Proxy.
However... to get some benefit out of it, and also policy, if the OC is not available a well qualified Error/Maintenance-Page has to occur, no problem, no magic, simple F5-https-Healtcheck, some iRule etc.. no problem works as a charm (normally)
I configured as healthcheck a simple https://<servername>/uimapi/version/api, with a login/password etc. also no magic, comparing the returning json with the version....and so on... all fine...
Now the interessting part for me.
I noticed, I am doing some sort of DoS with that :-), because the wasp opens a fresh DB-Connection, but didnt closes it... simply checked it with a "netstat -ano | find /c ":1433" (Windows w/ mssql 2019-DB) well the count is increasing....from 21 in the morning die several 100 within hours, after some ours the OC is dead, since I wait some hours to reduce the connections.
However... two questions are raising.
- How to determine which app in the wasp is using the connections (I assume operatorconsole_portlet)
- How to reduce the DB-Connection timeout
But most insteressting, naturally I had a look into the Documentation... Web Application Server Probe
Well.... first of all it speaks of wasp 8.1 till 8.3 and for DB-Connections about Tomcat 6.0.... should this still be actual?
Any help is appreciated
Cheers
Matthias