Hi,
We have an Informix server where informix process are expired (down) frequently and also it is core dumping.I have attached the core files and also the error messages.Can anybody help me this?
Online.log
---------
02:00:21 IBM Informix Dynamic Server Version 9.40.UC4X3
02:00:21 Who: Session(340, vnmadm@172.30.218.29, 24716, 191e9e88)
Thread(370, sqlexec, 192656e8, 3)
File: mtex.c Line: 431
02:00:21 Results: Exception Caught. Type: MT_EX_OS, Context: mem
02:00:21 Action: Please notify IBM Informix Technical Support.
02:00:21 stack trace for pid 1843 written to /tmp/af.55a7c94
02:00:21 See Also: /tmp/af.55a7c94, shmem.55a7c94.0
02:00:21 listener-thread: err = -14565: oserr = 0: errstr = : CSS: error reading data.
02:01:03 mtex.c, line 431, thread 370, proc id 1843, No Exception Handler.
02:01:07 Fatal error in ADM VP at mt.c:12323
02:01:07 Unexpected virtual processor termination, pid = 1843, exit = 0x100
02:01:07 PANIC: Attempting to bring system down
09:17:08 IBM Informix Dynamic Server Started.
Tue Mar 28 09:17:09 2006
09:17:09 Event alarms enabled. ALARMPROG = '/usr/users/informix72/etc/log_full.sh'
09:17:10 Booting Language <c> from module <>
09:17:10 Loading Module <CNULL>
09:17:10 Booting Language <builtin> from module <>
09:17:10 Loading Module <BUILTINNULL>
09:17:14 Requested shared memory segment size rounded from 664KB to 1024KB
09:17:14 IBM Informix Dynamic Server Version 9.40.UC4X3 Software Serial Number AAA#B000000
09:17:15 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
09:17:15 Physical Recovery Started at Page (1:1090).
09:17:15 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
09:17:15 Logical Recovery Started.
09:17:15 10 recovery worker threads will be started.
09:17:18 Logical Recovery has reached the transaction cleanup phase.
09:17:18 Logical Recovery Complete.
4 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
09:17:19 Dataskip is now OFF for all dbspaces
09:17:20 Checkpoint Completed: duration was 1 seconds.
09:17:20 Checkpoint loguniq 142, logpos 0x50018, timestamp: 0x9bbb1e6
09:17:20 Maximum server connections 0
09:17:20 On-Line Mode
09:17:49 Checkpoint Completed: duration was 0 seconds.
09:17:49 Checkpoint loguniq 142, logpos 0x51018, timestamp: 0x9bbbf65
09:17:49 Maximum server connections 8
09:18:38 Booting Language <spl> from module <>
09:18:38 Loading Module <SPLNULL>
11:17:49 Checkpoint Completed: duration was 0 seconds.
11:17:49 Checkpoint loguniq 142, logpos 0x52018, timestamp: 0x9bc1457
11:17:49 Maximum server connections 13
11:59:45 Logical Log 142 Complete, timestamp: 0x9bc3d07.
11:59:47 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 142 Complete, timestamp: 0x9bc3d07." "Logical
11:59:47 Logical Log 143 Complete, timestamp: 0x9bc45d5.
11:59:48 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 143 Complete, timestamp: 0x9bc45d5." "Logical
12:01:47 Logical Log 144 Complete, timestamp: 0x9bc5b9c.
12:01:48 Process exited with return code 156: /bin/sh /bin/sh -c /usr/users/informix72/etc/log_full.sh 2 23 "Logical Log 144 Complete, timestamp: 0x9bc5b9c." "Logical
13:17:49 Checkpoint Completed: duration was 0 seconds.
13:17:49 Checkpoint loguniq 145, logpos 0xec018, timestamp: 0x9bc85eb
13:17:49 Maximum server connections 13
15:17:49 Checkpoint Completed: duration was 0 seconds.
15:17:49 Checkpoint loguniq 145, logpos 0xed0c8, timestamp: 0x9bcf51f
15:17:49 Maximum server connections 14
17:17:49 Checkpoint Completed: duration was 0 seconds.
17:17:49 Checkpoint loguniq 145, logpos 0xee018, timestamp: 0x9bd7deb
17:17:49 Maximum server connections 14
19:17:49 Checkpoint Completed: duration was 0 seconds.
19:17:49 Checkpoint loguniq 145, logpos 0xef018, timestamp: 0x9be15cc
19:17:49 Maximum server connections 14
21:17:49 Checkpoint Completed: duration was 0 seconds.
21:17:49 Checkpoint loguniq 145, logpos 0xf0124, timestamp: 0x9bebbf1
21:17:49 Maximum server connections 14
23:17:49 Checkpoint Completed: duration was 0 seconds.
23:17:49 Checkpoint loguniq 145, logpos 0xf1018, timestamp: 0x9bf32e9
23:17:49 Maximum server connections 14
Wed Mar 29 01:17:49 2006
01:17:49 Checkpoint Completed: duration was 0 seconds.
01:17:49 Checkpoint loguniq 145, logpos 0xf2018, timestamp: 0x9bfb57e
01:17:49 Maximum server connections 14
02:00:22 Assert Failed: No Exception Handler
02:00:22 IBM Informix Dynamic Server Version 9.40.UC4X3
02:00:22 Who: Session(45, vnmadm@172.30.218.29, 5374, 15228900)
Thread(67, sqlexec, 151fd628, 3)
File: mtex.c Line: 431
02:00:22 Results: Exception Caught. Type: MT_EX_OS, Context: mem
02:00:22 Action: Please notify IBM Informix Technical Support.
02:00:22 stack trace for pid 21243 written to /tmp/af.42bce16
02:00:22 See Also: /tmp/af.42bce16, shmem.42bce16.0
02:00:22 listener-thread: err = -14565: oserr = 0: errstr = : CSS: error reading data.