B4J Question [B4J][BananoServer][BVAD3] Serious Memory Leak

[LJG]

Please help!

I have a B4J/BananoServer/BVAD3 app that includes a "realtime" polling of data from a MSSQL database using DirectDB. It polls the databse about every 10 seconds with the work being done in a BananoServer Background Worker. It depletes all the system memory in about every week. I would appreciate any help that I can get that will help me find and fix this critical issue ... thank you.

Attached is the text file of one of the "hs_err_pid" dump files created in the app's folder when the app crashes.

 

[alwaysbusy]

I don't use BDAV3 or DirectDB, but the most obvious reason you get a memory leak is because you open connections to the pool but do not close them. Also check if you have the correct indexes on your tables (long running queries?). Post the B4J log and check if any Java errors occur that can give you a clue. If possible, also post the source code of what happens in the Background Worker so we can help finding out why this happens.