This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
Build: NetBeans IDE 7.4 (Build 201310111528) VM: Java HotSpot(TM) 64-Bit Server VM, 23.21-b01, Java(TM) SE Runtime Environment, 1.7.0_21-b11 OS: Windows 7 User Comments: kwoodle: don't remember Stacktrace: java.lang.OutOfMemoryError: GC overhead limit exceeded at java.lang.SecurityManager.checkPackageAccess(SecurityManager.java:1528) at java.lang.ClassLoader$1.run(ClassLoader.java:494) at java.lang.ClassLoader$1.run(ClassLoader.java:492) at java.security.AccessController.doPrivileged(AccessController.java:0) at java.lang.ClassLoader.checkPackageAccess(ClassLoader.java:492) at org.netbeans.modules.sampler.InternalSampler.createInternalSampler(InternalSampler.java:83)
Created attachment 144562 [details] stacktrace
OOME is cause by processing select statement, which returns a lot of results. Retained size of java.util.ArrayList#13700 is 750M and this ArrayList contains 2032797 instances of com.mysql.jdbc.ByteArrayRow
*** Bug 241449 has been marked as a duplicate of this bug. ***
*** Bug 243450 has been marked as a duplicate of this bug. ***
Ok - I reevaluated the "scrollable cursor support". It turns out, that the first evaluation was done with to small tables. Basicly none of the tested drivers supports big tables well when scrollable cursors are requested: - postgresql + mysql both flood the heap (mysql can be fixed with useCursorFetch property, but it is then slow) - derby is slow So my advice: If you encounter problems with existing connections, check the state of "Use scrollable cursors" if checked, uncheck it and test again. I disabled scrollable cursor support by default for now (works only for new connections): http://hg.netbeans.org/core-main/rev/846850870fab Please see if the above explanation helps. If so, please change the state of this bug from FIXED to VERIFIED.