SQL Developer freezing with GC overhead limit exceeded error on MySQL database

Question

I am trying to use Oracle SQL Developer with a MySQL database. I can connect just fine and I can execute queries, I can see the tables, and with a table selected I can click on all tabs fine with the exception of the "Data" tab. When I click on the "Data" tab, I get a message "Waiting for Editor to initialize" and SQL Developer freezes. After a few minutes I get a message "GC overhead limit exceeded" with the following stack

java.lang.OutOfMemoryError: GC overhead limit exceeded
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2114)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1921)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3278)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:490)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:274)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:686)
at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:670)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:554)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

I looked around stackoverflow andn google but I could not finf anything that works for me. I am running this on Windows 7 64bit, SQL Developer version 4.0.3.16, MySQL server version 5.5. I have added a line

AddVMOption -Xmx1024M

in the sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file, as suggested here

https://codechief.wordpress.com/2008/07/30/configuring-oracle-sql-developer-for-large-files-fix-out-of-memory-errors/

and also added changed the initial and max memory allocation pool sizes in the C:\Users\\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf file to

AddVMOption -Xms512m

and

AddVMOption -Xmx1024m

respectively. I am monitoring the performance and I am not running out of memory, but the CPU utilization rate goes above 90%.

Thanks!

Answer 1

You need to edit the sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file, adding the following line:-

AddVMOption -Xmx1024M