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	318	November 24, 2020
Apoc.periodic.iterate only writing one batch with parallel Procedures & APOC	4	724	July 29, 2020
Is there a syntax error for this apoc query? Neo4j Graph Platform	5	650	May 24, 2021
Parallel Cypher & Apoc Cypher apoc , cypher	8	3913	June 19, 2019
How to return number of deleted nodes when using apoc.periodic.iterate? Newbie Questions cypher	4	682	July 30, 2020

Parallel deletes with apoc.periodic.iterate

Related Topics