Kingbase在初始化时遇到的错误

最新推荐文章于 2024-12-13 12:16:18 发布

weixin_34232617

最新推荐文章于 2024-12-13 12:16:18 发布

阅读量418

点赞数

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/414673

本文介绍了一种常见的PostgreSQL错误“FATAL: could not create semaphores: No space left on device”的解决方法。该问题通常由系统信号量设置不足引起，通过调整内核参数kernel.sem或减少数据库连接数可以解决。

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生效

本文转自 dbapower 51CTO博客，原文链接：http://blog.51cto.com/suifu/1625283，如需转载请自行联系原作者