Some addition to that case.
I was not able to run the script again. The first I got the same error with
the Heap Stack.
But after that somehow I got a Connection Refused Error. All the time. I
tried to restart the server and reset the database. Nothing happened. That
waited some time and tried some other import scripts. Somehow now it worked
again.
So now I started the import again. I will look on how long it needs to
reach the Heap Space error.
But really need more instructions!
Am Donnerstag, 18. September 2014 08:51:00 UTC+2 schrieb Curtis Mosters:
>
> 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 neo4j+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
