If you connect to the server it uses the servers RAM The shell then needs much less like 512m
Can you check the server's graph.db/messages.log for the root cause error? Which version? Sent from mobile device Am 18.09.2014 um 14:28 schrieb "'Curtis Mosters' via Neo4j" <[email protected]>: > Well I was thinking that the Xmx is the heap and it should be not above 4 GB, > so far I have learned. > > I currently let the import run with "COMMIT 100" so every 100 lines, and it's > still running. > > But looking on the IO it seems to idle... > > I don't know, but could you tell me exactly where to set which setting? > > As I said I have 30 GB RAM. To avoid more complications let's maybe set the > Heap 4 GB and the maximum RAM to 20 GB. > > And again I use the Neo4jShell for the import. It's loading a file containing > LOAD CSV. > > Thanks. > > Am Donnerstag, 18. September 2014 13:42:34 UTC+2 schrieb Clark Richey: >> >> According to the screenshot you don't give it 30G of ram. You only provide >> 3G. Is that your intent? >> >> Sent from my iPhone >> >> On Sep 18, 2014, at 02:51, 'Curtis Mosters' via Neo4j >> <[email protected]> wrote: >> >>> Well somehow the behaviour of the Shell is odd. >>> >>> I imported 76 Mio lines without any problems. But now I have started a new >>> import over night and now I watched the process and it said Java Heap Space >>> Error. >>> >>> But that cannot be. I have set the Neo4jShell.bat like this: >>> >>> %JAVACMD% -Xmx3G -Dstorage.diskCache.bufferSize=20000 %JAVA_OPTS% >>> %EXTRA_JVM_ARGUMENTS% -classpath %CLASSPATH_PREFIX%;%CLASSPATH% >>> -Dapp.name="neo4j-shell" -Dapp.repo="%REPO%" -Dbasedir="%BASEDIR%" >>> org.neo4j.shell.StartClient %CMD_LINE_ARGS% >>> >>> That is a great ratio of heap. But yeah why did I get this error? I have 30 >>> GB RAM. This happens so random that a productive import is nearly >>> impossible. >>> >>> So my question is, what have I done wrong? Where do I need to set the Java >>> Settings correctly? Were my edited settings active? >>> >>> Here the first file or let's say script i'm loading in and where this error >>> happens: >>> >>> USING PERIODIC COMMIT 2000 >>> LOAD CSV WITH HEADERS FROM "file:///C:/data/tls202_part01.txt" AS csvLine >>> WITH csvLine LIMIT 1000 >>> MATCH (appln:Appln) >>> WHERE appln.ID = toInt(csvLine.appln_id) >>> CREATE (title:Title { title:csvLine.appln_title }) >>> CREATE (appln)-[:HAS_TITLE]->(title); >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Neo4j" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
