How do I kill a hung process on Informix ODS
Kyle Campbell
I don't have my Informix ODS manuals here at home and I'd like to kill a
hung process on a remote site. What UNIX application can I use from the
command line would kill a process.
Thanks in advance,
Kyle
Michael Segel
well, you're out of luck. Nothing can kill a zombie short
of rebooting the system.
--
#include <std_disclaimer.h> /* Mike Segel (MS385) */
#include <No_Spam.h>
#ifdef OFFENDED_BY_CONTENT
The author takes no responsibility for this post.
Any resemblence to a coherent rational thought is purely coincidence.
-The Management.
#endif
*****************************
Due to AGIS's Refusal to Act Responsibly
We are blocking all of their domains at the packet level.
This block will exist until AGIS modifies their policies to
conform to existing RFCs and net community standards.
We encourage all ISPs and domain holders to do the same.
*****************************
Helmut Leininger
Michael Segel wrote:
> Kyle Campbell wrote:
> >
> > I don't have my Informix ODS manuals here at home and I'd like to kill a
> > hung process on a remote site. What UNIX application can I use from the
> > command line would kill a process.
> >
> > Thanks in advance,
> >
> > Kyle
> If the process becomes a zombie,
> well, you're out of luck. Nothing can kill a zombie short
> of rebooting the system.
>
There may be an additional problem in just killing a client process: it normally does
not end the session (connection to the database). This means, that the resources
(memory and even worse locks) remain. You should kill the online session by onmode -z,
too.
Helmut Leininger
Bull AG
email: Helmut.L...@bull.net
Thomas Tatum
>>>>> "Kyle" == Kyle Campbell <ky...@fix.net> writes:
Kyle> I don't have my Informix ODS manuals here at home and
Kyle> I'd like to kill a hung process on a remote site. What UNIX
Kyle> application can I use from the command line would kill a
Kyle> process.
Kyle> Thanks in advance,
Kyle> Kyle
kill -9 pid
--
Thomas Tatum
tho...@rtp.koz.com
919-489-5662 x32
919-602-6521
Jack Parker
I think the only thing you missed is the warning that a kill -9 on a
process in a critical section can crash your engine. Dave Kosenko did a
very nice write up years back on safely killing an Online process - should
be in the archives. I think it was called 'The killing of sqlturbo' or
somesuch.
cheers
j.
}Return-Path: <il...@rmy.emory.edu>
}From: Taras Kopach <ta...@evror.kiev.ua>
}Subject: Re: How do I kill a hung process on Informix ODS
}Date: Mon, 27 Oct 1997 20:56:47 +0200
}Reply-To: Taras Kopach <ta...@evror.kiev.ua>
}Organization: EuroResource corp.
}Sender: informix-...@rmy.emory.edu
}To: inform...@rmy.emory.edu
}X-Informix-List-Id: <news.44524>
} Easy, easy guys. The " kill -9 pid " is too ugly for Informix's process
}in critical section.
}And for the first time we must to log on the remote site. The easiest way
}is to use the "telnet" utility. Issue something like this:
} telnet remote_server_name
} If you are trusted on the remote server you can spawn a remote shell :
} rsh remote_server_name
}After you log on the remote server define the pid of a hanging process and
}issue command
} onmode -z pid
}Don't use this command three times one after another ( gives the same
}effect as "kill -9" ).
}There are also some soft "kill" options like "kill -15 pid " (see man
}kill) which don't kill a process without warning.
}You can also shutdown the Informix ODS using the onmonitor utility as last
}chance.
}
} Good luck,
} Taras.
}
}
}
Dave Otto
Assuming 5.0x...try kill -2. If this doesn't work, try
kill -13 followed by kill -14.
Assuming 7.x...try the onmode -z (as suggested below).
If this fails, try killing the associated O/S process
(if any) using the scheme above.
If all this fails, then the process is probably in a
"critical code section". At this point, it is far
safer to bounce the DB engine, than to try to kill the
thread.
Never - never - never use kill -9 on a 5.0x SQLTURBO
process (unless you LIKE restoring from tape).
-d
At 11:05 10/28/97 +1300, Peter Tashkoff wrote:
}kill -9 pid can also crash your entire engine.
}Much nicer is:
}onmode -z sessid.
}This usually works.
}If not, by all means use kill (If risking a crash is OK). Sometimes a
simple kill will do the job without having to get too emphatic about things.
}rgds
}
}
}Peter Tashkoff <tas...@iname.com>
}Zespri International Limited Std Disclaimers Apply
}All rights reserved. No party may use this document to vilify another.
}
}Zespri New Zealand Kiwifruit, The World's Finest
}
}
}>>> Thomas Tatum <tho...@koz.com> 28/10/97 04:51:54 >>>
Michael Segel
a -13 Kill option which will kill the child and send the appropriate
signal to the parent. (Sorry I don't have really good access to
my UNIX books and stuff from Cleveland.)
But a zombie is a process which dies or its parents die before
letting the process have its parent become root (PID=1).
Then you are SOL until you reboot.
HTH
-Mikey
Taras Kopach
Thomas Tatum wrote:
> >>>>> "Kyle" == Kyle Campbell <ky...@fix.net> writes:
>
> Kyle> I don't have my Informix ODS manuals here at home and
> Kyle> I'd like to kill a hung process on a remote site. What UNIX
> Kyle> application can I use from the command line would kill a
> Kyle> process.
>
> Kyle> Thanks in advance,
>
> Kyle> Kyle
>
> kill -9 pid
>
> --
>
> Thomas Tatum
> tho...@rtp.koz.com
> 919-489-5662 x32
> 919-602-6521
Easy, easy guys. The " kill -9 pid " is too ugly for Informix's process
Peter Tashkoff
kill -9 pid can also crash your entire engine.
Much nicer is:
onmode -z sessid.
This usually works.
simple kill will do the job without having to get too emphatic about =
things.
rgds
Peter Tashkoff <tashkop=40iname.com>
Zespri International Limited Std Disclaimers Apply
All rights reserved. No party may use this document to vilify another.
Zespri New Zealand Kiwifruit, The World=27s Finest
>>> Thomas Tatum <thomas=40koz.com> 28/10/97 04:51:54 >>>
>>>>> =22Kyle=22 =3D=3D Kyle Campbell <kyle=40fix.net> writes:
Kyle> I don=27t have my Informix ODS manuals here at home and
Kyle> I=27d like to kill a hung process on a remote site. What UNIX
Kyle> application can I use from the command line would kill a
Kyle> process.
Kyle> Thanks in advance,
Kyle> Kyle
kill -9 pid
--=20
Thomas Tatum
thomas=40rtp.koz.com=20
919-489-5662 x32
919-602-6521