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
>
>
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 |