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 forever* * * 25aio* * * * aio vp 12
19* * * 839156f0 0* * * * 2* * sleeping forever* * * 26aio* * * * aio vp 14
20* * * 83915988 0* * * * 2* * sleeping forever* * * 27aio* * * * aio vp 15
21* * * 83915c20 8393a018 4* * sleeping secs: 1* * * * 5cpu* * * *
main_loop()
22* * * 83915eb8 0* * * * 2* * running* * * * * * * * 1cpu* * * * sm_poll
23* * * 83937e50 0* * * * 2* * running* * * * * * * * 3cpu* * * * sm_poll
24* * * 83e14248 0* * * * 2* * running* * * * * * * * 4cpu* * * * sm_poll
25* * * 83e14508 0* * * * 2* * running* * * * * * * * 5cpu* * * * sm_poll
26* * * 83e147c8 0* * * * 2* * running* * * * * * * * 6cpu* * * * sm_poll
27* * * 83e14a88 0* * * * 2* * running* * * * * * * * 28soc* * * *
soctcppoll
28* * * 83e14d20 0* * * * 2* * running* * * * * * * * 29soc* * * *
soctcppoll
29* * * 83e14fb8 0* * * * 3* * sleeping forever* * * * 1cpu* * * * sm_listen
30* * * 83e152b0 0* * * * 2* * sleeping secs: 2* * * * 1cpu* * * * sm_discon
31* * * 83e15548 0* * * * 3* * sleeping forever* * * * 1cpu* * * * sm_listen
32* * * 83e157e0 0* * * * 2* * sleeping secs: 2* * * * 7cpu* * * * sm_discon
33* * * 83e15a78 0* * * * 3* * sleeping forever* * * * 1cpu* * * * sm_listen
34* * * 83e15d10 0* * * * 2* * sleeping secs: 2* * * * 4cpu* * * * sm_discon
35* * * 83e18130 0* * * * 3* * sleeping forever* * * * 6cpu* * * * sm_listen
36* * * 83e18358 0* * * * 2* * sleeping secs: 2* * * * 6cpu* * * * sm_discon
37* * * 83e185f0 0* * * * 3* * sleeping forever* * * * 6cpu* * * * sm_listen
38* * * 83e18888 0* * * * 2* * sleeping secs: 2* * * * 5cpu* * * * sm_discon
39* * * 83e18b20 0* * * * 3* * sleeping forever* * * * 1cpu* * * * soctcplst
40* * * 83e18db8 0* * * * 3* * sleeping forever* * * * 3cpu* * * * soctcplst
41* * * 83e190b8 8393a514 2* * sleeping forever* * * * 6cpu* * * *
flush_sub(0)
42* * * 83e19350 8393aa10 2* * sleeping forever* * * * 7cpu* * * *
flush_sub(1)
43* * * 83e195e8 8393af0c 2* * sleeping forever* * * * 1cpu* * * *
flush_sub(2)
44* * * 83e19880 8393b408 2* * sleeping forever* * * * 5cpu* * * *
flush_sub(3)
45* * * 83e19b80 8393b904 2* * sleeping forever* * * * 7cpu* * * *
flush_sub(4)
46* * * 83e19e18 8393be00 2* * sleeping forever* * * * 8cpu* * * *
flush_sub(5)
47* * * 83e1e1f8 8393c2fc 2* * sleeping forever* * * * 4cpu* * * *
flush_sub(6)
48* * * 83e1e468 8393c7f8 2* * sleeping forever* * * * 4cpu* * * *
flush_sub(7)
49* * * 83e1e700 8393ccf4 2* * sleeping forever* * * * 7cpu* * * *
flush_sub(8)
50* * * 83e1e998 8393d1f0 2* * sleeping forever* * * * 1cpu* * * *
flush_sub(9)
.................
141* * 83e79de0 83959784 2* * sleeping forever* * * * 8cpu* * * *
flush_sub(100)
142* * 83ea81f8 83959c80 2* * sleeping forever* * * * 3cpu* * * *
flush_sub(101)
143* * 83ea8448 8395a17c 2* * sleeping forever* * * * 3cpu* * * *
flush_sub(102)
144* * 83ea86e0 8395a678 2* * sleeping forever* * * * 1cpu* * * *
flush_sub(103)
145* * 83ea8978 8395ab74 2* * sleeping forever* * * * 4cpu* * * *
flush_sub(104)
146* * 83ea8c10 8395b070 2* * sleeping forever* * * * 4cpu* * * *
flush_sub(105)
147* * 83ea8ea8 8395b56c 2* * sleeping forever* * * * 4cpu* * * *
flush_sub(106)
148* * 83ea9140 8395ba68 2* * sleeping forever* * * * 3cpu* * * *
flush_sub(107)
149* * 83ea93d8 8395bf64 3* * sleeping forever* * * * 4cpu* * * * aslogflush
150* * 83ea9670 8395c460 2* * sleeping secs: 52* * * 4cpu* * * * btclean
166* * 83ed83c8 8395d354 4* * sleeping secs: 1* * * * 1cpu* * * * onmode_mon
321* * 83f72130 8395e744 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
388* * 83f083c8 8395f638 2* * cond wait* netnorm* * * 6cpu* * * * sqlexec
470* * 83ed8130 8396191c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
487* * 8408e6c8 8395e248 2* * cond wait* netnorm* * * 6cpu* * * * sqlexec
529* * 83fce130 83960a28 2* * cond wait* netnorm* * * 5cpu* * * * sqlexec
531* * 83fd2248 8540cf0c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
556* * 83f72540 8540c514 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
557* * 83f72950 8395c95c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
577* * 83ff8130 8540d904 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
579* * 83ff87d8 8540ca10 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
580* * 83ff8a70 8395fb34 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
582* * 83ff9290 83960f24 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
586* * 83ed8a70 8540e2fc 2* * cond wait* netnorm* * * 6cpu* * * * sqlexec
590* * 8408e130 8540e7f8 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
594* * 83f20130 8540ecf4 2* * cond wait* netnorm* * * 0cpu* * * * sqlexec
663* * 83fc0540 85413cb4 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
665* * 83f38608 85412dc0 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
671* * 83ef0b20 8395f13c 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
676* * 8407c3f0 8395ce58 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
719* * 83f39170 8395dd4c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
759* * 83f38c40 854141b0 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
776* * 83f394d0 83960030 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
777* * 83fe0130 854146ac 2* * cond wait* sm_read* * * 7cpu* * * * sqlexec
782* * 8407c800 854123c8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
783* * 8407cb78 854105e0 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
788* * 83fc0a00 85411ecc 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
811* * 83ef0db8 854137b8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
829* * 83ff9a88 854114d4 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
830* * 83ff9d20 854132bc 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
840* * 83ed8d08 854100e4 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
841* * 83ed9080 854155a0 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
847* * 83fc10d8 854128c4 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
870* * 83ef1d38 854150a4 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
874* * 83ed9468 85416990 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
899* * 83f39ec8 85417d80 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
902* * 83f94330 85417884 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
903* * 83f08130 854119d0 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
907* * 83ed9890 85415f98 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
908* * 83ed9c08 85418c74 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
971* * 83f398e0 8541a064 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
980* * 83ec03c8 8541a560 2* * cond wait* netnorm* * * 3cpu* * * * sqlexec
1063* * 83f20958 8541c844 2* * sleeping secs: 4* * * * 5cpu* * * * ontape
1401* * 83ef1990 8541d23c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
1415* * 83fc17f8 8540de00 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
1428* * 84010130 8541b950 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
1474* * 83f72d60 85410fd8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
1490* * 83f50608 8541af58 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
1502* * 8408e960 8541f024 2* * cond wait* netnorm* * * 5cpu* * * * sqlexec
1576* * 83f51148 85415a9c 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
1665* * 83f21be0 85421308 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
1672* * 840104a8 85419b68 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
1703* * 84010de8 8541ff18 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
1711* * 83f73460 8541b454 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
1714* * 83f955f8 85421804 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
1727* * 83ed87d8 854226f8 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
1728* * 83f50130 85422bf4 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
1736* * 83f50398 854235ec 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
1783* * 83ed9718 85423ae8 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
1803* * 83fce3a0 8541cd40 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
1847* * 840111f8 8541eb28 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
1879* * 8408ebf8 8541c348 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
1897* * 83f20ee0 85424ed8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
1898* * 83f21258 8541f520 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
1899* * 83f215d0 85426cc0 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
1927* * 8407d330 854230f0 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
1995* * 83ef1be0 854285ac 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
1999* * 83ec0a88 8541e130 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2013* * 8408fcf8 8542a890 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
2015* * 83ef14b8 8542bc80 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2017* * 840113f8 85427bb4 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2043* * 83ef0490 85418778 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2048* * 83fcf5b8 85423fe4 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
2053* * 83f949e0 8541be4c 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
2054* * 83f94dc8 8542c678 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
2059* * 8408f6d0 85416494 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
2060* * 8408f808 85421d00 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2064* * 83fcfe70 8542b288 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
2075* * 83ff9950 8542cb74 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2094* * 83fd37c0 8542999c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2095* * 83fe0d60 8542da68 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
2096* * 83fe1128 85430c40 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2121* * 83f95060 8543252c 2* * cond wait* netnorm* * * 3cpu* * * * sqlexec
2123* * 83f952d0 85430744 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2125* * 83f21e08 85432a28 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2159* * 83fc1c48 8542df64 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2160* * 83f092a0 8542e460 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
2163* * 83fc0de8 85420910 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
2168* * 83ff8540 8730a018 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2201* * 83f51990 85419170 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
2232* * 83fd27d0 8730ccf4 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2250* * 8407db28 8730d1f0 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2271* * 83f09eb8 8730e0e4 2* * cond wait* netnorm* * * 6cpu* * * * sqlexec
2277* * 83f08840 8543391c 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2280* * 8408f460 85428fa4 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
2284* * 83ec0d20 8542f354 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
2288* * 83ec1608 8542c17c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2310* * 840108b8 873112bc 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2426* * 83fcf6f0 8730c2fc 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
2427* * 83fcea88 8542d56c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2444* * 83fc03c8 873135a0 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
2492* * 840105e0 8730f4d4 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
2673* * 83ec18b8 854271bc 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
2688* * 87ef4018 87310dc0 2* * cond wait* netnorm* * * 7cpu* * * * sqlexec
2775* * 83fd3688 8730aa10 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
3057* * 87ef4ee8 8730d6ec 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
3502* * 83f38aa0 854276b8 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
3551* * 83f513e0 8730af0c 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
3934* * 83f095e8 85433420 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
3996* * 87ef4218 873126ac 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
4420* * 85afaa08 854244e0 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
4436* * 83ed8f08 85416e8c 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
4787* * 87ef4b70 8543113c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
4834* * 83f39ae0 8731766c 2* * cond wait* netnorm* * * 6cpu* * * * sqlexec
4883* * 83f093d8 873130a4 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
5115* * 86ce38d8 8542f850 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
5332* * 884e38d0 873103c8 2* * cond wait* netnorm* * * 5cpu* * * * sqlexec
5770* * 8407d058 87319454 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
5826* * 85afae08 85420e0c 2* * cond wait* netnorm* * * 8cpu* * * * sqlexec
5914* * 85afb770 8541e62c 2* * cond wait* netnorm* * * 3cpu* * * * sqlexec
5990* * 884e3da8 85431b34 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
6002* * 86ce2018 8731d520 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
6104* * 884e3ee0 8731b738 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
6124* * 84010718 8731d024 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
6259* * 878758c8 8730be00 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
6401* * 84011df8 87317170 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
6433* * 83ef1340 0* * * * 2* * sleeping forever* * * 30aio* * * * aio vp 16
6501* * 86ce27e0 8731f804 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
6530* * 83fe1a68 8731da1c 2* * cond wait* netnorm* * * 1cpu* * * * sqlexec
6583* * 85afbd80 8731a348 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
6593* * 87ef4640 8730f9d0 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
6841* * 83ef0268 87311cb4 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
6983* * 83f20330 873201fc 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
7082* * 8407cde8 8731bc34 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
7096* * 8408edf8 854221fc 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
7147* * 884e3100 8730dbe8 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
7237* * 878745f8 87319950 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7429* * 884e27e8 854262c8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
7466* * 83fcf228 8730b408 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
7516* * 85afa890 8731b23c 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
7555* * 85afbb60 8731627c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
7615* * 85afbeb8 8542ad8c 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
7698* * 87874a60 8541827c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
7771* * 83fe1538 873121b0 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
7793* * 87875a00 8540f6ec 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
7794* * 83f50c88 85429e98 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7809* * 86ce2308 8730e5e0 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7816* * 83f50878 8540fbe8 2* * cond wait* sm_read* * * 8cpu* * * * sqlexec
7818* * 83f946a8 854294a0 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
7941* * 83fc1eb8 8731f308 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
7956* * 83fe17d0 87316778 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
7958* * 83ff8ff8 8542fd4c 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7959* * 878742a0 8730efd8 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
7978* * 83ef1768 87318f58 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7980* * 86ce3a68 8731cb28 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
7990* * 884e36a0 85425dcc 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8102* * 87ef59a0 8541aa5c 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8131* * 86ce3468 87312ba8 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8185* * 83f73d20 854267c4 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8190* * 884e2920 8541966c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8218* * 83ec1d18 8731df18 2* * cond wait* netnorm* * * 4cpu* * * * sqlexec
8258* * 884e2190 8730fecc 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8259* * 8833a130 87313a9c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8262* * 83fe0620 85432f24 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8326* * 87875630 8730a514 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8351* * 83f20718 8731e910 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8383* * 8833add8 8731ee0c 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8398* * 83fce518 8730c7f8 2* * running* * * * * * * * 3cpu* * * * sqlexec
8399* * 86ce3608 8731c130 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8435* * 83fd3180 8396052c 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8437* * 8833b1a0 8731ad40 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8442* * 8833abc8 8542a394 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8507* * 87ef5020 8730b904 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8510* * 87ef5e20 8541d738 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8515* * 83ec1e78 8540f1f0 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8520* * 83fc0b38 8540c018 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8547* * 83f723c8 854280b0 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8566* * 84010c58 8731c62c 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8628* * 8833a890 87314494 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8637* * 83fc0130 8395ec40 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8639* * 87874018 873117b8 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8650* * 83fc1588 87318a5c 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8652* * 878750b0 8541dc34 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8653* * 884e2e38 85414ba8 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8658* * 83f09720 8730eadc 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8722* * 83ef0130 873215ec 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8730* * 85afb970 8731e414 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8735* * 83f94130 8542ee58 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8747* * 87ef4d70 87314e8c 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8781* * 83fcf388 87315d80 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8797* * 86ce2640 873108c4 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8818* * 8833a268 854258d0 2* * cond wait* sm_read* * * 5cpu* * * * sqlexec
8826* * 884e2488 83961420 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8834* * 86ce3ea8 85417388 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8844* * 83ff8e80 854253d4 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8864* * 83fe1d00 85420414 2* * cond wait* sm_read* * * 1cpu* * * * sqlexec
8865* * 83ec07f0 87318064 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8866* * 83f09d40 85431638 2* * cond wait* sm_read* * * 4cpu* * * * sqlexec
8867* * 8833b8b8 87313f98 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8874* * 83f51ac8 8542d070 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec
8879* * 878754b8 8541fa1c 2* * cond wait* sm_read* * * 3cpu* * * * sqlexec
8881* * 83ff9130 854249dc 2* * cond wait* sm_read* * * 6cpu* * * * sqlexec

===========------------- - - - - - -
/usr/informix/bin/onstat -g stk 5 light:

Informix Dynamic Server Version 7.31.UD6* * -- On-Line -- Up 09:23:05 --
1896196 Kbytes

Stack for thread: 5 msc vp 0
base: 0x83e84000
* len:* 139264
* pc: 0x0834feb6
* tos: 0x83ea51f8
state: running
* vp: 12

0x0834feb6 (***nosymtab***)0x834feb6(0x83ea564c, 0x838f41b8, 0x80c45b0,
0x88672938, 0x83ea554c, 0x0)
0x08366e45 (***nosymtab***)0x8366e45(0x3, 0x853158f, 0x83ea58c0, 0x8602dfc8,
0x201, 0x8531588)
0x083669a7 (***nosymtab***)0x83669a7(0x853158f, 0x83ea58c0, 0x8602dfc8,
0x8531588, 0x1d7, 0x83ea58c0)
0x0836958d (***nosymtab***)0x836958d(0x1, 0x84b3ad4, 0x0, 0xb, 0x80c45b0,
0x83ea5d0c)
0x080c45cd (***nosymtab***)0x80c45cd(0xb, 0x0, 0x0, 0x2b, 0xc010002b,
0x88672938)
0x400ab958 (***nosymtab***)0x400ab958(0x88672938, 0x4, 0x2, 0x401b6c64,
0x8588ec8, 0x400)
0x4017b6cb (***nosymtab***)0x4017b6cb(0x88672938, 0x4, 0x2, 0x83ea5ea0,
0x83b7658, 0x88672938)
0x083b76a1 (***nosymtab***)0x83b76a1(0x88672938, 0x4, 0x2, 0x83ea5e8c,
0x83ea5d8c, 0x83da5dbc)
0x083b7658 (***nosymtab***)0x83b7658(0x88672830, 0x83da5dbc, 0x83da5d70,
0x83da7848, 0x0, 0x78)
0x08358718 (***nosymtab***)0x8358718(0x83da7848, 0x83da5dbc, 0x83da5d70,
0x83da5d70, 0x83da7848, 0x0)
0x08358aef (***nosymtab***)0x8358aef(0x83da7848, 0x83da5d70, 0x83da5d70,
0x0, 0x7, 0x83ea5ff8)
0x08358be4 (***nosymtab***)0x8358be4(0x83da7848, 0x0, 0x0, 0x0, 0x0, 0x28)
0x08351719 (***nosymtab***)0x8351719(0x28, 0x83ea8118, 0x83e79f98, 0x2118,
0x7d241c9, 0x0)
0x00000000 (***nosymtab***)0x0




===========------------- - - - - - -
/usr/informix/bin/onstat -c:

Informix Dynamic Server Version 7.31.UD6* * -- On-Line -- Up 09:23:06 --
1896196 Kbytes

Configuration File: /usr/informix/etc/onconfig.malco
#************************************************* *************************
#
#* * ** * ** * ** INFORMIX SOFTWARE, INC.
#
#* Title:* * *onconfig.std
#* Description: Informix Dynamic Server Configuration Parameters
#
#************************************************* *************************

# Root Dbspace Configuration

ROOTNAME* * * * rootdbs* * * * # Root dbspace name
ROOTPATH* * * * /usr/informix/data/db01
* * * * * * * * * * * * * * * * # Path for device containing root dbspace
ROOTOFFSET* * * 2* * * * * * * # Offset of root dbspace into device (Kbytes)
ROOTSIZE* * * * 1048576* * * * # Size of root dbspace (Kbytes)

# Disk Mirroring Configuration Parameters

MIRROR* * * * * 0* * * * * * * # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH* * * * * * * * * * * # Path for device containing mirrored root
MIRROROFFSET* * 0* * * * * * * # Offset into mirrored device (Kbytes)

# Physical Log Configuration

PHYSDBS* * * * plogdbs* * * * # Location (dbspace) of physical log
PHYSFILE* * * * 262140* * * * * # Physical log file size (Kbytes)

# Logical Log Configuration

LOGFILES* * * * 510* * * * * * # Number of logical log files
LOGSIZE* * * * 1024* * * * * * # Logical log size (Kbytes)

# Diagnostics

MSGPATH* * * * /var/informix/online.log # System message log file path
CONSOLE* * * * /dev/tty1* * * # System console message path
ALARMPROGRAM* * /usr/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /usr/informix/etc/evidence.sh # System Alarm program path
TBLSPACE_STATS* 1* * * * * * *

# System Archive Tape Device

TAPEDEV* * * * /dev/st0* * * * # Tape device path* * *
#TAPEDEV* * * * /dev/null* * * # Tape device path* * *
TAPEBLK* * * * 512* * * * * * # Tape block size (Kbytes)
TAPESIZE* * * * 100000000* * * # Maximum amount of data to put on tape
(Kbytes)

# Log Archive Tape Device

LTAPEDEV* * * * /dev/st0* * * * # Log tape device path
#LTAPEDEV* * * * /dev/null* * * # Log tape device path
LTAPEBLK* * * * 512* * * * * * # Log tape block size (Kbytes)
LTAPESIZE* * * 100000000* * * # Max amount of data to put on log tape
(Kbytes)

# Optical

STAGEBLOB* * * * * * * * * * * # Informix Dynamic Server/Optical staging
area

