Re: Immortal backend .... (kill -9 ?..)

From: Jeremy Buchmann <jeremy(at)wellsgaming(dot)com>
To: "Rajesh Kumar Mallah(dot)" <mallah(at)trade-india(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Immortal backend .... (kill -9 ?..)
Date: 2002-05-16 15:54:22
Message-ID: 3CE3D62E.20409@wellsgaming.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Rajesh Kumar Mallah. wrote:
> Hi,
>
> Two of the backends are showing status "D" which "man ps"
> describes as "uninterruptible sleep (usually IO)"
>
> since kill -9 does not get me rid of these should i expect
> postmaster which is still the parent process for those two
> spoilt kids to terminate them?

That does sound like a hardware-related problem. I saw the same thing
on a flaky Jaz drive. The only thing I could do was reboot, which got
rid of the offending processes. But that won't fix your hardware problem.

--Jeremy

> On Wednesday 15 May 2002 07:46 pm, Tom Lane wrote:
>
>>"Rajesh Kumar Mallah." <mallah(at)trade-india(dot)com>(by way of Rajesh Kumar Mallah. <mallah(at)trade-india(dot)com>) writes:
>>
>>>now even kill -9 <pid of backend> does not releases it below is
>>>the current status of backends:
>>
>>I think there is something broken about your system. It is not normal
>>to be in a state where you have unkillable processes. I'm wondering
>>about disk drive problems leading to I/O requests that never complete,
>>myself...
>>
>> regards, tom lane
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah. 2002-05-16 16:10:06 Help with data recovery...
Previous Message BELLIARD Francois - FT.BD/FTRD/DRHG/RSCL 2002-05-16 14:19:09 Re: problem in module Pg with Apache, Perl and SSL