Sample Header Ad - 728x90

Greenplum ERROR: Canceling query because of high VMEM usage

0 votes
1 answer
4839 views
We have a GreenPlum Cluster which we have set up recently and getting this error on a single query run: current group id is 140611, group memory usage 40720 MB, group shared memory quota is 31320 MB, slot memory quota is 0 MB, global freechunks memory is 1044 MB, global safe memory threshold is 1048 MB (runaway_cleaner.c:197) SQL state: XX0 I'll be happy to post the settings we currently have in place that may help able to troubleshoot further. Here are some basic ones I can share: Cluster has got 128GB RAM on each node host SWAP on each Node is 32GB groupid | groupname | concurrency | cpu_rate_limit | memory_limit | memory_shared_quota | memory_spill_ratio | memory_auditor | cpuset 24964400 | my_user_group | 10 | 60 | 60 | 80 | 0 | vmtracker | -1
Asked by Matias (141 rep)
Jul 27, 2020, 10:33 AM
Last activity: Oct 21, 2021, 03:13 AM