Neo4j crashes while exporting

[mehdi_ajroud]

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]

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]

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

[mehdi_ajroud]

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]

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.