Thread: Shared memory problem

Shared memory problem

From
Leandro Fanzone
Date:
Ok, thank you for your help with initdb. This week I was having this
problem from time to time, and I have to reboot Linux in order to fix
it. Any ideas?

010123.15:16:54.659  [3943] IpcMemoryCreate: shmget failed (Identifier
removed) key=5432010, size=144, permission=700
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
010123.15:16:54.671  [3943] IpcMemoryIdGet: shmget failed (Identifier
removed) key=5432010, size=144, permission=0
010123.15:16:54.672  [3943] IpcMemoryAttach: shmat failed (Invalid
argument) id=-2
010123.15:16:54.672  [3943] FATAL 1:  AttachSLockMemory: could not
attach segment

Leandro.


Re: Shared memory problem

From
Tom Lane
Date:
Leandro Fanzone <leandro@hasar.com> writes:
> 010123.15:16:54.659  [3943] IpcMemoryCreate: shmget failed (Identifier
> removed) key=5432010, size=144, permission=700

I think an "identifier removed" error means that the old postmaster
has shut down (and issued the ipcrm call against the old shared memory
segment) but the segment still exists because there's at least one
process still attached to it.  Check for not-yet-dead postmaster or
backend processes, and kill 'em.

            regards, tom lane