Re: [HACKERS] Postmaster dies with many child processes (spinlock/semget failed)

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Patrick Verdon <patrick(at)kan(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Postmaster dies with many child processes (spinlock/semget failed)
Date: 1999-01-29 03:06:24
Message-ID: 36B125AF.F286DE76@krs.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1999-01-29 06:17:54 Re: [HACKERS] TEMP table code
Previous Message The Hermit Hacker 1999-01-29 01:31:58 Re: [HACKERS] Postmaster dies with many child processes (spinlock/semget failed)