Hello -
I am using postgresql 12 on OpenBSD 6.8. After a while of running,
postgresql starts throwing out errors:
2020-12-03 08:18:35.052 CST [60288] ERROR: could not open shared memory
segment "/PostgreSQL.1780529043": No such file or directory
2020-12-03 08:18:35.052 CST [40083] ERROR: could not open shared memory
segment "/PostgreSQL.1780529043": No such file or directory
2020-12-03 08:18:35.052 CST [53517] ERROR: could not open shared memory
segment "/PostgreSQL.1780529043": No such file or directory
2020-12-03 08:18:35.052 CST [53517] CONTEXT: parallel worker
2020-12-03 08:18:35.054 CST [47581] LOG: background worker "parallel
worker" (PID 40083) exited with exit code 1
2020-12-03 08:18:35.055 CST [47581] LOG: background worker "parallel
worker" (PID 60288) exited with exit code 1
2020-12-03 08:24:19.583 CST [53517] WARNING: could not remove shared
memory segment "/PostgreSQL.1222503421": No such file or directory
2020-12-03 08:24:19.584 CST [31517] WARNING: could not remove shared
memory segment "/PostgreSQL.19516083": No such file or directory
2020-12-03 08:24:19.584 CST [53517] WARNING: could not remove shared
memory segment "/PostgreSQL.1780529043": No such file or directory
in postgresql.conf, dynamic_shared_memory_type is set to posix.
/etc/sysctl.conf
kern.seminfo.semmni=256
kern.seminfo.semmns=2048
I am wondering there is something I need to adjust... or if anyone has
run into this before? Does anyone have any pointers on what to look for?
Thanks
- David
