Re: strange hung processes - Mailing list pgsql-admin

From Tom Lane
Subject Re: strange hung processes
Date
Msg-id 22802.1138942040@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange hung processes  (Jeremy Ashcraft <jashcraft@edgate.com>)
List pgsql-admin
Jeremy Ashcraft <jashcraft@edgate.com> writes:
> in /proc

> codd 13262 # cat status     {proc "filesystem"}
> Name:   postmaster
> State:  D (disk sleep)

> Because of the "D" state, it can't be killed as it is not interuptible
> (waiting on IO ?).

If the process is stuck in D state then it's not Postgres' fault.
You're looking at a hardware problem, or if the database is mounted
via NFS then it might be an NFS-protocol-level problem.  In any case
you need to call out the kernel and hardware troops, not us database
weenies ...

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: is there any missing ??
Next
From: David Lutterkort
Date:
Subject: su-like behavior