Re: Informix Hangs !! HELP !!

Jung-Hui Cheng wrote: > > My Informix Server ( Online 7.22UC3 with HP-UX 10.20 ) will hang > without any > message except one in the online.log : > > 21:49:33 mt.c, line 7991, thread 16178, proc id 13371, mt_notifyvp timed > out. There are several bugs causing an mt_notifyvp time out. This indicates that the admin VP which monitors the other VPs has determined that one of the VPs has not responded to its current job or hearbeated its continued busy status in too long and the engine assumes that that VP is hung or crashed so it tries to shut down the engine. Sometimes that cannot happen because things are just to badly hosed, other times the engine comes down but the master oninit is the one hung and it is also the one that normally removes shared memory so the memory stays around and onstat can query it but as the onstat -d messages indicated it cannot get a message from the oninit processes. Running onmode -ky will usually bring down any remaining oninits and shared memory if it does not you will have to kill -9 all the oninits and ipcrm the shared memory segments owned by that Informix instance (if you have more than on instance the shared memory keys start with 0x5256 + SERVERNUM from the ONCONFIG file for that instance). One of the bugs, 91291, is the result of a rare three way deadlock between multiple threads over several system resources. This bug is fixed in 7.24UC6 and later. Art S. Kagel