Neo4j crashes while exporting

memory

(Mehdi Ajroud) #1

I am trying to export data in one table from neo4j but after some time , neo4j just crashes and I am getting this error in the terminal :

Knowing that I already changed these lines to:
dbms.memory.heap.initial_size=2g
dbms.memory.heap.max_size=5g

and I uncommented this line :
dbms.memory.pagecache.size=10g

But still not working :(


(Michael Hunger) #2

How much memory does your machine have?

This allocates 15G to your JVM
Plus OS and some extras you are currently allocating 16G+

Not sure if you have so much memory.


(Michael Hunger) #3

What was your export issue again? If you have already posted it please link about it, otherwise post the details.


(Mehdi Ajroud) #4

It's not related to any issue , I am just trying to run this query :

match (a:Attributaire2018)-[r:CollaborateWith2018]-(b:Attributaire2018)
optional match (c:Cluster2018)
return c.id as ClusterID , a.id as AttributaireDepart , b.id as AttributaireArrive ,r.weight as weight ,  a.name as Name_AttribDepart , b.name as Name_AttribArrive


(Michael Hunger) #5

you didn't answer the question for your machine memory

you should add a direction.
why do you match that cluster for each row? do it once before the other match.
I hope this one only returns one row otherwise you get a cross product.

(c:Cluster2018)

how do you consume the data? You should do that in a streaming manner.