Neo4J load error: Neo.TransientError.General.OutOfMemoryError

Question

While loading the data from a CSV file to the Neo4J database, I am getting the following error:

Neo.TransientError.General.OutOfMemoryError

There is not enough memory to perform the current task. Please try increasing 'dbms.memory.heap.max_size' in the neo4j configuration (normally in 'conf/neo4j.conf' or, if you are using Neo4j Desktop, found through the user interface) or if you are running an embedded installation increase the heap by using '-Xmx' command line flag, and then restart the database.

I do not see any neo4j.conf file. How can I fix this error?

Answer 1

You can change the value of dbms.memory.heap.max_size in the settings page of the active database.

Here are steps to edit the value of dbms.memory.heap.max_size of the active database:

• On the Neo4J desktop, you will find the three dots (...) in the top right corner. Click on that. It will show you a small pop-up window. In that window, click on the settings. It will open the "Edit settings" page.

• In the "Edit settings" page, scroll down to find the variable dbms.memory.heap.max_size. The default value is 1G. Set it to a bigger value depending on the RAM on your computer. 
• Click on the "Apply" button and restart the database.

If the new value of dbms.memory.heap.max_size is sufficient for your data, Neo4J will not throw the error.