If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Informix process expired frequently

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-19-06, 03:49
radhakrishnan radhakrishnan is offline
Registered User
 
Join Date: Feb 2006
Posts: 5
Informix process expired frequently

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.
Reply With Quote
  #2 (permalink)  
Old 05-22-06, 08:10
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Hi,

Maybe is a bug, but check the memory resource with onstat -g seg.
Maybe you need add memory.

Gustavo.
Reply With Quote
  #3 (permalink)  
Old 05-24-06, 08:08
theeiledon theeiledon is offline
Registered User
 
Join Date: Nov 2004
Posts: 60
Memory could also be faulty i.e. hardware error. I guess it crashes when you start pumping some transactions through it?
Reply With Quote
  #4 (permalink)  
Old 05-24-06, 09:48
fwellers fwellers is offline
Registered User
 
Join Date: May 2006
Location: Virginia
Posts: 6
Looks like it's failing at the same time every day. I'd check to see what processes and queries are running at that time. You are probably hitting a bug anyway.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On