CODEWITHSUNDEEP
neo4jnodes
Yorch
Yorch

Reputation: 11

Neo4j unable to delete multiple nodes. I get a transaction failure exception

I am trying to remove around 40,000 nodes no longer needed via the webadmin console, but I am getting the following message:

neo4j-sh (0)$ start n=node:node_auto_index(tipo="not_needed")  DELETE n;
==> TransactionFailureException: Unable to commit transaction

Do anybody know if there is a way around this using the console?

Upvotes: 1

Views: 1050

Answers (1)

Eve Freeman
Eve Freeman

Reputation: 33185

This is probably because the nodes are connected still. You'll need to delete their relationships as well. Something like:

START n=node:node_auto_index(tipo="not_needed") 
MATCH n-[r?]-() 
DELETE n,r;

Upvotes: 5

Related Questions