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"
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 |