IDs tries to allocate virtual memro segments
Posted in 2011
Hi,
We are using IDS V11.50.FC8 on HP and we have a strange behavior.
The engine tries to allocate virtual segments non stop.
The engine has been running since the end of April without any problems.
The engine allocated a bunch of virtual memory segments until it reached
the max at the kernel level.
The users use the same application. The DBA activated SQLTRACE and
stopped it. He is saying that the memory allocation started about the
same time he activated SQLTRACE. I asked him to stop SQLTRACE, which he did.
We tried "*onmode -F*" to free unused segments, but nothing really
happened. *onstat -g seg* shows that all of the segments are really used
(blkfree column shows 6).
We used *onstat -g mem* and noticed the following: (part of the output)
704239*O0 V c0000000eafdd040 4096 800
1 1
705661*O0 V c0000000e0844040 4096 800
1 1
1171107 V c0000000e140a040 561152 214080
913 64
_*sqlhistory*_ V c0000000eaa8f040 _*4556992512*_
3528 44496 2
1177002 V c0000000d744b040 671744 324552
951 81
1170820 V c0000000e6705040 622592 257752
933 73
We stopped SQLTRACE and restarted it with a buffer of 1000 instructions
only. The engine allocated a new sqlhistory memory pool and did not
clear the previous one. We stopped SQLTARCE again, and the second memory
pool allocated disappeared.
It looks like the engine tried to allocated sqlhistory memory and was
bloqued by the kernel limitations as far as max segments.
So we are stuck unless we nounce the engine. The application is very
critical and cannot be stopped at all unless there is a disaster.
IS THERE A WAY TO FREE THE SQLHISTORY?
Here is part of the online.log file:
12:03:04 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:04 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:04 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:05 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:05 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:05 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:05 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
12:03:05 A new shared memory segment could not be added because of the
OS limit of 50 segments for KAIO.
--
Khaled Bentebal
Mobile: 33 (0) 6 07 78 41 97
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr