Re: 7.4 - TODO : IpcSemaphoreCreate: No space left on - Mailing list pgsql-hackers

From Neil Conway
Subject Re: 7.4 - TODO : IpcSemaphoreCreate: No space left on
Date
Msg-id 1039106613.363.31.camel@tokyo
Whole thread Raw
In response to 7.4 - TODO : IpcSemaphoreCreate: No space left on device  ("Dan Langille" <dan@langille.org>)
List pgsql-hackers
On Thu, 2002-12-05 at 10:13, Dan Langille wrote:
> This error is accompanied by a suggestion to change SEMMNI or SEMMNS. 
>  In this case, that suggestion is not appropriate.  Read below for 
> the scenario.

> Suggestion: Can we modify the error message to include checking for a 
> running postmaster?

What basically happened is that you were running two copies of the
postmaster at the same time, so you needed enough shared memory +
semaphores for both of them. There's no fundamental difference between
using up all your shared memory with other postmasters, or with other
applications that use shm/semaphores. In either case, the postmaster's
error message is still valid:
   It occurs when either the system limit for the maximum number of   semaphore sets (SEMMNI), or the system wide
maximumnumber of   semaphores (SEMMNS), would be exceeded.  You need to raise the   respective kernel parameter.
 

... although it perhaps doesn't tell the entire truth. Would it be
sufficient to add a note to the documentation about the possibility of
other applications using shared memory / semaphores?

Cheers,

Neil
-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC





pgsql-hackers by date:

Previous
From: "Dan Langille"
Date:
Subject: Re: 7.4 - TODO : alter table drop foreign key
Next
From: Stephan Szabo
Date:
Subject: Re: 7.4 - TODO : alter table drop foreign key