Re: Restart after poweroutage

Tom Lane wrote:
> Jon Lapham <lapham(at)jandr(dot)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(at)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(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------