Neo4j database is locked if transaction is not closed

Question

I get this problem for a long time. If the Neo4j transaction is not closed properly (either committed or rolled back) (this may occur due to an Exception, or die / exit in the middle of the transaction, etc.), then Neo4j does not release the lock.

To decide that I need to stop Neo4j and start Neo4j again. This is not required.

I check Server configurations . It has one config org.neo4j.server.transaction.timeout=60 , which says that the default value is 60 seconds. Therefore, if this option works for me by default, then after 60 seconds a timeout should occur.

How to check if the database is locked or not? How to easily or easily remove a database lock using code or configurations? I am using the latest version of Neo4j 2.2.3.

Answer 1

You need to double if the driver you are using works with the transactional endpoint of Cypher . Timeout applies only to this.

So, I suspect that you are using an old cypher endpoint that does not know about timeouts.