# System Configuration

SERVERNUM* * * 1* * * * * * * # Unique id corresponding to a Dynamic Server
instance
DBSERVERNAME* * malco_1* * * # Name of default database server
DBSERVERALIASES malco_2,mallive* * * # List of alternate dbservernames
NETTYPE* * * * ipcshm,5,50,CPU # Configure poll thread(s) for nettype
NETTYPE* * * * soctcp,2,25,NET # Configure poll thread(s) for nettype
DEADLOCK_TIMEOUT 30* * * * * * * # Max time to wait of lock in distributed
env.
RESIDENT* * * * 1* * * * * * * # Forced residency flag (Yes = 1, No = 0)

MULTIPROCESSOR* 1* * * * * * * # 0 for single-processor, 1 for
multi-processor
NUMCPUVPS* * * 7* * * * * * * # Number of user (cpu) vps
SINGLE_CPU_VP* 0* * * * * * * # If non-zero, limit number of cpu vps to one

NOAGE* * * * * 0* * * * * * * # Process aging
AFF_SPROC* * * * * * * * * * * # Affinity start processor
AFF_NPROCS* * * * * * * * * * # Affinity number of processors

# Shared Memory Parameters

#LOCKS* * * * * 65536* * * * * # Maximum number of locks
LOCKS* * * * * 250000* * * * *
BUFFERS* * * * 393216* * * * * # Maximum number of shared buffers
NUMAIOVPS* * * 16* * * * * * * # Number of IO vps
PHYSBUFF* * * * 96* * * * * * * # Physical log buffer size (Kbytes)
LOGBUFF* * * * 32* * * * * * * # Logical log buffer size (Kbytes)
LOGSMAX* * * * 512* * * * * * # Maximum number of logical log files
CLEANERS* * * * 108* * * * * * * # Number of buffer cleaner processes
SHMBASE* * * * 0x50000000* * * # Shared memory base address
SHMVIRTSIZE* * 262144* * * * * # initial virtual shared memory segment size
SHMADD* * * * * 65536* * * * * # Size of new shared memory segments (Kbytes)
SHMTOTAL* * * * 2048000* * * * # Total shared memory (Kbytes). 0=>unlimited
CKPTINTVL* * * 300* * * * * * # Check point interval (in sec)
LRUS* * * * * * 128* * * * * * # Number of LRU queues
LRU_MAX_DIRTY* 2* * * * * * * # LRU percent dirty begin cleaning limit
LRU_MIN_DIRTY* 1* * * * * * * # LRU percent dirty end cleaning limit
LTXHWM* * * * * 40* * * * * * * # Long transaction high water mark
percentage
LTXEHWM* * * * 60* * * * * * * # Long transaction high water mark
(exclusive)
TXTIMEOUT* * * 0x12c* * * * * * # Transaction timeout (in sec)
STACKSIZE* * * 32* * * * * * * # Stack size (Kbytes)

# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration parameter.
#* * * * * * To determine the page size used by Dynamic Server on your
platform
#* * * * * * see the last line of output from the command, 'onstat -b'.


# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.

OFF_RECVRY_THREADS 10* * * * * * * # Default number of offline worker
threads
ON_RECVRY_THREADS 1* * * * * * * # Default number of online worker threads

# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO* * * * * 0* * * * * * * # DR automatic switchover
DRINTERVAL* * * 30* * * * * * * # DR max time between DR buffer flushes (in
sec)
DRTIMEOUT* * * 30* * * * * * * # DR network timeout (in sec)
DRLOSTFOUND* * /usr/informix/etc/dr.lostfound # DR lost+found file path

# CDR Variables
CDR_LOGBUFFERS* 2048* * * * * * # size of log reading buffer pool (Kbytes)
CDR_EVALTHREADS 1,2* * * * * * # evaluator threads (per-cpu-vp,additional)
CDR_DSLOCKWAIT* 5* * * * * * * # DS lockwait timeout (seconds)
CDR_QUEUEMEM* * 4096* * * * * * # Maximum amount of memory for any CDR queue
(Kbytes)

# Backup/Restore variables
BAR_ACT_LOG* * /tmp/bar_act.log
BAR_MAX_BACKUP* 0* * * * * * *
BAR_RETRY* * * 1* * * * * * *
BAR_NB_XPORT_COUNT 10* * * * * * *
BAR_XFER_BUF_SIZE 31* * * * * * *

# Informix Storage Manager variables
ISM_DATA_POOL* ISMData* * * * # If the data pool name is changed, be sure to
* * ** * ** * ** * *# update $INFORMIXDIR/bin/onbar.* Change to
* * ** * ** * ** * *# ism_catalog -create_bootstrap -pool <new name>
ISM_LOG_POOL* * ISMLogs* * * *

