Re: hung process
This also occasionally happens on AIX (3.2.5 and 4.2, Informix 5.0n) when
client process dies due to HANGUP (closing GUI window, swuitchint the
terminal off) or INT signal (good, old ctrl-C). It seems that clien
packages don't close the connection to the server down in routines handling
these interrupts.
I would appreciate an advice concerning this (apart that is appears to be
safe to kill those processes).
--
Dragi Raos
4-MATE Information Engineering (http://www.4mate.hr)
Zagreb, Croatia
Jeff Craig <settler@emory.mathcs.emory.edu> wrote in article
<5lg4nd$gid@cssun.mathcs.emory.edu>...
> }>From ilist@rmy.emory.edu Thu May 15 15:34:22 1997
> }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP
(950413.SGI.8.6.12/930416.SGI.AUTO)
> }> for <settler@dbintellect.com> id PAA21656; Thu, 15 May 1997 15:32:50
-0600
> }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id
PAA01059 for informix-list-out; Thu, 15 May 1997 15:15:01 -0400 (EDT)
> }>Message-ID: <01BC6148.54524A70@host.200.32.113.33.impsat.net>
> }>From: Oscar Goldes <ogolde@impsat1.com.ar>
> }>To: "informix-list@rmy.emory.edu" <informix-list@rmy.emory.edu>
> }>Subject: hung process
> }>Date: Thu, 15 May 1997 15:54:47 -0000
> }>MIME-Version: 1.0
> }>Content-Type: text/plain; charset="us-ascii"
> }>Content-Transfer-Encoding: 7bit
> }>Sender: informix-list-owner@rmy.emory.edu
> }>Reply-To: Oscar Goldes <ogolde@impsat1.com.ar>
> }>X-Informix-List-Id: <list.14525>
> }>
> }>Hello,
> }>I am using informix online 7.2 over SCO Unix.
> }>I frequently notice that there are a lot of hung process.
> }>Specifically, I saw that two process were eating up nearly 100 % cpu
time (a pentium biprocessor) as seen with vmstat or cpusar.
> }>Both of them had huge ammounts of cpu time as by ps.
> }>The two processes turned out to be dbaccess sessions, which had 1 as
parent process, but did not belong to root, just to normal users.
> }>They could be seen from onstat also.
> }>Killing them solved the cpu usage problem. However, such process tend
to appear frequently.
> }>Any suggestions?
> }>
> }>TIA
> }>
> }>Oscar Goldes
> }>
> We see this too on Silicon Graphics IRIX with Informix 7.2. It happens
> when a user is using an MS Windows-based telnet session, runs dbaccess
> to access the database, then closes the window without exiting dbaccess.
> The "orphaned" processes runaway. We run a script to kill dbaccess
> sessions that have a parent process ID of 1 and high CPU, but it's not
> a perfect solution.
>
> -------------------------------------------------------------------
> Jeff Craig | dbINTELLECT Technologies, Inc.
> Senior Consultant | Golden, CO
> | (303) 275-6954 ext. 8008
> | email: settler@dbintellect.com
> | fax: (303) 275-2134
> -------------------------------------------------------------------
>