278.0 MiB. Currently using 278.0 MiB. dbms.memory.transaction.global_max_size threshold reached

Neo4j Graph Platform Cypher
,
1

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!

2

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 -

3

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.