Neo4j

prishabh35 · ‎07-06-2021

Hello,

I am getting a below error while running a query.

#### Neo.TransientError.General.MemoryPoolOutOfMemoryError

The allocation of an extra 2.0 MiB would use more than the limit 278.0 MiB. Currently using 278.0 MiB. dbms.memory.transaction.global_max_size threshold reached

How can I avoid this error?

Thanks in Advance!

michael_hunger · ‎07-06-2021

Where do you get the error?
It means that the current statement would allocate more memory than permitted.

If you run large updates please batch them, e.g. from the client in chunks of 50k to 100k lists of parameters, with USING PERIODIC COMMIT for LOAD CSV or by using apoc.periodic.iterate

see: Best Practices to Make (Very) Large Updates in Neo4j -

View solution in original post

michael_hunger · ‎07-06-2021

Where do you get the error?
It means that the current statement would allocate more memory than permitted.

If you run large updates please batch them, e.g. from the client in chunks of 50k to 100k lists of parameters, with USING PERIODIC COMMIT for LOAD CSV or by using apoc.periodic.iterate

see: Best Practices to Make (Very) Large Updates in Neo4j -

prishabh35 · ‎07-13-2021

Thanks @michael.hunger . Luckily client had wrong request regarding the query. So, I did not use it but I will use this in the future. Thank you so much for the help.