Neptune JupyterNotebook opencypher queries block when other queries running

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.

Dave-AWS
6달 전
Can you clarify the question here, are you stating that you are running an insert in Notebook 1 and that is blocking all requests coming from Notebook 2?

주제

데이터베이스

태그

아마존 Neptune

언어

English

Chengzhi Mu

질문됨 6달 전205회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

지원 엔지니어

Dev_G

답변함 6달 전

Neptune JupyterNotebook opencypher queries block when other queries running

관련 콘텐츠