Search code examples
amazon-web-servicesamazon-s3requestamazon-neptuneopencypher

"detailedMessage":"Operation failed due to conflicting concurrent operations (please retry), 0 transactions are currently rolling back


The Load operation on Neptune failed due to the deletion of files from s3 in between the s3 to Neptune load. Since then I am able to delete all the relationships that are present between nodes through opencypher query but unable to delete nodes.

gets error {"detailedMessage":"Operation failed due to conflicting concurrent operations (please retry), 0 transactions are currently rolling back.","code":"ConcurrentModificationException" even after retrying many times.

The query used for deleting all nodes is query=MATCH (n) OPTIONAL MATCH (n)-[r]-() DELETE n,r


Solution

  • This issue is resolved adding limit to the query "MATCH (n) WITH n LIMIT 100000 DETACH DELETE n" . Running this query in recursive solves the problem.