RE: Assert Failed: Unexpected virtual processor termination

> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtual processor termination, pid = 15483, > exit = 0x8b" There was a lot of talk about this error ( on different platforms/versions ) a few weeks ago. I can't remember the exact resolution but I think it was a bug. I also think that there is a patch for HP that is supposed to clear up the problem. Please check the archives. Questions. 1. Why is there a check point of 37 seconds when all other check points are fine. 2. Do you have a copy of the af files etc as mentioned below. These files will show the SQL that caused the problems and the expected result is that it was a stored procedure. I however have also had similar scenarios with a select * from tablename. /informixtemp/af.8a975 will have the SQL for session 17729 Jo > > The IUS re-started OK and has not crashed since. > > But in my new found ignorance I would like to ask: > "What does such a failure mean ?" > > OK I'll be honest; the client has asked my boss to > explain what went wrong. And reasonablly enough my boss > has asked me. > > Desperately seeking plausible explanations guaranteed > to be believed by my boss ;-) > > Seriously I would like to be able to figure out what > happened and why. > > TIA. > > > > Michael > michael_martin@komatsu.co.jp > > ----------------------------------------------------- > > The excerpt from the log is as follows: > > Wed Aug 25 00:05:02 1999 > > 00:05:02 Checkpoint Completed: duration was 0 seconds. > 00:35:20 Checkpoint Completed: duration was 0 seconds. > 02:06:15 Checkpoint Completed: duration was 0 seconds. > 02:36:34 Checkpoint Completed: duration was 0 seconds. > 07:39:36 Checkpoint Completed: duration was 0 seconds. > 08:09:54 Checkpoint Completed: duration was 0 seconds. > 08:39:59 Checkpoint Completed: duration was 0 seconds. > 09:11:03 Checkpoint Completed: duration was 37 seconds. > 09:41:04 Checkpoint Completed: duration was 0 seconds. > 10:11:21 Checkpoint Completed: duration was 0 seconds. > 10:41:44 Checkpoint Completed: duration was 0 seconds. > 11:11:51 Checkpoint Completed: duration was 0 seconds. > 11:41:52 Checkpoint Completed: duration was 0 seconds. > 12:12:11 Checkpoint Completed: duration was 0 seconds. > 12:42:31 Checkpoint Completed: duration was 0 seconds. > 13:12:49 Checkpoint Completed: duration was 0 seconds. > 13:42:53 Checkpoint Completed: duration was 1 seconds. > 14:13:07 Checkpoint Completed: duration was 0 seconds. > 14:43:22 Checkpoint Completed: duration was 1 seconds. > 15:13:33 Checkpoint Completed: duration was 0 seconds. > 15:44:05 Checkpoint Completed: duration was 4 seconds. > 16:14:33 Checkpoint Completed: duration was 0 seconds. > 16:44:45 Checkpoint Completed: duration was 0 seconds. > 17:14:55 Checkpoint Completed: duration was 0 seconds. > 17:27:02 Assert Failed: Exception Caught. Type: MT_EX_OS,> Context: mem > 17:27:02 INFORMIX-Universal Server Version 9.14.UC6 > 17:27:02 Who: Session(17299, informix@se0, -4110981, 0) > Thread(17331, sqlexec, 0, 3) > File: mtex.c Line: 291 > 17:27:02 Action: Please notify Informix Technical Support. > 17:27:05 Blocking whole system for max 0 secs > 17:27:05 VP 3 timed out during system block, releasing > 17:27:05 VP 4 timed out during system block, releasing > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:27:05 Releasing server from system block > 17:29:29 See Also: /informixtemp/af.43b3a8d5, > shmem.43b3a8d5.0, /home1/informi > x/core, gcore.43b3a8d5.0 > 17:29:41 Assert Failed: Unexpected virtual processor > termination, pid = 15483,> exit = 0x8b > > 17:29:41 INFORMIX-Universal Server Version 9.14.UC6 > 17:29:41 Who: Session(2, informix@, 0, 0) > Thread(8, ipcstrpoll, 0, 1) > File: mt.c Line: 9591 > 17:29:44 Blocking whole system for max 0 secs > 17:29:44 Internal error detected in notify_vp > 17:29:44 VP 1 timed out during system block, releasing > 17:33:23 See Also: /informixtemp/af.8a975, shmem.8a975.0, > /home1/informix/core > , gcore.8a975.0> > > > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________