The following bug has been logged online:
Bug reference: 1632
Logged by: Alexander Rusinov
Email address: boot@eurocom.od.ua
PostgreSQL version: 7.4.7
Operating system: FreeBSD 5.4-PRERELEASE i386
Description: Several jailed PostgreSQL instances.
Details:
Only one instance of jailed PostgreSQL server is operating properly (the one
which was started last). All of the others servers refuse to process
connections. The error messages are as follows:
Apr 26 10:16:10 www postgres[9063]: [2-1] FATAL: semctl(65536, 4, SETVAL,
0) failed: Invalid argument
Apr 26 12:03:08 www postgres[15714]: [2-1] FATAL: semctl(1310720, 3,
SETVAL, 0) failed: Invalid argument
Apr 26 16:08:45 www postgres[27982]: [2-1] FATAL: semctl(1638400, 5,
SETVAL, 0) failed: Invalid argument
PostgreSQL servers were installed from FreeBSD ports collection and they are
running in different FreeBSD jails. It's enough to run two servers (two
jails) to reproduce the problem.
Related kernel settings are:
security.jail.sysvipc_allowed: 1
kern.ipc.shmmax: 100000000
kern.ipc.shmmin: 1
kern.ipc.shmmni: 192
kern.ipc.shmseg: 128
kern.ipc.shmall: 32768
kern.ipc.shm_use_phys: 0
kern.ipc.shm_allow_removed: 0
kern.ipc.semmap: 256
kern.ipc.semmni: 256
kern.ipc.semmns: 512
kern.ipc.semmnu: 256
kern.ipc.semmsl: 60
kern.ipc.semopm: 100
kern.ipc.semume: 10
kern.ipc.semusz: 92
kern.ipc.semvmx: 32767
kern.ipc.semaem: 16384
PostgreSQL servers are configured for 5 connections:
max_connections = 5
shared_buffers = 100