Re: 100% CPU pg processes that don't die. - Mailing list pgsql-general

From Scott Marlowe
Subject Re: 100% CPU pg processes that don't die.
Date
Msg-id dcc563d10808091354l725f2a6epd57be44ac95d1175@mail.gmail.com
Whole thread Raw
In response to Re: 100% CPU pg processes that don't die.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 100% CPU pg processes that don't die.
List pgsql-general
On Sat, Aug 9, 2008 at 2:51 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Scott Marlowe" <scott.marlowe@gmail.com> writes:
>> I'm load testing a machine, and i'm seeing idle in transaction
>> processes that are no longer hooked to any outside client, that pull
>> 100% CPU and can't be kill -9ed.
>
> To my knowledge, the only way a process can't be kill -9'd is if it's
> stuck inside the kernel (typically, doing I/O to a nonresponsive disk).
> There's certainly no way for a userland process to defend itself against
> kill -9.  So my immediate response would have been to look for a
> hardware problem, or failing that a kernel bug.  I see from the
> subsequent thread that indeed hardware failure looks to be the answer,
> but that should have been your first assumption.

It was before this. That's why I'd swapped the RAID cards.  It's just
that this is the first time this has happened without killing the box,
so I wanted to be sure it didn't look like something else to anybody.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 100% CPU pg processes that don't die.
Next
From: rafal@zorro.isa-geek.com
Date:
Subject: foreign key restrictions