Kingbase在初始化时遇到的错误

时间:2021-01-26 11:56:40

FATAL: could not create semaphores: No space left on device
DETAIL: Failed  system call was semget(5831001, 17, 03600).
HINT: This error does *not* mean  that you have run out of disk space.
It occurs when either the system limit  for the maximum number of semaphore sets (SEMMNI), or the system wide maximum  number of semaphores (SEMMNS), would be exceeded. You need to raise the  respective kernel parameter. Alternatively, reduce PostgreSQL's consumption of  semaphores by reducing its max_connections parameter (currently 23).

根据报错信息,和硬件环境,判定是系统参数中kernel.sem 值不够导致的,解决方式是提高信号量或者重启服务器释放信号量。

vi /etc/sysctl.conf

kernel.sem = 250 320000 100 128+个0即可

sysctl -p生效

本文出自 “岁伏” 博客,请务必保留此出处http://suifu.blog.51cto.com/9167728/1625283