Possible bug when running an heavy Query

[bennu_neo (Harold Agudelo-Ramirez)]

Hi @paolodipietro58 ,

I suggest you to read this 2 posts.

Cypher Sleuthing: the eager operator

[image] Why is it that some query syntax seems to run faster than another when there is very little difference between the statements? Sometimes, queries will invoke what is called the eager operator in order to maintain consistent operations and avoid conflicting data changes. It still leaves the question, though, of what does this eager operation do differently and why would it be important enough to specifically avoid in certain situations? What are those situations where we would want to c…

Neo4j: Cypher - Avoiding the Eager | Mark Needham

Your DBMS is dying due to garbage collection issues, this line 2022-04-29 16:15:00.868+0000 WARN [o.n.k.i.c.VmPauseMonitorComponent] Detected VM stop-the-world pause: {pauseTime=30391, gcTime=10186, gcCount=2} means that your db paused for more than 30 seconds (and I guess its not the only pause. This is mainly due to lack of query tuning.

Can you split your logic of transaction creation and other elements in a way that the Plan of each query doesn't contain any eager operation?

Regards,

Bennu