| Latest versions | fixlist |
| 14.10.xC10 |
 |
| 12.10.xC16.X5 |
|
| 11.70.xC9.XB |
|
| 11.50.xC9.X2 |
|
| 11.10.xC3.W5 |
|
| Have problems? - contact us. | |
| Register for free |
|
| Contact form |
|
Informix - Problem description
| 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 |
|
