cancel
Showing results for 
Search instead for 
Did you mean: 

How to locate if any write locks are left in nodes from unfinished transactions in Neo4j?

Hello,

i am trying to import huge volumes of nodes and relationships in a Neo4j community edition database. I am trying to achive it through a Python client application and transactions. However while i was batch inserting relationships through long running transactions i experienced power failure and my computer terminated operation while a transaction creating relationships was executing. Does that mean that some nodes have write locks on them left from the unfinished transaction? Is there a way to check out all my nodes if they still have any write locks associated with them? How can i perform such a check? Through plain cypher code or through a library (e.g. APOC )? Thanks in advance for your time!

1 REPLY 1

You can use 

SHOW TRANSACTIONS [YIELD *] 
// to get maximum detail

// or previously the user defined procedure
CALL dbms.listTransactions()

see https://neo4j.com/docs/cypher-manual/current/clauses/transaction-clauses/