# Read Ahead Variables
RA_PAGES* * * * * * * * * * * # Number of pages to attempt to read ahead
RA_THRESHOLD* * * * * * * * * # Number of pages left before next group

# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables etc.
# If specified it must be a colon separated list of dbspaces that exist
# when the Dynamic Server system is brought online.* If not specified, or if
# all dbspaces specified are invalid, various ad hoc queries will create
# temporary files in /tmp instead.

DBSPACETEMP* * tem1dbs,tmp2dbs,tmp3dbs,tmp4dbs # Default temp dbspaces

# DUMP*:
# The following parameters control the type of diagnostics information which
# is preserved when an unanticipated error condition (assertion failure)
occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.

DUMPDIR* * * * /tmp* * * * * * # Preserve diagnostics in this directory
DUMPSHMEM* * * 1* * * * * * * # Dump a copy of shared memory
DUMPGCORE* * * 0* * * * * * * # Dump a core image using 'gcore'
DUMPCORE* * * * 0* * * * * * * # Dump a core image (Warning:this aborts
Dynamic Server)
DUMPCNT* * * * 1* * * * * * * # Number of shared memory or gcore dumps for
* * ** * ** * ** * *# a single user's session

FILLFACTOR* * * 90* * * * * * * # Fill factor for building indexes

# method for Dynamic Server to use when determining current time
USEOSTIME* * * 0* * * * * * * # 0: use internal time(fast), 1: get time from
OS(slow)

# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 80* * * * * * * # Maximum allowed pdqpriority
DS_MAX_QUERIES* * * * * * * * * # Maximum number of decision support queries
DS_TOTAL_MEMORY* * * * * * * * # Decision support memory (Kbytes)
DS_MAX_SCANS* * 1048576* * * * # Maximum number of decision support scans* *
*
DATASKIP* * * * off* * * * * * # List of dbspaces to skip

# OPTCOMPIND
# 0 => Nested loop joins will be preferred (where
#* * * possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
#* * * "repeatable read", optimizer behaves as in (2)
#* * * below.* Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
#* * * mode.* Nested loop joins are not necessarily
#* * * preferred.* Optimizer bases its decision purely
#* * * on costs.
OPTCOMPIND* * *2* * * * * * * * * * # To hint the optimizer

ONDBSPACEDOWN* 2* * * * * * * # Dbspace down option: 0 = CONTINUE, 1 =
ABORT, 2 = WAIT
LBU_PRESERVE* * 1* * * * * * * # Preserve last log for log backup
OPCACHEMAX* * * 0* * * * * * * # Maximum optical cache size (Kbytes)

# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT* 0* * * * * * *

# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL* * * * -1* * * * * * *

# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES* * * 1* * * * * * *

# Status of restartable restore
RESTARTABLE_RESTORE off* * * * * *
CDR_LOGDELTA* * 30* * * * * * * # % of log space allowed in queue memory
CDR_NUMCONNECT* 16* * * * * * * # Expected connections per server
CDR_NIFRETRY* * 300* * * * * * # Connection retry (seconds)
CDR_NIFCOMPRESS 0* * * * * * * # Link level compression (-1 never, 0 none, 9
max)
BAR_DEBUG_LOG* /tmp/bar_dbug.log # ON-Bar Debug Log - not in /tmp please


************************************************** ******
2).

SECOND CRASH: WHEN TRYING TO INCREASE SHARED MEMORY BEYOND 1896GB.



04:36:38* Informix Dynamic Server Version 7.31.UD6* * Software Serial Number
AA##J######

04:36:38* Assert Failed: Internal error: embedded mutex, name = support

04:36:38* Who: Session(0, @, 0, 0)
* * ** * *Thread(1, main_thread, 0, 1)
* * ** * *File: mt.c Line: 6532

---------------------------------
Begin System Alarm Program Output
---------------------------------

Assertion Failure Type:* * *CRASH
Host Name:* * ** * *malco
Database Server Name:* * *NULL
Time of failure:* * *Fri Sep 10 04:36:38 GMT 2004
AF file:* * ** * */tmp/af.3e9a2b6
Shared memory file:* * *None
System Blocking:* * *OFF


