I have many long term requests like:
MATCH (tx: Survey {uuid: {Id}}), (p: Person {personId: {personId}}),
MATCH (d: Day {day: {day}})
MATCH (rs: Result {ResultId: {resultId}, isActual: true})
CREATE (ex: SurveyResult)
CREATE (ex)-->(rs)
CREATE (ex)-[:comesFrom]->(tx)
CREATE (ex)-[:executedBy]->(p)
CREATE (ex)-[:savedOn]->(d) WITH ex UNWIND {answers} AS answer MATCH (a:Answer {uuid: answer}) CREATE (ex)-[:respondedWith]->(a)"
with status=waiting with deadlocks (CALL dbms.listQueries()) like:
resourceInformation
{
"waitTimeMillis": 10788,
"lockMode": "EXCLUSIVE",
"resourceType": "NODE",
"resourceIds": [
8199666
]
}
Requests take a long time, they don't want to end. I checked resourceIds and they are the identifiers of Result objects. These objects are involved in both getSurvey and saveSurveyResult requests. What's wrong?
I'm using neo4jDriver 1.7.91 that is compatible with neo4j 3.6.2