Kris Jurka <[EMAIL PROTECTED]> writes: > I have an underpowered server running 7.2.6 that backs a website which > occasionally gets hit by a bunch of traffic and starts firing off "FATAL > 1: Sorry, too many clients already" messages. This is all as expected, > but sometimes it just crashes. I had no clue what was going on until I > checked the stderr log (because I had set it up to use syslog). In there > I find a whole bunch of these:
> IpcSemaphoreLock: semop(id=-1) failed: Invalid argument [ eyeballs code... ] It looks like this could happen in 7.2 during exit from a backend that failed to acquire a semaphore --- ProcKill does things like LockReleaseAll, which needs to acquire the lockmanager LWLock, which could try to block using the process semaphore if there's contention for the LWLock. The problem should be gone in 7.3 and later due to reorganization of the semaphore management code. I'm not sure it's worth trying to fix in 7.2.* --- the odds of introducing new problems seem too high, and we're not really maintaining 7.2 anymore anyway. The comment in ProcGetNewSemIdAndNum suggests that you might be able to suppress the problem in 7.2 by using a different max_connections value. Is your current value one less than a multiple of 16, by any chance? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend