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
DeadlockDetectedException Procedures & APOC	8	1545	June 18, 2019
Delete query hangs until restart the server Python	2	760	November 18, 2020
What is the most efficient way to Delete 20 Million Nodes from a database with over 7.5 Billion Nodes and 15 Billion relationships? Cypher apoc , cypher , delete	27	9706	May 28, 2019
Neo4j strange hanging relationship delete Neo4j Graph Platform apoc , cypher , delete	2	340	March 18, 2022
Apoc.periodic.iterate only writing one batch with parallel Procedures & APOC	4	764	July 29, 2020

Parallel deletes with apoc.periodic.iterate

Related topics