Informix instance down
Posted in 2007
Hi Experts, We have IDS9.40UC1 on Linux. We run the python scripts that automatically run and create the database and then perform DML operations. Now when we run one of the tool, it results instance down. The below is some contents of online log: 15:12:49 Maximum server connections 2 15:13:52 Logical Log 500 Complete, timestamp:1041574554. 15:13:52 Process exited with return code 126: /bin/sh /bin/sh -c /software/ids/etc/alarmprogram.sh 2 23 "Logical Log 500 Complete, timestamp:-1." "Logical Log 500 Comp 15:17:49 Fuzzy Checkpoint Completed: duration was 0 seconds, 9734 buffers not flushed, timestamp: 1042046076. 15:17:49 Checkpoint loguniq 501, logpos 0x1b366e8, timestamp: 1042046076 15:17:49 Maximum server connections 3 15:17:49 Assert Failed: No Exception Handler 15:17:49 Informix Dynamic Server Version 9.40.UC1 15:17:49 Who: Session(25, cdbuild@lxwks-9084, 8159, 0x247e8288) Thread(58, sqlexec, 247bc348, 4) File: mtex.c Line: 431 15:17:49 Results: Exception Caught. Type: MT_EX_OS, Context: mem 15:17:49 Action: Please notify Informix Technical Support. 15:17:49 stack trace for pid 1247 written to /software/ids/logs/dump/af.4222145 15:17:49 See Also: /software/ids/logs/dump/af.4222145 15:17:51 mtex.c, line 431, thread 58, proc id 1247, No Exception Handler. 15:17:51 invoke_alarm(): /bin/sh -c '/software/ids/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "mtex.c, line 431, thread 58, proc id 1247, No Exception Handler." ' 15:17:51 invoke_alarm(): mt_exec failed, status 32256, errno 0 15:17:51 Fatal error in ADM VP at mt.c:12191 15:17:51 Unexpected virtual processor termination, pid = 1247, exit = 0x100 15:17:51 invoke_alarm(): /bin/sh -c '/software/ids/etc/alarmprogram.sh 5 6 "Internal Subsystem failure: 'MT'" "Unexpected virtual processor termination, pid = 1247, exit = 0x100 " ' 15:17:51 invoke_alarm(): mt_exec failed, status 32256, errno 0 15:17:51 PANIC: Attempting to bring system down 15:17:51 semctl: errno = 22 15:17:51 semctl: errno = 22 15:17:51 semctl: errno = 22 But when we run the other scripts, then it is working fine. Can you please suggest me as one and half month back, we faced the same problem and our server crashed. We are using this IDS9.40UC1 since the last 2 years and we did not face this problem earlier. Please suggest something to resolve the issue. Thanks in Advance Gulshan