===========------------- - - - - - -
onstat -m:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ath:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g stk 1 light:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -c:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -u:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -s:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -k:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -b:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -t:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -d:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -l:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -p:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -x:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -f:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -h:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -C:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -F:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -R:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g glo:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g qst:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g wst:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g spi:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g lmx:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g wmx:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g con:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g stk all:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g mem:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g seg:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g rbm:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g nbm:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g dic:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g dsc:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g prc:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g cac:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g sch:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g pos:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ioa:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g nta:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g nsd:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g nsc:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g nss:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g sts:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ses:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g sql:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g stq:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g opn:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g dri:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ppf:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g tpf:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g tgp:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g pgp:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g mgm:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g smb s:


===========------------- - - - - - -
/usr/informix/bin/onstat -g smb c:


===========------------- - - - - - -
/usr/informix/bin/onstat -g lsc:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g lap:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ddr:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g dis:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g arc:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g dll:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g sym:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
/usr/informix/bin/onstat -g ras:
onstat: Cannot attach to shared memory. errno = 43


===========------------- - - - - - -
Environment Variables:

As above

===========------------- - - - - - -
/usr/informix/bin/oninit -V:
Informix Dynamic Server Version 7.31.UD6* * Software Serial Number
AA##J######
Mon Mar 10 19:14:47 CET 2003


===========------------- - - - - - -
/usr/informix/bin/onstat -V:
Informix Dynamic Server Version 7.31.UD6* * Software Serial Number
AA##J######


===========------------- - - - - - -
/usr/informix/bin/oncheck -V:
Informix Dynamic Server Version 7.31.UD6* * Software Serial Number
AA##J######


===========------------- - - - - - -
/usr/informix/bin/onmode -V:
Informix Dynamic Server Version 7.31.UD6* * Software Serial Number
AA##J######


===========------------- - - - - - -
uname -a:
Linux malco 2.4.9-e.3smp #1 SMP Fri May 3 16:48:54 EDT 2002 i686 unknown


-------------------------------
End System Alarm Program Output
-------------------------------

04:36:39* sh /usr/informix/etc/evidence.sh 3 0 /tmp/af.3e9a2b6 0 0x0 1
0x401d02f8 513 0 0 0 0
04:36:39* See Also: /tmp/af.3e9a2b6, shmem.3e9a2b6.0
04:36:42* Error writing '/tmp/shmem.3e9a2b6.0' errno = 14
04:36:42*
------------------ End of assertion failure 0 -----------------

==================

This is memory allocation.

cat /proc/meminfo
* * * * total:* * used:* * free:* shared: buffers:* cached:
Mem:* 3692048384 2287001600 1405046784 1521373184 107352064 151183360
Swap: 2146754560* * * * 0 2146754560
MemTotal:* * * 3605516 kB
MemFree:* * * 1372116 kB
MemShared:* * 1485716 kB
Buffers:* * * * 104836 kB
Cached:* * * * 147640 kB
SwapCached:* * * * * 0 kB
Active:* * * * 136932 kB
Inact_dirty:* 1601260 kB
Inact_clean:* * * * 0 kB
Inact_target:* 917488 kB
HighTotal:* * 2752448 kB
HighFree:* * * 699988 kB
LowTotal:* * * 853068 kB
LowFree:* * * * 672128 kB
SwapTotal:* * 2096440 kB
SwapFree:* * * 2096440 kB
BigPagesFree:* * * * 0 kB








On Mon, 13 Sep 2004 Jean Georges Perrin wrote :
>Hi,
>
>
>
>I do not why it did not publish. Check that you are subscrined to the right
>list, allow 24 hrs delay when you update your subscription. Avoid sending
>HTML mail.
>
>
>
>Do not hesitate to come back to me if it occurs again.
>
>
>
>Hih
>
>
>
>Jean Georges
>
>
>
>* _____
>
> From: None [mailto:myinformix@rediffmail.com]
>Sent: Monday, September 13, 2004 14:43
>To: informix-list-manager@iiug.org
>Subject: Informix IDS query to the Informix -list
>
>
>
>
>Dear Sir/Madam,
>
>Recently I sent an email to Informix list seeking help on an IDS related
>issue. My IIUG member id is 21859 and name is "SPUTNIK".
>Is there a particular reason why you didn't publish that in the list?
>Please let me know the status of my email request to IIUG.
>This was sent on 10/09/2004 to Linux-Informix and Informix -list forums.
>
>
>Kind regards,
>Sputnik.
>
>
>
>




sending to informix-list