做GP压测的时候,当并发上去之后会一直报
could not fork new process for connection: Resource temporarily unavailable
(seg0 10.50.10.170:6000)
Client 13 aborted in state 2: ERROR: failed to acquire resources on one or more segments
DETAIL: could not fork new process for connection: Resource temporarily unavailable
官方建议修改‘ulimit -u’ 为131072。
-u 是用户最多可启动的进程数目。
该参数root用户是131072,gpadmin用户是1024.
可是/limits.conf里面是
* soft nproc 131072
/etc/security/limits.conf 配置文件可限制文件打开数,系统进程等资源,在该文件配置中写的最大用户进程数是受/etc/security/limits.d/90-nproc.conf配置上限影响的。