using the latest version of apoc & neo4j , with a completely empty db (except index)
with heap size set to 3500M
i am running into following situation :
i execute this iterate and load statement:
CALL apoc.periodic.iterate(
"CALL apoc.load.csv('file:///initialloade1310.csv' , {header:true, sep:'|', quoteChar:'°', failOnError:false, escapeChar: 'µ' } )
YIELD lineNo RETURN lineNo
","
WITH lineNo
MERGE (n:LOADTEST {label:'loadrel'}) set n.lastsuccess = lineNo
",
{batchSize:100, parallel:false , batchMode:'BATCH' }
);
i tried it on a file having 14 gb in size and 47.915.977 rows in input --> no error
i try it on another file having 8 gb in size and 19.991.399 rows in input --> error every time :
Failed to invoke procedure `apoc.periodic.iterate`: Caused by: java.lang.OutOfMemoryError: Java heap space
the query isnt doing anything ... so how come i get the error . any advise is welcome !