Re: hung process
}>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
-------------------------------------------------------------------