RE: Problems with orphaned processes

Posted in 2001

Parker, Jack — Thu, 1 Feb 2001 16:57:14 -0500 — source: Informix-list mailing list archive (1991-1998)

I actually did up a script many years ago that went out and looked for these connections and sent me mail. A cow-orker even did up a version which would investigate and kill them without bothering us. cheers j. > -----Original Message----- > From: Phillip [mailto:tienp@wholefoods.com] > Sent: Thursday, February 01, 2001 1:57 PM > To: informix-list@iiug.org > Subject: Re: Problems with orphaned processes > > > we sometimes have this problem and it has to do with users > not logging off the system correctly. It has to do with the > way the application interacts with informix. For example, if > a user simply closes the telnet window while still logged > into the system, then their process become a runaway and get > the 1 as the parent id. We then have to go and manually kill > off those rogue processes. My advice is to properly train > those folks to quit the application properly before shutting > down telnet. At least that worked for our shop. Best of luck. > > CKGeier@nwc.edu wrote: > > > This is a multipart message in MIME format. > > --=_alternative 005CC737862569E6_= > > Content-Type: text/plain; charset="us-ascii" > > > > We have had problems lately where processes that access the > database have > > been getting orphaned. This morning at 8am several users > (40+) processes > > suddenly had "1" as their parent id. Any ideas as to what > is the cause? We > > have an apache web server and it also shows many more > processes during > > this time than usual, some of those are orphaned as well. > It sounds to me > > like some main controlling thread or process is getting > killed or dying. > > What commands can I run to determine what is going on? > Thanks so much for > > all your help. I sure appreciate such an informed group of > people and all > > the help I have received in the past! > > > > Catherine Geier > > System Admin/IS support > > Northwestern College > > St. Paul, MN > > 651-631-5284 > > ckgeier@nwc.edu > > --=_alternative 005CC737862569E6_= > > Content-Type: text/html; charset="us-ascii" > > > > We have had problems > lately where processes that access the database have been > getting orphaned. This morning at 8am several users (40+) > processes suddenly had "1" as their parent id. Any > ideas as to what is the cause? We have an apache web server > and it also shows many more processes during this time than > usual, some of those are orphaned as well. It sounds to me > like some main controlling thread or process is getting > killed or dying. What commands can I run to determine what is > going on? Thanks so much for all your help. I sure appreciate > such an informed group of people and all the help I have > received in the past! > > > > Catherine Geier > > System Admin/IS support > > Northwestern College > > St. Paul, MN > > 651-631-5284 > > ckgeier@nwc.edu > > --=_alternative 005CC737862569E6_=-- > > -- > Phillip Tien > Database Administrator > Whole Foods Market, Inc. > >