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
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
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).