I have a written a neo4j kernel plugin in java to perform a specific data load we need into the DB.
The nodes we create are time zone cognizant. Within our code we set the load time of the node using
Up until the end of march it ...
neo4j server version 3.5.1using cypher in cypher shell locally on the database server machine
I'm running the following apoc query:
call apoc.periodic.iterate("match (pr:PolicyReport) where not (pr)-[:FIRST|LAST|NEXT|HAS_REPORT]-() with pr match (pr)...
neo4j version 3.5.1, running on linux centos 7calling from chrome browser
I have a db with about 730000000 nodes. I need to delete some orphaned node trees. I've written a query to locate the top of the tree, this returns about 5500000 nodes, and del...
I have this query. This query is going through a little more of a 1000000 nodes. It takes over 7 minutes to return and I'm trying to understand why.
First I'll start with the following query:
where not (ap)-[:RELATED_TO]->(p...
OK. After some investigating I found what is causing this problem.
The configuration line:
Once i removed it everything seems to be in order.
Hope this helps others
So. I now know what is going on.
I looked in the journalctl log on the linux box. It turns out that the OS determined it does not have enough memory and than killed the java process. Immediately after it restarted it, so this is why I see a restart.
cant upgrade need to do a lot of work on query parameters first.
There has been a development. My initial assessment of the problem is wrong. The restart has nothing to do with the query. I've left the machine on and without anything happening, no qu...
Actually if I were to try this query without 'apoc', the query window shows a warning that it does not have the misspelled relationship in the db. So if this window was able to analyze 'apoc' queries it would have shown me the problem straight away.