I got a problem with a production database, it's a little
busy with 2 to 5 queries per second.
Running on Redhat 6.0, 2.2.5-15 SMP (intel)
Currently thre are 128 backends ( postmaster -N 128 )
with share mem set at 256.
in pg_options verbose = 2, syslog = 2,
here are the errors..
FATAL: s_lock(4001404d) at spin.c:125, stuck spinlock. Aborting.
After those spinlock errors the postmaster died.... I tries to start it
back up and it failed with this error.
FindExec: found "/usr/bin/postgres" using argv
IpcMemoryCreate: shmget failed (Identifier removed) key=5432010,
IpcMemoryIdGet: shmget failed (Identifier removed) key=5432010, size=120,
IpcMemoryAttach: shmat failed (Invalid argument) id=-2
FATAL 1: AttachSLockMemory: could not attach segment
Since this is a production database, what are teh first steps i should
jeff(at)pgsql(dot)com irc: bignose on EFnet
pgsql-hackers by date
|Next:||From: Ross J. Reedstrom||Date: 2000-01-27 18:55:44|
|Subject: Re: [HACKERS] Column ADDing issues|
|Previous:||From: Tom Lane||Date: 2000-01-27 18:33:16|
|Subject: Re: [SQL] DISTINCT ON: speak now or forever hold your peace |