Running Deletes on parallel apoc.periodic.iterate calls results in a high number of java.lang.NullPointerException errors. E.g., CALL apoc.periodic.iterate( "MATCH (n { foo: 'bar' }) RETURN n", "DETACH DELETE n", { batchSize: 1000, parallel: true, concurrency: 50, retries: 3 } ) returns { …

Relationships cannot be dropped in parallel because a relationships inherently relies on having a start and end node attached to it by definition and to do a delete on that relationship it locks onto both those nodes. If another relationship is being deleted on another thread simultaneously it canno…

Parallel deletes with apoc.periodic.iterate

Neo4j Graph Platform Procedures & APOC

benjamin.squire (Benjamin Squire) April 2, 2019, 7:26pm 2

These were my attempts. No perfect solution yet but MH has some ideas.

1 Like

Topic		Replies	Views
Cypher Query using apoc.do.when inside apoc.periodic.iterate does not work as intended? Cypher	1	329	November 24, 2020
Apoc.periodic.iterate only writing one batch with parallel Procedures & APOC	4	739	July 29, 2020
Is there a syntax error for this apoc query? Neo4j Graph Platform	5	664	May 24, 2021
Apoc.periodic.iterate() parallelization not working with Python driver Drivers & Stacks apoc , performance , browser , neo4j-python-driver	0	28	November 4, 2024
Parallel Cypher & Apoc Cypher apoc , cypher	8	3921	June 19, 2019

Parallel deletes with apoc.periodic.iterate

Related topics