When trying to query from gpdb cluster. getting Out of memory error with error code 53400.
System Related information
TOTAL RAM =30G
SWAP =15G
gp_vmem_protect_limit=8192MB
TOTAL segment = 8 Primary, 8 mirror = 16
SEGMENT HOST=2
Getting error :
ERROR: Out of memory (seg2 slice109 datanode01:40002 pid=21691)
SQL state: 53400
Detail: VM protect failed to allocate 8388608 bytes from system, VM Protect 4161 MB available
We tried
gpconfig -c gp_vmem_protect_limit -v 4114 vm.overcommit_ratio = 95
Then, getting this error. P ERROR: XX000: Canceling query because of high VMEM usage. Used: 3704MB, available 410MB, red zone: 3702MB
Also , getting this symptom
Prod=# show runaway_detector_activation_percent;
runaway_detector_activation_percent
-------------------------------------
90
(1 row)
Please suggest what could be the setting in this case. Also, What is the root cause of OOM error?
Any help on it would be much appreciated?