Re: 100% CPU pg processes that don't die.

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 100% CPU pg processes that don't die.
Date: 2008-08-09 20:54:49
Message-ID: dcc563d10808091354l725f2a6epd57be44ac95d1175@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Aug 9, 2008 at 2:51 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rafal 2008-08-10 08:15:51 foreign key restrictions
Previous Message Tom Lane 2008-08-09 20:51:39 Re: 100% CPU pg processes that don't die.