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@xxxxxxxxxxxxx Web: www.pervasive.com
