暂无图片
greenplum提示could not fork new process for connection: Cannot allocate memory
我来答
分享
잘생긴 오빠😎
2023-07-27
greenplum提示could not fork new process for connection: Cannot allocate memory

gp版本:6.21.2

报错内容:"LOG","00000","could not fork new process for connection: Cannot allocate memory",,,,,,,0,,"postmaster.c",4532,

问题描述:持续不到2分钟造成节点宕机。

根据监控系统最低剩余60GB可用内存,应该是GP后台进程占用内存超过参数限制导致,应该调整哪些参数比较合适?


每个数据节点物理内存250GB,6个primary segment,6个mirror segment。下面是相关参数。

Values on all segments are consistent
GUC : gp_vmem_protect_limit
Master value: 39100
Segment value: 39100


Values on all segments are consistent
GUC : max_statement_mem
Master value: 2GB
Segment value: 2GB


Values on all segments are consistent

GUC : shared_buffers

Master value: 8GB

Segment value: 8GB


Values on all segments are consistent
GUC : statement_mem
Master value: 256MB
Segment value: 256MB


Values on all segments are consistent
GUC : gp_resource_manager
Master value: queue
Segment value: queue


Values on all segments are consistent
GUC : max_resource_queues
Master value: 9
Segment value: 9


Values on all segments are consistent
GUC : gp_enable_global_deadlock_detector
Master value: on
Segment value: off


Values on all segments are consistent
GUC : work_mem
Master value: 32MB
Segment value: 32MB


Values on all segments are consistent
GUC : max_connections
Master value: 800
Segment value: 2000

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
test

60GB指的是free?还是free + available?


暂无图片 评论
暂无图片 有用 0
잘생긴 오빠😎
题主
2023-07-31
available
test
答主
2023-07-31
主节点的available还有多少
test
答主
2023-07-31
如果master 内存充足(如果可以,也可以调整为16G) 数据节点: shared_buffers 16G statement_mem 512MB 可以再观察下
展开全部评论(5条)
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