Informix crashed

14:40:29 Assert Failed: No Exception Handler 14:40:29 Who: Session(411997, api@whflxsnp03, -1, 1656317200) Thread(524940, sqlexec, 80582d98, 1) File: mtex.c Line: 405 14:40:29 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:40:29 Action: Please notify Informix Technical Support. 14:40:29 Stack for thread: 524940 sqlexec base: 0x695ce000 len: 36864 pc: 0x006b43d0 tos: 0x695d5cd0 state: running vp: 1 0x006b3794 (oninit)afhandler(0x674eabd, 0x1, 0x0, 0x62b96510, 0x3, 0x80582d98) 0x006b3200 (oninit)afcrash_interface(0x9a7794, 0x695d6428, 0x6450e6b0, 0x9a77ac, 0x195, 0x0) 0x006b76e4 (oninit)mt_ex_throw_sig(0x1, 0x9a4ae0, 0x4, 0xffffffff, 0x1, 0xff) 0x006876b0 (oninit)afsig_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x0072f110 (oninit)fmclose (0x8c9748, 0x2fc0, 0x1e50, 0x0, 0x5fe91000, 0x695d6ba4) 0x00737f7c (oninit)fmtabfree(0x678e2fcc, 0x40, 0x1, 0x38, 0x678e2ee8, 0xef508960) 0x00698410 (oninit)destroy_session(0x8aa90bd8, 0x1, 0x8aa90bd8, 0x8c9400, 0x8aa90bd8, 0x8aa90bd8) 0x001b30c0 (oninit)sqsetconerr(0xffff9c12, 0xd, 0x6759c080, 0x82550140, 0x825500a8, 0x6759c078) 0x003c218c (oninit)asf_recv(0xa18568, 0x6759c058, 0x7, 0x39, 0x34, 0x6892a234) 0x003c2238 (oninit)_iread (0x695d6eb6, 0x2, 0xa18568, 0x0, 0x2, 0xef508960) 0x003c0a24 (oninit)_igetint(0x0, 0x1000000, 0x8c9400, 0x0, 0x0, 0x68a43460) 0x003bbfdc (oninit)sqmain (0xa18568, 0xc, 0xa23c00, 0x8ee078, 0xfffdffff, 0x20000) 0x00694698 (oninit)startup (0xa1e400, 0xa0f400, 0x59009270, 0x0, 0x0, 0x59009270) 0x006886ac (oninit)idle_processor(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 (*nosymtab*)0x0 14:40:29 See Also: /tmp/af.674eabd --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type: CRASH Host Name: whflxsnp02 Database Server Name: ifmx_flx Time of failure: Tue Jan 28 14:40:30 CST 2003 AF file: /tmp/af.674eabd Shared memory file: None System Blocking: OFF ===========------------- - - - - - - tail -100 /opt/informix.org/logs/online.log: 13:49:44 Checkpoint loguniq 1098, logpos 0xbee018 13:59:04 Password Validation for user [api] failed! 13:59:04 Check for password aging/account lock-out. 13:59:04 listener-thread: err = -952: oserr = 0: errstr = api: User's password is not correct for the database server. 14:50:05 Checkpoint Completed: duration was 1 seconds. 14:50:05 Checkpoint loguniq 1098, logpos 0xc64018 15:50:25 Checkpoint Completed: duration was 1 seconds. 15:50:25 Checkpoint loguniq 1098, logpos 0x1033018 16:50:46 Checkpoint Completed: duration was 0 seconds. 16:50:46 Checkpoint loguniq 1098, logpos 0x123e018 17:51:07 Checkpoint Completed: duration was 0 seconds. 17:51:07 Checkpoint loguniq 1098, logpos 0x1243018 18:51:28 Checkpoint Completed: duration was 0 seconds. 18:51:28 Checkpoint loguniq 1098, logpos 0x1244018 19:51:48 Checkpoint Completed: duration was 0 seconds. 19:51:48 Checkpoint loguniq 1098, logpos 0x1245018 20:52:09 Checkpoint Completed: duration was 0 seconds. 20:52:09 Checkpoint loguniq 1098, logpos 0x1247018 21:52:30 Checkpoint Completed: duration was 0 seconds. 21:52:30 Checkpoint loguniq 1098, logpos 0x1248018 22:52:51 Checkpoint Completed: duration was 1 seconds. 22:52:51 Checkpoint loguniq 1098, logpos 0x1249018 23:53:12 Checkpoint Completed: duration was 0 seconds. 23:53:12 Checkpoint loguniq 1098, logpos 0x124a018 Tue Jan 28 00:53:32 2003 00:53:32 Checkpoint Completed: duration was 0 seconds. 00:53:32 Checkpoint loguniq 1098, logpos 0x1258018 01:53:53 Checkpoint Completed: duration was 0 seconds. 01:53:53 Checkpoint loguniq 1098, logpos 0x125b018 02:54:12 Checkpoint Completed: duration was 0 seconds. 02:54:12 Checkpoint loguniq 1098, logpos 0x125c018 03:54:32 Checkpoint Completed: duration was 0 seconds. 03:54:32 Checkpoint loguniq 1098, logpos 0x125d018 04:54:53 Checkpoint Completed: duration was 0 seconds. 04:54:53 Checkpoint loguniq 1098, logpos 0x125e018 05:55:13 Checkpoint Completed: duration was 0 seconds. 05:55:13 Checkpoint loguniq 1098, logpos 0x1267018 06:55:33 Checkpoint Completed: duration was 0 seconds. 06:55:33 Checkpoint loguniq 1098, logpos 0x126e018 07:55:53 Checkpoint Completed: duration was 0 seconds. 07:55:53 Checkpoint loguniq 1098, logpos 0x126f018 08:09:55 Logical Log 1098 Complete. 08:18:12 Logical Log 1099 Complete. 08:56:14 Checkpoint Completed: duration was 0 seconds. 08:56:14 Checkpoint loguniq 1100, logpos 0x1058018 09:20:34 Logical Log 1100 Complete. 09:56:35 Checkpoint Completed: duration was 1 seconds. 09:56:35 Checkpoint loguniq 1101, logpos 0x826018 10:44:13 Logical Log 1101 Complete. 10:56:56 Checkpoint Completed: duration was 1 seconds. 10:56:56 Checkpoint loguniq 1102, logpos 0x1042018 11:07:15 Logical Log 1102 Complete. 11:57:17 Checkpoint Completed: duration was 1 seconds. 11:57:17 Checkpoint loguniq 1103, logpos 0xd4b018 12:55:08 Password Validation for user [api] failed! 12:55:08 Check for password aging/account lock-out. 12:55:08 listener-thread: err = -952: oserr = 0: errstr = api: User's password is not correct for the database server. 12:57:38 Checkpoint Completed: duration was 0 seconds. 12:57:38 Checkpoint loguniq 1103, logpos 0xfb3018 13:57:58 Checkpoint Completed: duration was 1 seconds. 13:57:58 Checkpoint loguniq 1103, logpos 0x112c018 14:19:56 Logical Log 1103 Complete. 14:40:29 Assert Failed: No Exception Handler 14:40:29 Informix Dynamic Server 2000 Version 9.21.UC4XE 14:40:29 Who: Session(411997, api@whflxsnp03, -1, 1656317200) Thread(524940, sqlexec, 80582d98, 1) File: mtex.c Line: 405 14:40:29 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:40:29 Action: Please notify Informix Technical Support. 14:40:29 stack trace for pid 11471 written to /tmp/af.674eabd 14:40:29 See Also: /tmp/af.674eabd

I would suggest opening up a case for this ... it looks like the session was in the process of cleaning up when it crashed ... if you've got the shared memory dump too, then you can send the AF file and shmem dump to tech support and the engineers can take a look at it. Thanx much, Rajib Sarkar Advisory Support Engineer (Wells Fargo Bank) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "rkusenet " <rkusenet@sympat To: ids@iiug.org ico.ca> cc: Sent by: Subject: Informix crashed [145] forum.subscriber @iiug.org 01/28/2003 02:10 PM 14:40:29 Assert Failed: No Exception Handler 14:40:29 Who: Session(411997, api@whflxsnp03, -1, 1656317200) Thread(524940, sqlexec, 80582d98, 1) File: mtex.c Line: 405 14:40:29 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:40:29 Action: Please notify Informix Technical Support. 14:40:29 Stack for thread: 524940 sqlexec base: 0x695ce000 len: 36864 pc: 0x006b43d0 tos: 0x695d5cd0 state: running vp: 1 0x006b3794 (oninit)afhandler(0x674eabd, 0x1, 0x0, 0x62b96510, 0x3, 0x80582d98) 0x006b3200 (oninit)afcrash_interface(0x9a7794, 0x695d6428, 0x6450e6b0, 0x9a77ac, 0x195, 0x0) 0x006b76e4 (oninit)mt_ex_throw_sig(0x1, 0x9a4ae0, 0x4, 0xffffffff, 0x1, 0xff) 0x006876b0 (oninit)afsig_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x0072f110 (oninit)fmclose (0x8c9748, 0x2fc0, 0x1e50, 0x0, 0x5fe91000, 0x695d6ba4) 0x00737f7c (oninit)fmtabfree(0x678e2fcc, 0x40, 0x1, 0x38, 0x678e2ee8, 0xef508960) 0x00698410 (oninit)destroy_session(0x8aa90bd8, 0x1, 0x8aa90bd8, 0x8c9400, 0x8aa90bd8, 0x8aa90bd8) 0x001b30c0 (oninit)sqsetconerr(0xffff9c12, 0xd, 0x6759c080, 0x82550140, 0x825500a8, 0x6759c078) 0x003c218c (oninit)asf_recv(0xa18568, 0x6759c058, 0x7, 0x39, 0x34, 0x6892a234) 0x003c2238 (oninit)_iread (0x695d6eb6, 0x2, 0xa18568, 0x0, 0x2, 0xef508960) 0x003c0a24 (oninit)_igetint(0x0, 0x1000000, 0x8c9400, 0x0, 0x0, 0x68a43460) 0x003bbfdc (oninit)sqmain (0xa18568, 0xc, 0xa23c00, 0x8ee078, 0xfffdffff, 0x20000) 0x00694698 (oninit)startup (0xa1e400, 0xa0f400, 0x59009270, 0x0, 0x0, 0x59009270) 0x006886ac (oninit)idle_processor(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 (*nosymtab*)0x0 14:40:29 See Also: /tmp/af.674eabd --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type: CRASH Host Name: whflxsnp02 Database Server Name: ifmx_flx Time of failure: Tue Jan 28 14:40:30 CST 2003 AF file: /tmp/af.674eabd Shared memory file: None System Blocking: OFF ===========------------- - - - - - - tail -100 /opt/informix.org/logs/online.log: 13:49:44 Checkpoint loguniq 1098, logpos 0xbee018 13:59:04 Password Validation for user [api] failed! 13:59:04 Check for password aging/account lock-out. 13:59:04 listener-thread: err = -952: oserr = 0: errstr = api: User's password is not correct for the database server. 14:50:05 Checkpoint Completed: duration was 1 seconds. 14:50:05 Checkpoint loguniq 1098, logpos 0xc64018 15:50:25 Checkpoint Completed: duration was 1 seconds. 15:50:25 Checkpoint loguniq 1098, logpos 0x1033018 16:50:46 Checkpoint Completed: duration was 0 seconds. 16:50:46 Checkpoint loguniq 1098, logpos 0x123e018 17:51:07 Checkpoint Completed: duration was 0 seconds. 17:51:07 Checkpoint loguniq 1098, logpos 0x1243018 18:51:28 Checkpoint Completed: duration was 0 seconds. 18:51:28 Checkpoint loguniq 1098, logpos 0x1244018 19:51:48 Checkpoint Completed: duration was 0 seconds. 19:51:48 Checkpoint loguniq 1098, logpos 0x1245018 20:52:09 Checkpoint Completed: duration was 0 seconds. 20:52:09 Checkpoint loguniq 1098, logpos 0x1247018 21:52:30 Checkpoint Completed: duration was 0 seconds. 21:52:30 Checkpoint loguniq 1098, logpos 0x1248018 22:52:51 Checkpoint Completed: duration was 1 seconds. 22:52:51 Checkpoint loguniq 1098, logpos 0x1249018 23:53:12 Checkpoint Completed: duration was 0 seconds. 23:53:12 Checkpoint loguniq 1098, logpos 0x124a018 Tue Jan 28 00:53:32 2003 00:53:32 Checkpoint Completed: duration was 0 seconds. 00:53:32 Checkpoint loguniq 1098, logpos 0x1258018 01:53:53 Checkpoint Completed: duration was 0 seconds. 01:53:53 Checkpoint loguniq 1098, logpos 0x125b018 02:54:12 Checkpoint Completed: duration was 0 seconds. 02:54:12 Checkpoint loguniq 1098, logpos 0x125c018 03:54:32 Checkpoint Completed: duration was 0 seconds. 03:54:32 Checkpoint loguniq 1098, logpos 0x125d018 04:54:53 Checkpoint Completed: duration was 0 seconds. 04:54:53 Checkpoint loguniq 1098, logpos 0x125e018 05:55:13 Checkpoint Completed: duration was 0 seconds. 05:55:13 Checkpoint loguniq 1098, logpos 0x1267018 06:55:33 Checkpoint Completed: duration was 0 seconds. 06:55:33 Checkpoint loguniq 1098, logpos 0x126e018 07:55:53 Checkpoint Completed: duration was 0 seconds. 07:55:53 Checkpoint loguniq 1098, logpos 0x126f018 08:09:55 Logical Log 1098 Complete. 08:18:12 Logical Log 1099 Complete. 08:56:14 Checkpoint Completed: duration was 0 seconds. 08:56:14 Checkpoint loguniq 1100, logpos 0x1058018 09:20:34 Logical Log 1100 Complete. 09:56:35 Checkpoint Completed: duration was 1 seconds. 09:56:35 Checkpoint loguniq 1101, logpos 0x826018 10:44:13 Logical Log 1101 Complete. 10:56:56 Checkpoint Completed: duration was 1 seconds. 10:56:56 Checkpoint loguniq 1102, logpos 0x1042018 11:07:15 Logical Log 1102 Complete. 11:57:17 Checkpoint Completed: duration was 1 seconds. 11:57:17 Checkpoint loguniq 1103, logpos 0xd4b018 12:55:08 Password Validation for user [api] failed! 12:55:08 Check for password aging/account lock-out. 12:55:08 listener-thread: err = -952: oserr = 0: errstr = api: User's password is not correct for the database server. 12:57:38 Checkpoint Completed: duration was 0 seconds. 12:57:38 Checkpoint loguniq 1103, logpos 0xfb3018 13:57:58 Checkpoint Completed: duration was 1 seconds. 13:57:58 Checkpoint loguniq 1103, logpos 0x112c018 14:19:56 Logical Log 1103 Complete. 14:40:29 Assert Failed: No Exception Handler 14:40:29 Informix Dynamic Server 2000 Version 9.21.UC4XE 14:40:29 Who: Session(411997, api@whflxsnp03, -1, 1656317200) Thread(524940, sqlexec, 80582d98, 1) File: mtex.c Line: 405 14:40:29 Results: Exception Caught. Type: MT_EX_OS, Context: mem 14:40:29 Action: Please notify Informix Technical Support. 14:40:29 stack trace for pid 11471 written to /tmp/af.674eabd 14:40:29 See Also: /tmp/af.674eabd