5

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

trincot
  • 317,000
  • 35
  • 244
  • 286
Sunitha G
  • 119
  • 1
  • 7
  • Possible duplicate of ["Out of Memory Error (Java)" when using R and XLConnect package](https://stackoverflow.com/questions/7963393/out-of-memory-error-java-when-using-r-and-xlconnect-package) – Fredulom Jul 21 '17 at 10:15
  • 1
    did you try `gc(); memory.limit(1e+10) ` ? – quant Jul 21 '17 at 10:26

2 Answers2

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.

drmariod
  • 11,106
  • 16
  • 64
  • 110
0

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

hiba akroush
  • 11
  • 2