+1 vote
in Databases by (71.8k points)

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?

1 Answer

+3 votes
by (1.2k points)
selected by
 
Best answer

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.
Neo4J edit settings for out of memory error
  • 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.

Related questions

+1 vote
1 answer
+1 vote
1 answer
asked Dec 16, 2022 in Databases by phpuser (59.4k points)
+1 vote
1 answer
+1 vote
1 answer

...