Re: BUG #1632: Several jailed PostgreSQL instances.

O Alexander Rusinov έγραψε στις Apr 27, 2005 :

>
> The following bug has been logged online:
>
> Bug reference: 1632
> Logged by: Alexander Rusinov
> Email address: boot(at)eurocom(dot)od(dot)ua
> PostgreSQL version: 7.4.7
> Operating system: FreeBSD 5.4-PRERELEASE i386
> Description: Several jailed PostgreSQL instances.
> Details:

Excuse me if i missed some episodes, but to the best of my knowledge,
FreeBSD IPC is not jailified.
There have been talks and talks on the matter on both lists,
and it seems
the only way to go is to start the jailed postgresql instances
to listen to different ports.

Tom and others, please correct me if situation now with FreeBSD 5.3+ has
changed.

>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

--
-Achilleus