Neptune JupyterNotebook opencypher queries block when other queries running

Question

When I run some queries to insert nodes or insert relations with python codes in Neptune JupyterNotebook, I open a second notebook and then run some simple opencypher queries like
```
%%oc
MATCH (n)
WITH count(n) as NumberOfNodes
MATCH ()-[r]-()
RETURN NumberOfNodes, count(r) as NumberOfRelationships
```
It will block until all the insertion finished. Personally I find this really inconvenient.

Answer

Hello,

To run insert node, insert relation and other Cypher queries in parallel sessions we need to close or commit transactions after executing insert node or insert relation to release the locks and to avoid conflicts and data inconsistency as while inserting nodes, the transactions might be locking the database until they are committed. 
Please raise a support case if you are facing any error messages.

Thanks

Neptune JupyterNotebook opencypher queries block when other queries running

Relevant content