|
Problem IT09544
|
Status: Closed |
ONSTAT -G SES REPORTS SESSION POOL OPENTABLE MEMORY LEAK WHEN RUNNING QUERIES WHICH REQUIRE AUTO-INDEX PATH QUERY PLANS |
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
This problem appears to be new in 12.10.FC5 (as it did not
reproduce in 12.10.FC4).
Query plan for the query being run repeatedly is as follows
(showing it's using auto-index path)
select {+ ORDERED, AVOID_HASH(t2), AVOID_FULL(t2) } *
from t1,t2
where t1.c1 = 1 and t1.c2 = 5 and
t1.c2 = t2.c2
DIRECTIVES FOLLOWED:
ORDERED
AVOID_HASH ( t2 )
AVOID_FULL ( t2 )
DIRECTIVES NOT FOLLOWED:
Estimated Cost: 7
Estimated # of Rows Returned: 2
1) jrenaut.t1: INDEX PATH
(1) Index Name: jrenaut.t1_idx1
Index Keys: c1 c2 c3 (Key-Only) (Serial, fragments:
ALL)
Lower Index Filter: (jrenaut.t1.c2 = 5 AND jrenaut.t1.c1
= 1 )
2) jrenaut.t2: AUTOINDEX PATH
(1) Index Name: (Auto Index)
Index Keys: c2
Lower Index Filter: jrenaut.t1.c2 = jrenaut.t2.c2
NESTED LOOP JOIN
Then if you use onstat -g ses <session id> to monitor the
session's memory pool you will see the opentable size growing.
Sample output:
Memory pools count 3
name class addr totalsize freesize
#allocfrag #freefrag
45 V 462ec040 15519744 11314272 3935
7501
45*O0 V 461b8040 4096 768 1
1
45_SORT_0 V 4618d040 69632 52096 87
88
name free used name free
used
overhead 0 9984 scb 0
144
opentable 0 4066232 filetable 0
1232
Then to distinguish this from other opentable session growth
(like APAR IT03000) if you do onstat -g afr <session id> | grep
opentab you will see an increasing amount of lines that look
like this:
4eec1630 1080 opentable 3669 rssupp.c:224
4eec3630 1080 opentable 3669 rssupp.c:224
4eec5630 1080 opentable 3669 rssupp.c:224
4eec7630 1080 opentable 3669 rssupp.c:224
4eec9630 1080 opentable 3669 rssupp.c:224
4eecb630 1080 opentable 3669 rssupp.c:224
4eecd630 1080 opentable 3669 rssupp.c:224
4eecf630 1080 opentable 3669 rssupp.c:224
4eed1630 1080 opentable 3669 rssupp.c:224
4eed3630 1080 opentable 3669 rssupp.c:224
4eed5630 1080 opentable 3669 rssupp.c:224
4eed7630 1080 opentable 3669 rssupp.c:224
4eed9630 1080 opentable 3669 rssupp.c:224
4eedb630 1080 opentable 3669 rssupp.c:224
4eedd630 1080 opentable 3669 rssupp.c:224
4eedf630 1080 opentable 3669 rssupp.c:224
4eee1630 1080 opentable 3669 rssupp.c:224 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* IDS.12.10.xC5 users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC6 *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem Fixed In IBM Informix Server 12.10.xC6 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 18.06.2015
30.12.2015
30.12.2015 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 12.10.xC6
|
 |
