Re: semget: No space left on device

From: Keary Suska <hierophant(at)pcisys(dot)net>
To: PostgreSQL-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: semget: No space left on device
Date: 2003-05-10 05:31:48
Message-ID: BAE1EAE3.1CA08%hierophant@pcisys.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

on 5/9/03 9:25 PM, tgl(at)sss(dot)pgh(dot)pa(dot)us purportedly said:

> You evidently need to raise SEMMNI: your setup is eating 127 of the 128
> you have allowed.
>
> It does seem odd that you have
>
> ------ Semaphore Status --------
> used arrays = 127
> allocated semaphores = 159
>
> Postgres will normally allocate 17 semaphores per semaphore ID (a/k/a
> semaphore array). It looks to me like some not-Postgres application has
> chewed up 125 semaphore IDs to represent only one actual semaphore apiece.
> Postgres took two more for 17 apiece, then choked trying to get a third.
>
> What else are you running ... and have you complained to them about
> their profligacy with semaphore IDs?

D'oh! I missed that. It's Apache--naughty, naughty. May have a problem
cleaning up after itself, as it certainly doesn't need 125 arrays with only
one semaphore each!

I'll have to get them on that one...

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ian Barwick 2003-05-10 09:50:29 Re: Unicode confusion
Previous Message Tom Lane 2003-05-10 03:25:01 Re: semget: No space left on device