Hi,
I am facing issue as mentioned below while running load csv data
USING PERIODIC COMMIT 800 LOAD CSV WITH HEADERS FROM file://user.csv"
below is the cypher queries:
USING PERIODIC COMMIT 800 LOAD CSV WITH HEADERS FROM "file:///CSVFiles/Users.csv" AS row FIELDTERMINATOR "^" MERGE(u:User{Badge: row.Badge}) SET u.Badge = row.Badge, u.DisplayName = row.DisplayName, u.Email = row.Email, u.IsActive = row.IsActive ; Match (u:User) where u.IsActive = "True" set u.IsActive = true; Match (u:User) where u.IsActive = "False" set u.IsActive = false; USING PERIODIC COMMIT 800 LOAD CSV WITH HEADERS FROM "file:///CSVFiles/Users.csv" AS row FIELDTERMINATOR "^" MATCH (e:Supp {Id: row.Id}) MATCH (u:User) where toLower(u.Badge) = toLower(row.Badge) MERGE (u)-[:IS_REVIEWER_USER]->(e)
Exception Message: LockClient[157844] can't wait on resource RWLock[NODE(530), hash=260086671] since => LockClient[157844] <-[:HELD_BY]- RWLock[NODE(10169), hash=1785446810] <-[:WAITING_FOR]- LockClient[157848] <-[:HELD_BY]- RWLock[NODE(1935), hash=2142640811] <-[:WAITING_FOR]- LockClient[157850] <-[:HELD_BY]- RWLock[NODE(6383), hash=694887370] <-[:WAITING_FOR]- LockClient[157851] <-[:HELD_BY]- RWLock[NODE(530), hash=260086671]
I have tried USING PERIODIC COMMIT 800 LOAD CSV WITH HEADERS (1000 to 800). and total records are 1 lakh.]Neo4 3.4.5