Re: Restart after poweroutage - Mailing list pgsql-general

Tom Lane wrote:
> Jon Lapham <lapham@jandr.org> writes:
>> Tom Lane wrote:
>>> It would seem that maybe your kernel has a different idea of what EIDRM
>>> means than we do.  You say this persists across a reboot?
>
>> I probably should have asked before doing this... but I just rebooted
>> and postgresql came up fine.  I hope I didn't screw up the forensics.
>
> Well, we have a clue now anyway: it's got something to do with the
> kernel unexpectedly returning EIDRM.
>
> Just for completeness, could we see the output of "ipcs -a" now?

[root@bilbo ~]# ipcs -a

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status

0x0052e2c1 32768      postgres  600        11083776   2

0x00000000 65537      root      777        172032     1

0x00000000 131074     lapham    600        393216     2          dest

0x00000000 163843     lapham    600        393216     2          dest

0x00000000 196612     lapham    600        393216     2          dest

0x00000000 229381     lapham    600        393216     2          dest

0x00000000 262150     lapham    600        393216     2          dest

0x00000000 294919     lapham    600        393216     2          dest

0x00000000 327688     lapham    600        393216     2          dest

0x00000000 360457     lapham    600        393216     2          dest

0x00000000 393226     lapham    600        393216     2          dest

0x00000000 425995     lapham    600        393216     2          dest

0x00000000 458764     lapham    600        393216     2          dest

0x00000000 491533     lapham    600        393216     2          dest

0x00000000 524302     lapham    600        393216     2          dest

0x00000000 557071     lapham    600        393216     2          dest

0x00000000 589840     lapham    600        393216     2          dest


------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x0052e2c1 0          postgres  600        17
0x0052e2c2 32769      postgres  600        17
0x0052e2c3 65538      postgres  600        17
0x0052e2c4 98307      postgres  600        17
0x0052e2c5 131076     postgres  600        17
0x0052e2c6 163845     postgres  600        17
0x0052e2c7 196614     postgres  600        17
0x00000000 294919     apache    600        1
0x00000000 262152     apache    600        1
0x00000000 327689     apache    600        1
0x00000000 360458     apache    600        1
0x00000000 393227     apache    600        1
0x00000000 425996     apache    600        1
0x00000000 458765     apache    600        1
0x00000000 491534     apache    600        1

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages


--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham  <lapham@jandr.org>                Rio de Janeiro, Brasil
  Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------