Re: Immortal backend .... (kill -9 ?..)
От | Jeremy Buchmann |
---|---|
Тема | Re: Immortal backend .... (kill -9 ?..) |
Дата | |
Msg-id | 3CE3D62E.20409@wellsgaming.com обсуждение исходный текст |
Ответ на | Immortal backend .... (kill -9 ?..) ("Rajesh Kumar Mallah." <mallah@trade-india.com>(by way of Rajesh Kumar Mallah. <mallah@trade-india.com>)) |
Список | 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@trade-india.com>(by way of Rajesh Kumar Mallah. <mallah@trade-india.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 > >
В списке pgsql-admin по дате отправления: