Re: Lock problem on Solaris - Mailing list pgsql-general

From Travis Bauer
Subject Re: Lock problem on Solaris
Date
Msg-id Pine.GSO.4.21.0010091544550.5137-100000@ghost.cs.indiana.edu
Whole thread Raw
In response to Re: Lock problem on Solaris  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,

Thanks.  Running ipcclean fixed it right away.

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Mon, 9 Oct 2000, Tom Lane wrote:

> Travis Bauer <trbauer@cs.indiana.edu> writes:
> > When I start postmaster, I get the following:
> > IpcSemaphoreCreate: semget failed (No space left on device) key = ...
>
> > However, it normall works fine with the setting, and a nasty
> > crash killed it this morning.  I think that for some reason, some
> > semaphores are still being held.
>
> Sounds likely.  The standard utility programs ipcs and ipcrm will help you
> clean up --- see their man pages.  (You probably will need to zap the
> old shared-memory segments as well as the old semaphores; these tools
> will handle both tasks.)
>
> Our distribution includes a shell script "ipcclean" that purports to
> do this for you, but I wouldn't trust it too far, since the output
> format of ipcs is somewhat platform-specific.
>
>             regards, tom lane
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lock problem on Solaris
Next
From: Robert Boyd
Date:
Subject: persistent db connections/resiliency