Skip site navigation (1) Skip section navigation (2)

BUG #1632: Several jailed PostgreSQL instances.

From: "Alexander Rusinov" <boot(at)eurocom(dot)od(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1632: Several jailed PostgreSQL instances.
Date: 2005-04-27 07:15:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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.

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


pgsql-bugs by date

Next:From: boykov@nsDate: 2005-04-27 07:29:16
Subject: msi installer on W2K server: error while install
Previous:From: Marc SoledaDate: 2005-04-27 07:03:34
Subject: BUG #1631: pg_autovacuum fails when creating as a windows service

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group