pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marc G. Fournier <scrappy@postgresql.org>
To: Marc G. Fournier <scrappy@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: semctl(): Invalid argument
Date: Sun, 2 Apr 2006 16:34:48 -0300 (ADT)
Message-ID: <20060402163341.P947@ganymede.hub.org> (raw)
In-Reply-To: <20060402143109.T947@ganymede.hub.org>
References: <20060402143109.T947@ganymede.hub.org>


It looks like moving to FreeBSD 6.x for some of our servers is biting me 
in the butt ... they "broke" something with semaphores that used to work 
with 4.x, so that you can't run two postmasters on port 5432 within two 
seperate jails ... :(

On Sun, 2 Apr 2006, Marc G. Fournier wrote:

>
> What would cause the following?
>
> # psql -U pgsql -l
> psql: FATAL:  semctl(327686, 3, SETVAL, 0) failed: Invalid argument
>
> The server is FreeBSD 6.1-PRERELEASE ... there are two jails running on it 
> ... both jails are running PostgreSQL 7.4 ... I have the kernel built with 
> enough semaphores:
>
> options         SYSVSHM
> options         SHMMAXPGS=199608
> options         SHMMAX=(SHMMAXPGS*PAGE_SIZE+1)
>
> options         SYSVSEM
> options         SEMMNI=4096
> options         SEMMNS=8192
>
> options         SYSVMSG                 # SYSV-style message queues
>
> And am definitely not using that many:
>
> (from ipcs -a):
>           ID          KEY MODE        OWNER    GROUP    CREATOR  CGROUP 
> NSEMS OTIME    CTIME s       393216      5432001 --rw-------       70 
> 70       70       70           17 13:46:07 13:46:07
> s       393217      5432002 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
> s       393218      5432003 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
> s       393219      5432004 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
> s       393220      5432005 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
> s       393221      5432006 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
> s       393222      5432007 --rw-------       70       70       70       70 
> 17 13:46:07 13:46:07
>
> So figure there must be something else that I should be looking at ...
>
> Thanks ...
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664



view thread (3+ messages)  latest in thread

Message-ID: <20060402163341.P947@ganymede.hub.org>
Permalink:  ../20060402163341.P947@ganymede.hub.org/
Also on:    postgresql.org/message-id/20060402163341.P947@ganymede.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: scrappy@postgresql.org
  Subject: Re: semctl(): Invalid argument
  In-Reply-To: <20060402163341.P947@ganymede.hub.org>
  References: <20060402143109.T947@ganymede.hub.org> <20060402163341.P947@ganymede.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox