Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceede d

[Longshot123]

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceede
d
at java.util.regex.Matcher.(Unknown Source)
at java.util.regex.Pattern.matcher(Unknown Source)
at org.apache.poi.xssf.usermodel.XSSFRichTextString.utfDecode(XSSFRichTe
xtString.java:481)
at org.apache.poi.xssf.usermodel.XSSFRichTextString.getString(XSSFRichTe
xtString.java:297)
at org.apache.poi.xssf.usermodel.XSSFCell.getStringCellValue(XSSFCell.ja
va:247)
at com.ka.spreadsheet.diff.CellExcel.getStringValue(SpreadSheetExcel.jav
a:152)
at com.ka.spreadsheet.diff.CellPos.getStringValue(CellPos.java:34)
at com.ka.spreadsheet.diff.SpreadSheetDiffer.doDiff(SpreadSheetDiffer.ja
va:99)
at com.ka.spreadsheet.diff.SpreadSheetDiffer.doDiff(SpreadSheetDiffer.ja
va:61)
at com.ka.spreadsheet.diff.SpreadSheetDiffer.main(SpreadSheetDiffer.java
:54)

BTW...Each file was 1.74MB in size. Only one cell was different in the row 5 for me to test it. It provided the output difference and then my computer's fan kicked in right before getting this error. Computer has 32GB of RAM.

[pmeier82-zz]

​You can allocate more ram to the jvm heap with the -Xmx​ toggle.​ It is set to 512MB by default.

[Longshot123]

Thank you. I had to get it up to 4096 before it quit erroring out, but it fixed the problem.

[na-ka-na]

Yes unfortunately it reads in the whole spreadsheets in memory before starting diff. Haven't spent any time to trying to figure out if we can read the files in chunks. With 4GB you must have really large files ?!