SQL Developer freeze over GC limit exceeded error in MySQL database

I am trying to use Oracle SQL Developer with a MySQL database. I can connect just fine, and I can run queries, I can see the tables, and with the table selected, I can click on all the tabs in order except the Data tab. When I click on the Data tab, I get the message Waiting for editor to initialize and SQL Developer hangs. After a few minutes I get the message "GC high 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 at stackoverflow and google but I couldn't finish anything that works for me. I am running this on Windows 7 64bit, SQL Developer version 4.0.3.16, MySQL version 5.5. I added the line

AddVMOption -Xmx1024M

      

in sqldeveloper \ sqldeveloper \ bin \ sqldeveloper.conf 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 changes to the initial and maximum sizes of the memory allocation pool in C: \ Users \\ AppData \ Roaming \ sqldeveloper \ 1.0.0.0.0 \ product.conf for

AddVMOption -Xms512m

      

and

AddVMOption -Xmx1024M

      

respectively. I am monitoring performance and I am running out of memory, but the CPU utilization is over 90%.

Thank!

+3


source to share


2 answers


You need to edit the file sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

by adding the following line: -



AddVMOption -Xmx1024M

      

+4


source


Is there a way to set the XX: + UseParallelGC flag on startup? May help your gc run more efficiently.



0


source







All Articles