import fails with error on "There is not enough memory to perform the current task."

[kuczera]

My settings:

dbms.memory.heap.initial_size=8G dbms.memory.heap.max_size=24G

Generating and linking claims (6) : 837.788ms Started linking :Quantity to :Item Linkied :Quantity to :Item : 15552434.502ms Started linking :GlobeCoordinate to :Item Structure { signature: 127, fields: [ { code: 'Neo.TransientError.General.OutOfMemoryError', message: 'There is not enough memory to perform the current task. Please ' + "try increasing 'dbms.memory.heap.max_size' in the neo4j " + "configuration (normally in 'conf/neo4j.conf' or, if you you " + 'are using Neo4j Desktop, found through the user interface) or ' + 'if you are running an embedded installation increase the heap ' + "by using '-Xmx' command line flag, and then restart the " + 'database.' } ] } exiting in 5 sec

[legraphista]

This is strange. Can you try to run this query manually?

MATCH (q:GlobeCoordinate)
     WHERE q.globe STARTS WITH 'http'
WITH
     q,
     TRIM(SPLIT(q.globe,'/')[-1]) AS itemId
MATCH (e:Entity) WHERE e.id = itemId
MERGE (q)-[:GLOBE_TYPE]->(e)
REMOVE q.globe

if this fails too, could you try to insert a LIMIT 1000 (or another value) between WITH and the second MATCH and run it until there are no more changes committed to the db.

[kuczera]

Without limit the following error comes up: There is not enough memory to perform the current task. Please try increasing 'dbms.memory.heap.max_size' in the neo4j configuration (normally in 'conf/neo4j.conf' or, if you you are using Neo4j Desktop, found through the user interface) or if you are running an embedded installation increase the heap by using '-Xmx' command line flag, and then restart the database.

[kuczera]

Running this Query for several times works: MATCH (q:GlobeCoordinate) WHERE q.globe STARTS WITH 'http' WITH q, TRIM(SPLIT(q.globe,'/')[-1]) AS itemId LIMIT 10000000 MATCH (e:Entity) WHERE e.id = itemId MERGE (q)-[:GLOBE_TYPE]->(e) REMOVE q.globe;

I hope this helps to improve the code or do i have to do it manually every time ?

[kuczera]

sorry for closing ;-)