Re: shmctl EIDRM preventing startup - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: shmctl EIDRM preventing startup
Date
Msg-id 20070702110535.GC12254@svana.org
Whole thread Raw
In response to Re: shmctl EIDRM preventing startup  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: shmctl EIDRM preventing startup  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
On Sun, Jul 01, 2007 at 10:39:01PM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Maybe what is happening is that an entirely unrelated process created a
> > segment with that ID, attached to it, and then it was deleted.  I don't
> > know how to check however.
>
> AFAIK, EIDRM should imply that the segment has been IPC_RMID'd but still
> exists because there are still processes attached to it.  So the thing
> to look for is processes still attached.  Not 100% sure how to do that,
> but I'm sure the info is exposed under /proc somehow...

If it's installed, this:

lsof |grep SYSV

Will list all processes attached to a SHM segemtn on the system. I
think ipcs can do the same. You can grep /proc/*/maps for the same
info.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: table disk space usage query?
Next
From: cha
Date:
Subject: importing limited set of rows/tuples