question:ids crash?

Posted in 2010

MA TAO — Sat, 15 May 2010 02:06:21 — source: IIUG Forums & Mailing Lists

question:ids crash？ ids:Version 9.40.FC3 AIX when ids crash时，dump file as follows: 08:48:21 Assert Failed: No Exception Handler 08:48:21 Who: Session(448, intraqry@30.254.1.151, 1576, 7000000c5fc4100) Thread(467, sqlexec, 7000000c0912de8, 1) File: mtex.c Line: 431 08:48:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem 08:48:21 Action: Please notify IBM Informix Technical Support. 08:48:21 Stack for thread: 467 sqlexec 08:45:48 Maximum server connections 116 08:48:21 Assert Failed: No Exception Handler 08:48:21 IBM Informix Dynamic Server Version 9.40.FC3 08:48:21 Who: Session(448, intraqry@30.254.1.151, 1576, 7000000c5fc4100) Thread(467, sqlexec, 7000000c0912de8, 1) File: mtex.c Line: 431 08:48:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem 08:48:21 Action: Please notify IBM Informix Technical Support. 08:48:21 stack trace for pid 307220 written to /tmp/af.5bbb4d4 08:48:21 See Also: /tmp/af.5bbb4d4, shmem.5bbb4d4.0 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 448 INSERT rpquery DR Not Wait 0 0 9.03 Off Current SQL statement : insert into tmp_bxzlist(bxzh_no,tbr_id,bbr_id,dlr_code,bd_flg) select b.gs_code||"-"||b.xz_code||"-"||b.bxzh_no||"-"||b.gr_no, b.tbr_id,b.bbr_id,b.dlr_code,"1" from tmp_bxzqry a,yxpicc@clic_h18tcp2:txqy01_bd b where 1=1 and a.bxzh_no = b.bxzh_no Last parsed SQL statement : insert into tmp_bxzlist(bxzh_no,tbr_id,bbr_id,dlr_code,bd_flg) select b.gs_code||"-"||b.xz_code||"-"||b.bxzh_no||"-"||b.gr_no, b.tbr_id,b.bbr_id,b.dlr_code,"1" from tmp_bxzqry a,yxpicc@clic_h18tcp2:txqy01_bd b where 1=1 and a.bxzh_no = b.bxzh_no online.log as follows: 08:45:48 Maximum server connections 116 08:48:21 Assert Failed: No Exception Handler 08:48:21 IBM Informix Dynamic Server Version 9.40.FC3 08:48:21 Who: Session(448, intraqry@30.254.1.151, 1576, 7000000c5fc4100) Thread(467, sqlexec, 7000000c0912de8, 1) File: mtex.c Line: 431 08:48:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem 08:48:21 Action: Please notify IBM Informix Technical Support. 08:48:21 stack trace for pid 307220 written to /tmp/af.5bbb4d4 08:48:21 See Also: /tmp/af.5bbb4d4, shmem.5bbb4d4.0 08:51:17 Fuzzy Checkpoint Completed: duration was 0 seconds, 21 buffers not flushed, timestamp: 1156429638. 08:51:17 Checkpoint loguniq 1182, logpos 0xbdc19c, timestamp: 1156429638 08:51:17 Maximum server connections 116 08:56:21 Fuzzy Checkpoint Completed: duration was 5 seconds, 21 buffers not flushed, timestamp: 1156429657. 08:56:21 Checkpoint loguniq 1182, logpos 0xbdd13c, timestamp: 1156429657 08:56:21 Maximum server connections 116 09:01:22 Fuzzy Checkpoint Completed: duration was 0 seconds, 21 buffers not flushed, timestamp: 1156429747. 09:01:22 Checkpoint loguniq 1182, logpos 0xbde190, timestamp: 1156429747 09:01:22 Maximum server connections 116 09:06:23 Fuzzy Checkpoint Completed: duration was 1 seconds, 21 buffers not flushed, timestamp: 1156429816. 09:06:23 Checkpoint loguniq 1182, logpos 0xbdf190, timestamp: 1156429816 09:06:23 Maximum server connections 116 09:07:28 Error writing '/tmp/shmem.5bbb4d4.0' errno = 28 09:07:28 mtex.c, line 431, thread 467, proc id 307220, No Exception Handler. 09:07:28 invoke_alarm(): /bin/sh -c '/home/informix/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "mtex.c, line 431, thread 467, proc id 307220, No Exception Handler." ' 09:07:28 invoke_alarm(): mt_exec failed, status 7168, errno 0 09:07:29 The Master Daemon Died 09:07:29 invoke_alarm(): /bin/sh -c '/home/informix/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "The Master Daemon Died" ' 09:07:29 invoke_alarm(): mt_exec failed, status 7168, errno 0 09:07:29 PANIC: Attempting to bring system down question:why ids crash,how can i solve this problem?