pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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