Re: strange hung processes

Ben Kim wrote:
>> We're running 7.4.9 and have run into something strange.
>> A group of processes seem to have hung and cannot be killed.  netstat
>> showed that there were no active TCP connections at the time.
>> Sending SIGTERM to the parent process caused PG to begin its
>> shutdown, but it never finished.  We then kill -9 the postmaster,
>> which caused it to die, but these child procs remain, even after a
>> clean restart.  Our next step is to reboot the box, but before we
>> do, I'm just curious anyone else has seen this,  why this happened,
>> and if anyone know ways to prevent this from happening again.....
>
> If it's not sensitive information, what does this show?
>
>     lsof | grep 'pid of hung process'
>
from the save-a-process committee:

lsof -p 'pid of hung process'

will give the same info :)

LER
--
Larry Rosenman
Database Support Engineer

PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX  78727-6531

Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com