java.lang.OutOfMemoryError: GC overhead limit exceeded

Question

In R Studio using R, when trying to join 2 tables which have about 100k records(DB2 DB), getting below error and none of the google solutions worked.

Error 'in .jcall(x, "S", "getMessage")': java.lang.OutOfMemoryError: GC overhead limit exceeded

Possible duplicate of "Out of Memory Error (Java)" when using R and XLConnect package — Fredulom
– Fredulom, Commented Jul 21, 2017 at 10:15

drmariod · Accepted Answer · 2019-03-19 14:23:26Z

1

I had this problem several times, sometimes randomly. What helped me so far was using the following command at the beginning of the script before loading any other package!

options(java.parameters = c("-XX:+UseConcMarkSweepGC", "-Xmx8192m"))

The -XX:+UseConcMarkSweepGC loads an alternative garbage collector which seemed to make less problems than the standard GC.

answered Mar 19, 2019 at 14:23

drmariod

11.9k17 gold badges72 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hiba akroush · Accepted Answer · 2018-12-23 13:32:44Z

0

if you are using intillij On the main menu, choose File. Invalidate Caches/Restart

answered Dec 23, 2018 at 13:32

hiba akroush

112 bronze badges

Collectives™ on Stack Overflow

java.lang.OutOfMemoryError: GC overhead limit exceeded

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related