StackOverflow error with 1200 lines of CREATE statements

[Kevin Greene]

I'm having a weird stack overflow error with Neo4j, if someone could take a look I'd appreciate it.

I've been working on the GraphGist winter challenge, and my progress is here: https://gist.github.com/KevinGreene/8493604. If you run this in graphgist, there is a stack overflow error, so I tried running it against my local neo4j instance.

If I run the entire 1200 lines of CREATE statements, it hangs at "Executing Query".

If I run the first ~1100 lines, it succeeds.

However, if I run the first ~1100 lines, delete all nodes / relationships, then run the entire 1200 lines, it succeeds. I've considered rewriting it to be more succinct, but I'm not sure that will fix the issue.

Below is the start of the error from console.log:

14:27:46.678 [qtp372381930-59] WARN  o.e.jetty.servlet.ServletHandler - Error for /db/data/transaction/commit

java.lang.StackOverflowError: null

        at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:176) ~[scala-library-2.10.3.jar:na]

        at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:45) ~[scala-library-2.10.3.jar:na]

        at scala.collection.TraversableLike$class.to(TraversableLike.scala:629) ~[scala-library-2.10.3.jar:na]

        at scala.collection.AbstractTraversable.to(Traversable.scala:105) ~[scala-library-2.10.3.jar:na]

        at scala.collection.TraversableOnce$class.toList(TraversableOnce.scala:257) ~[scala-library-2.10.3.jar:na]

        at scala.collection.AbstractTraversable.toList(Traversable.scala:105) ~[scala-library-2.10.3.jar:na]

        at scala.collection.immutable.List$.apply(List.scala:400) ~[scala-library-2.10.3.jar:na]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.compact(Query.scala:73) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query$$anonfun$tailQ$lzycompute$1$1.apply(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query$$anonfun$tailQ$lzycompute$1$1.apply(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at scala.Option.map(Option.scala:145) ~[scala-library-2.10.3.jar:na]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.tailQ$lzycompute$1(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.tailQ$1(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.compact(Query.scala:82) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query$$anonfun$tailQ$lzycompute$1$1.apply(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query$$anonfun$tailQ$lzycompute$1$1.apply(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at scala.Option.map(Option.scala:145) ~[scala-library-2.10.3.jar:na]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.tailQ$lzycompute$1(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.tailQ$1(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query.compact(Query.scala:82) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

        at org.neo4j.cypher.internal.compiler.v2_0.commands.Query$$anonfun$tailQ$lzycompute$1$1.apply(Query.scala:79) ~[neo4j-cypher-compiler-2.0-2.0.0.jar:2.0.0]

[Michael Hunger]

The GraphGist was never meant to handle such amounts of data, it runs a tiny tiny in-memory version of Neo4j in many parallel sessions, please limit your data size there to at most 100 nodes.

Do you get the same issue in the Neo4j-Shell on your local system?

There was a similar issue lately which will be fixed in 2.0.1

Michael

--
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+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Nithyananda Thiagarajan]

Im using Neo4j 2.1.0-M01 and facing the same issues as Kevin. Im trying to create around 1790 nodes. Please suggest workarounds of any . Below is a snippet of the console.log

22:55:48.807 [qtp866526631-75] WARN  o.e.jetty.servlet.ServletHandler - Error for /db/data/transaction/commit
java.lang.StackOverflowError: null
    at scala.collection.IndexedSeqOptimized$class.foreach(IndexedSeqOptimized.scala:32) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.mutable.WrappedArray.foreach(WrappedArray.scala:34) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:48) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:176) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.mutable.ListBuffer.$plus$plus$eq(ListBuffer.scala:45) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.TraversableLike$class.to(TraversableLike.scala:629) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]
    at scala.collection.AbstractTraversable.to(Traversable.scala:105) ~[neo4j-desktop-2.1.0-M01.jar:2.1.0-M01]


Thanks!

[Michael Hunger]

Can you share your cypher query?

Michael

-- 
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+un...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.