FW: RE: Informix IDS query to the Informix -list

Fwd from sputnik' ________________________________________ From: None [mailto:myinformix@rediffmail.com] Sent: Tuesday, September 14, 2004 02:08 To: Jean Georges Perrin Subject: Re: RE: Informix IDS query to the Informix -list ' Hi Jean, Thank you for your prompt reply. If you can please publish the following request in informix-list@iiug.org where all our Informix gurus are roaming. I am a registered user at iiug an it was my first attempt to publish anything. Please let me know if this is not possible for you to publish in the above list. Thank you very much. Sputnik This is my issue.... Hi Team, I am facing a serious issue with my informix instance. Recently it crashed when I ran update statistics with PDQ anabled mode.(During this process it was dynamically allocating memory and it crashed when it tries to go beyond 1896MB). The server got 4GB physical memory running on LINUX 2.4.9-e.3smp kernal on a DELL POWEREDGE 6650 machine with 4 Pentium ZEON processors. We started to experience issues when we tried to allocate more memory to Informix after some upgrades on our 4GL programs. We have been using 750MB for informix for quite a sometime and there were no issues until end of June. (We had 2GB RAM at that time.) Then we increased the shared memory beyond 750MB.If I leave the server to run more than 24 hours the whole server freezes. We can see through cat /proc/meminfo that its "LOW FREE" memory is going down and server won't free it and eventually that leads to the freezing. Thinking that it could be not enough RAM' we increased it to 4GB in August and then tried to allocate more for Informix. The problem persists after that as well,' and we are now compelled to restart the whole server every morning. Some with considerable LINUX knowledge suggested that we should upgrade the kernal.That means we need to upgrade the INFORMIX as well. Isn't it?? Strange thing is if I set Informix shared memory to more than 1896MB through onconfig then it won't start. It will dump the sharedmemory with an ASSERTION failure message. This happened yeasterday when I tried to increase it. It works when the shared memory is less than 1896MB. My guess is that this is happening because of LINUX is buggy or my be it's a bug with the INFORMIX version itself. I simply don't know which one is buggy or both or may be some serious Informix configuration issue(Which I really doubt-) Normally it runs smoothly after rebooting. I am sending the server shared memory dumps for both recent crashes.Any help in this regard highly appreciated. I have been working with INFORMIX IDS and havn't come across anything like this before. I am willing to provide any other info. if you need... Thank you guys for your time. ******************************************************** FIRST CRASH(Until Line Number 618): WHEN RUNNING UPDARTE STATISTICS HIGH: 1).(Until Line Number 618) 13:58:37' 13:58:37' Informix Dynamic Server Version 7.31.UD6' ' Software Serial Number AA##J###### 13:58:37' Assert Failed: No Exception Handler 13:58:37' Who: Session(0, @, 0, 0) ' ' '' ' 'Thread(5, msc vp 0, 0, 12) ' ' '' ' 'File: mtex.c Line: 471 13:58:37' Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:58:37' Action: Please notify Informix Technical Support. --------------------------------- Begin System Alarm Program Output --------------------------------- Assertion Failure Type:' ' 'CRASH Host Name:' ' '' ' 'malco Database Server Name:' ' 'malco_1 Time of failure:' ' 'Mon Sep' 6 13:58:37 GMT 2004 AF file:' ' '' ' '/tmp/af.3ede06c Shared memory file:' ' 'None System Blocking:' ' 'OFF ===========------------- - - - - - - tail -100 /var/informix/online.log: 13:39:09' Logical Log 215124 - Backup Started 13:39:10' Logical Log 215124 - Backup Completed 13:39:10' Logical Log 215125 - Backup Started 13:39:10' Logical Log 215125 - Backup Completed 13:39:10' Logical Log 215126 - Backup Started 13:39:10' Logical Log 215126 - Backup Completed 13:39:10' Logical Log 215127 - Backup Started 13:39:11' Logical Log 215127 - Backup Completed 13:39:39' Checkpoint Completed:' duration was 1 seconds. 13:39:39' Checkpoint loguniq 215128, logpos 0x6f018 ... 13:49:41' Checkpoint Completed:' duration was 1 seconds. 13:49:41' Checkpoint loguniq 215142, logpos 0x1a0018 13:49:54' Logical Log 215142 Complete. 13:49:56' Logical Log 215142 - Backup Started .......... 13:53:36' Logical Log 215147 - Backup Completed 13:54:10' Logical Log 215148 Complete. 13:54:11' Logical Log 215148 - Backup Started 13:54:11' Logical Log 215148 - Backup Completed 13:54:19' Dynamically allocated new virtual shared memory segment (size 65536KB) 13:54:28' Dynamically allocated new virtual shared memory segment (size 65536KB) 13:54:43' Checkpoint Completed:' duration was 2 seconds. 13:54:43' Checkpoint loguniq 215149, logpos 0x28204 13:55:43' Logical Log 215149 Complete. 13:55:46' Logical Log 215149 - Backup Started 13:55:46' Logical Log 215149 - Backup Completed 13:55:50' Dynamically allocated new virtual shared memory segment (size 65536KB) 13:56:20' Dynamically allocated new virtual shared memory segment (size 65536KB) 13:58:30' Logical Log 215150 Complete. 13:58:31' Logical Log 215150 - Backup Started 13:58:31' Logical Log 215150 - Backup Completed 13:58:37' Assert Failed: No Exception Handler 13:58:37' Informix Dynamic Server Version 7.31.UD6' ' 13:58:37' Who: Session(0, @, 0, 0) ' ' '' ' 'Thread(5, msc vp 0, 0, 12) ' ' '' ' 'File: mtex.c Line: 471 13:58:37' Results: Exception Caught. Type: MT_EX_OS, Context: mem 13:58:37' Action: Please notify Informix Technical Support. ===========------------- - - - - - - /usr/informix/bin/onstat -g ath: Informix Dynamic Server Version 7.31.UD6' ' -- On-Line -- Up 09:23:05 -- 1896196 Kbytes Threads: tid' ' tcb' ' ' rstcb' ' prty status' ' ' ' ' ' ' ' vp-class' ' ' name 2' ' ' 838ed730 0' ' ' ' 2' ' sleeping forever' ' ' ' 9lio' ' ' ' lio vp 0 3' ' ' 838ed9c8 0' ' ' ' 2' ' sleeping forever' ' ' 10pio' ' ' ' pio vp 0 4' ' ' 838edc60 0' ' ' ' 2' ' running' ' ' ' ' ' ' ' 11aio' ' ' ' aio vp 0 *5' ' ' 838f4130 0' ' ' ' 2' ' running' ' ' ' ' ' ' ' 12msc' ' ' ' msc vp 0 6' ' ' 838f4330 0' ' ' ' 2' ' sleeping forever' ' ' 13aio' ' ' ' aio vp 1 7' ' ' 838f4558 0' ' ' ' 2' ' sleeping forever' ' ' 14aio' ' ' ' aio vp 2 8' ' ' 838f47f0 0' ' ' ' 2' ' sleeping forever' ' ' 15aio' ' ' ' aio vp 3 9' ' ' 838f4a88 0' ' ' ' 2' ' sleeping forever' ' ' 16aio' ' ' ' aio vp 4 10' ' ' 838f4d20 0' ' ' ' 2' ' sleeping forever' ' ' 17aio' ' ' ' aio vp 5 11' ' ' 838f4fb8 0' ' ' ' 2' ' sleeping forever' ' ' 18aio' ' ' ' aio vp 6 12' ' ' 838f5250 0' ' ' ' 2' ' sleeping forever' ' ' 19aio' ' ' ' aio vp 7 13' ' ' 838f54e8 0' ' ' ' 2' ' sleeping forever' ' ' 20aio' ' ' ' aio vp 8 14' ' ' 838f5780 0' ' ' ' 2' ' sleeping forever' ' ' 21aio' ' ' ' aio vp 9 15' ' ' 838f5a18 0' ' ' ' 2' ' sleeping forever' ' ' 22aio' ' ' ' aio vp 10 16' ' ' 838f5e58 0' ' ' ' 2' ' sleeping forever' ' ' 23aio' ' ' ' aio vp 13 17' ' ' 838f5cb0 0' ' ' ' 2' ' sleeping forever' ' ' 24aio' ' ' ' aio vp 11 18' ' ' 83915458 0' ' ' ' 2' ' sleeping f