Re: HELP! runaway sqlexecs!

->From: rpcg@panix.com (R P Consulting Group) ->Subject: HELP! runaway sqlexecs! ->Date: 18 Aug 1993 08:46:34 -0400 ->Reply-To: rpcg@panix.com (R P Consulting Group) ->Organization: PANIX Public Access Internet and Unix, NYC -> ->anyone familiar with this phenomenon? -> ->If a user on my systems exits from an active database session in an ->"ungraceful" fashion (IPLing his machine, truning off his machine, ->network connection is lost, dialup connection is lost, etc...) a ->"runaway" sqlexec process begins. -> ->The behaviou of this process is to use as much system resouces as it ->can get, forever. Kill w/ extreme prejudice is the only cure for the ->totally blacked out CPU portion of my perfmeters. -> ->What causes this? Is there any way to prevent it? -> ->Mike Stenzler ->RP Consulting Group ->rpcg@panix.com In case misery loves company, I have encountered this also. Not that I can help you much. Circumstances for our occurrence: 1. User uses NCSA telnet on a Mac to login to our Sun server. 2. User runs our Informix application. 3. User closes the Mac window without exiting from Informix application. 4. Perfmeter hits redline. What causes this? My guess is the sqlexec is running around frantically saying the electronic equivalent of "Yoo hoo! Where are you?" Is there any way to prevent it? 1. Educate your users. (Sort of) easy; short term pay-back; middling success, based on user cooperation level. 2. Ask Informix to make sqlexec trap for lost connection. I'm not sure how (or if) it can be done, and it's probably pretty hard; so, unless *lots* of folks ask for this, Informix probably won't do it. Pay-back would be way down stream. IF Informix makes the change, then high success. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, Tech Ops | / \\ alan@den.mmc.com | P.O. Box 179, M/S 5422 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\