Recent changes to 1530: Memory leakhttps://sourceforge.net/p/squirrel-sql/bugs/1530/2024-11-18T19:55:40.717000ZRecent changes to 1530: Memory leak#1530 Memory leak2024-11-18T19:55:40.717000Z2024-11-18T19:55:40.717000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.net2bb6c35dcca93067cf055b355661bf71d8d05533<div class="markdown_content"><p>Fixed in our GIT repository. Will be available in future snapshots an versions.</p>
<p>Excerpt from change log:</p>
<blockquote>
<p>'#1530 Memory leak: SQL result tabs were not garbage collect as long as their Session was open.<br/>
Note: When a result tab of an open Session gets garbage collected the following line appears is SQuirreL's logs:<br/>
...INFO ... Result tab finalized for open Session "<...>" with id=<...></p>
</blockquote></div>Memory leak2024-05-20T12:39:55.282000Z2024-05-20T12:39:55.282000ZG.Dimitrovhttps://sourceforge.net/u/zxsec/https://sourceforge.netc8155b31307155ae4e858e064700b8e180c3fdc9<div class="markdown_content"><p>Version 4.7.1, JDK jdk-17.0.9+9, application run w/ option : -Xmx640m</p>
<p>There is a memory leakage, here's an example:<br/>
0. Open application<br/>
1. Open Mysql session ( session content row limit : 10000 )<br/>
Used memory: 88mb; force GC: 29mb<br/>
2. open table : 10000 rows / 27 columns<br/>
Used memory: 172mb : force GC: 39mb<br/>
3. execute: select of 440k rows<br/>
Used memory: 578mb; force GC: 512mb<br/>
4. Close result tab<br/>
force GC: 447mb<br/>
5. select 100k rows<br/>
Used memory: 553 <br/>
6. close result tab <br/>
force GC: 534 mb<br/>
7. select 440k rows<br/>
java.lang.OutOfMemoryError: Java heap space</p>
<p>In some cases, when trying GK to 'reduce' the memory used, the application freezes, for example:<br/>
- Used RAM 500MB - Execute 4 times "Select" which does not return the result (0 rows) in 4 Result Tabs ...</p></div>