pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Larry Rosenman <lrosenman@pervasive.com>
To: Ben Kim <bkim@coe.tamu.edu>
To: Jeremy Ashcraft <jashcraft@edgate.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: strange hung processes
Date: Thu, 2 Feb 2006 13:39:54 -0600
Message-ID: <D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com> (raw)

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 



view thread (6+ messages)  latest in thread

Message-ID: <D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com>
Permalink:  ../D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com/
Also on:    postgresql.org/message-id/D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: lrosenman@pervasive.com, bkim@coe.tamu.edu, jashcraft@edgate.com
  Subject: Re: strange hung processes
  In-Reply-To: <D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com>
  References: <D1D2D51E3BE3FC4E98598248901F75940328DAFF@ausmail2k4.aus.pervasive.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox