Date: Tue, 26 Apr 2005 11:09:23 -0400 From: Bill Moran <wmoran@potentialtech.com> To: Alexander Rusinov <boot@eurocom.od.ua> Cc: freebsd-stable@freebsd.org Subject: Re: PostgreSQL in FreeBSD jails Message-ID: <20050426110923.3edf8a2e.wmoran@potentialtech.com> In-Reply-To: <426E5713.3010906@eurocom.od.ua> References: <426E5713.3010906@eurocom.od.ua>
next in thread | previous in thread | raw e-mail | index | archive | help
Alexander Rusinov <boot@eurocom.od.ua> wrote: > Hi, > > I need to run a number of PostgreSQL servers in different FreeBSD jails. > I managed to run a first instance of PostgreSQL server in a jail, but > after I launch a new server in another jail the first one starts to > return an error messages like the following: > > semctl(1507328, 4, SETVAL, 0) failed: Invalid argument > > The problem in general is: only one instance of PostgreSQL server > processes clients' connections, all of the others return semctl errors. I had this exact same problem. I never found a solution. The cause appears to be that, since shared memory is not segregated between jails, the newly launched Postgres instances corrupt the shared memory of previously running Postgres instances. Supposedly, this shouldn't be possible, but it was happening and I never found a solution. > > The system is FreeBSD 5.4-PRERELEASE. PostgreSQL-7.4.7. SEM and SHM > sysctl setting are: > > # sysctl -a | grep shm > 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 > > # sysctl -a | grep sem > 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 > > Trying to solve the problem I've set the following in postgresql.conf > files: > max_connections = 5 > shared_buffers = 100 > > Please help! What am I doing wrong? > > -- > Alexander Rusinov > > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" -- Bill Moran Potential Technologies http://www.potentialtech.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050426110923.3edf8a2e.wmoran>