On Thu, 28 Jan 1999, Patrick Verdon wrote:
> IpcSemaphoreCreate: semget failed (No space left on device) key=5432017, num=16, permission=600
> NOTICE: Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory.
> I have rolled back the current transaction and am going to terminate your database system connection and
exit.
> Please reconnect to the database system and repeat your query.
>
> FATAL: s_lock(28001065) at spin.c:125, stuck spinlock. Aborting.
>
> Note that the 'no space left on device' is
> misleading as there is a minimum of 400 MB
> available on each file-system on the server.
My first guess is that you don't have enough semaphores enabled in your
kernel...increase that from the default, and I'm *guessing* that you'll
get past your 48...
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
