Re: [HACKERS] Postmaster dies with many child processes (spinlock/semget failed) - Mailing list pgsql-hackers

Patrick Verdon wrote:
> 
> Check Apache's error_log and you will see error
> messages and eventually the postmaster will die
> with something like:
> 
>    FATAL: s_lock(28001065) at spin.c:125, stuck spinlock. Aborting.

Try to increase S_MAX_BUSY in src/backend/storage/buffer/s_lock.c:

#define S_MAX_BUSY      500 * S_NSPINCYCLE                       ^^^
try with 10000.

Vadim