Due to OOM Out of memory: Kill process 3105 (java) score 935 or sacrifice child

CrateDB
1

Hi Team,

Recently we are facing
“due to OOM Out of memory: Kill process 3105 (java) score 935 or sacrifice child”.
In above the CrateDB process get killed and one node gets down.

We want to know that is there any way to find which query is executing at time where cratedb got OOM error.

we tried on SYS.JOBS and SYS.JOBS_LOG but not found any suspicious query.

Thanks
Vinayak Katkar

2

Hi,
I think you could start CrateDB with the -XX:+HeapDumpOnOutOfMemoryError option and then analyze the dump when this happens.
There is also a discussion at Issue #14938 about making this easier, you may want to review the article that is linked there and add feedback on your experience.