[ http://issues.apache.org/jira/browse/DERBY-912?page=comments#action_12443644 ] Knut Anders Hatlen commented on DERBY-912: ------------------------------------------
The problem seems to be that RAMTransaction.sorts is only cleared when the connection is closed, not when the transaction is committed. RAMTransaction.commit() calls closeControllers() with closeHeldControllers=false, so sorts.removeAllElements() is not called on commit. > OutOfMemory error on continuous execution of SQL statement > ---------------------------------------------------------- > > Key: DERBY-912 > URL: http://issues.apache.org/jira/browse/DERBY-912 > Project: Derby > Issue Type: Sub-task > Components: Store > Affects Versions: 10.0.2.0 > Environment: cygwin, jdk 1.4 > Reporter: Manish Khettry > > After fixing the original memory leak, I still run into problems on repeated > execution of a sql statement. Take the sample program in the bug and run it > with a small heap size (4m). After around 80-90K executions an outofmemory > error is thrown. I took snapshots of the heap while the program was running > but couldn't find anything obviously wrong. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira