Memory issue on repeat
I am traversing all nodes occuring in the same cluster given one of the nodes in that cluster.
Surprisingly, after a depth limit im getting memory issues as showing in the image:
Engine is Neptune 1.2.1.0
CPU: 2vCPU
RAM: 4GB
Once i monitor the ram usage (cloud watch) i found it unbothered with the query
Solution:Jump to solution
If using a t3.medium or t4g.medium instance, the amount of memory available for a query execution thread is very constrained. Memory allocation per thread increases as you go up in instance size until you get to the 4xlarge or 8xlarge sizes (at which point, memory allocation is at maximum per thread).
3 Replies
@spmallette
You don't say how large your graph is but it seems possible that a particular query path with that style of query could end in a memory issue for a smaller instance that only has 4gb of RAM. It might be interesting to see the cloud watch metrics for the times this query was executing, but i think it's possible that it may not tell the whole story. cc/ @triggan in case there's anything he feels he could add.
Solution
If using a t3.medium or t4g.medium instance, the amount of memory available for a query execution thread is very constrained. Memory allocation per thread increases as you go up in instance size until you get to the 4xlarge or 8xlarge sizes (at which point, memory allocation is at maximum per thread).