Increase Transaction timeout in Neo4j Sandbox (Neo4j Browser version: 4.2.1)

Question

I'm trying to Load a CSV file with 50,000 rows into Neo4j Browser (sandbox) and the transaction keeps timing out. I understand that I need to increase the timeout time, but don't know how to do it.

Here is the error I receive;

Neo.ClientError.Transaction.TransactionTimedOut

The transaction has been terminated. Retry your operation in a new transaction, and you should see a successful result. The transaction has not completed within the specified timeout (dbms.transaction.timeout). You may want to retry with a longer timeout.

Just to reiterate, I'm not using the Neo4j Desktop or Community so I don't have access to any config files. Please advice!

user_7371893 · Answer

Use a periodic commit and it will release the transaction every 5000 records processed. See here: https://neo4j.com/docs/cypher-manual/current/clauses/load-csv/#load-csv-importing-large-amounts-of-data

USING PERIODIC COMMIT 5000 LOAD CSV FROM 'file:///artists.csv' AS line
CREATE (:Artist {name: line[1], year: toInteger(line[2])})

Increase Transaction timeout in Neo4j Sandbox (Neo4j Browser version: 4.2.1)

1 Answers