| 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 IT34088 | Status: Closed |
INCREASED SESSION MEMORY USAGE DUE TO STATEMENTS INSIDE STORED PROCEDURES NOT BEING FREED | |
| product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
| Problem description: | |
t appears that statement descriptor blocks for statements inside
stored procedures may not be getting freed correctly. This can
be seen via large amounts of statements in the onstat -g stm
output for a session, along with increased memory usage for the
session.
onstat -g stm:
IBM Informix Dynamic Server Version 12.10.FC12W1XQ -- On-Line --
Up 00:00:49 -- 549724 Kbytes
session 9
---------------------------------------------------------------
sdblock heapsz flags statement ('*' = Open cursor)
461bf028 7712 ----- *execute procedure p1()
461bf2e0 7712 ----- *execute procedure p1()
461bf598 13024 -----
461bf850 12968 -----
461bfb08 12968 -----
461bfdc0 13000 -----
461c0078 12992 -----
461c0330 12968 -----
461c05e8 12992 -----
461c08a0 12968 -----
461c0b58 12968 -----
461c0e10 12968 -----
461c10c8 12968 -----
461c1380 12968 -----
461c1638 12968 -----
461c18f0 12968 -----
4643f028 12992 -----
4643f2e0 12992 -----
4643f598 12992 -----
4643f850 12968 -----
4643fb08 12968 -----
4643fdc0 12968 -----
46440078 12968 -----
46440330 12968 -----
464405e8 12968 -----
464408a0 12968 -----
46440b58 12968 -----
46440e10 12992 -----
464410c8 12968 -----
46441380 12968 -----
46441638 12968 -----
464418f0 12968 -----
465f5028 13016 -----
465f52e0 12968 -----
465f5598 12968 -----
... | |
| Problem Summary: | |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* It appears that statement descriptor blocks for statements *
* inside *
* stored procedures may not be getting freed correctly. This *
* can *
* be seen via large amounts of statements in the onstat -g stm *
* output for a session, along with increased memory usage for *
* the *
* session. *
* *
* onstat -g stm: *
* *
* IBM Informix Dynamic Server Version 12.10.FC12W1XQ -- *
* On-Line -- *
* Up 00:00:49 -- 549724 Kbytes *
* *
* session 9 *
* ------------------------------------------------------------ *
* --- *
* sdblock heapsz flags statement ('*' = Open *
* cursor) *
* 461bf028 7712 ----- *execute procedure p1() *
* 461bf2e0 7712 ----- *execute procedure p1() *
* 461bf598 13024 ----- *
* 461bf850 12968 ----- *
* 461bfb08 12968 ----- *
* 461bfdc0 13000 ----- *
* 461c0078 12992 ----- *
* 461c0330 12968 ----- *
* 461c05e8 12992 ----- *
* 461c08a0 12968 ----- *
* 461c0b58 12968 ----- *
* 461c0e10 12968 ----- *
* 461c10c8 12968 ----- *
* 461c1380 12968 ----- *
* 461c1638 12968 ----- *
* 461c18f0 12968 ----- *
* 4643f028 12992 ----- *
* 4643f2e0 12992 ----- *
* 4643f598 12992 ----- *
* 4643f850 12968 ----- *
* 4643fb08 12968 ----- *
* 4643fdc0 12968 ----- *
* 46440078 12968 ----- *
* 46440330 12968 ----- *
* 464405e8 12968 ----- *
* 464408a0 12968 ----- *
* 46440b58 12968 ----- *
* 46440e10 12992 ----- *
* 464410c8 12968 ----- *
* 46441380 12968 ----- *
* 46441638 12968 ----- *
* 464418f0 12968 ----- *
* 465f5028 13016 ----- *
* 465f52e0 12968 ----- *
* 465f5598 12968 ----- *
* ... *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** | |
| Local Fix: | |
| Solution | |
| Workaround | |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* It appears that statement descriptor blocks for statements *
* inside *
* stored procedures may not be getting freed correctly. This *
* can *
* be seen via large amounts of statements in the onstat -g stm *
* output for a session, along with increased memory usage for *
* the *
* session. *
* *
* onstat -g stm: *
* *
* IBM Informix Dynamic Server Version 12.10.FC12W1XQ -- *
* On-Line -- *
* Up 00:00:49 -- 549724 Kbytes *
* *
* session 9 *
* ------------------------------------------------------------ *
* --- *
* sdblock heapsz flags statement ('*' = Open *
* cursor) *
* 461bf028 7712 ----- *execute procedure p1() *
* 461bf2e0 7712 ----- *execute procedure p1() *
* 461bf598 13024 ----- *
* 461bf850 12968 ----- *
* 461bfb08 12968 ----- *
* 461bfdc0 13000 ----- *
* 461c0078 12992 ----- *
* 461c0330 12968 ----- *
* 461c05e8 12992 ----- *
* 461c08a0 12968 ----- *
* 461c0b58 12968 ----- *
* 461c0e10 12968 ----- *
* 461c10c8 12968 ----- *
* 461c1380 12968 ----- *
* 461c1638 12968 ----- *
* 461c18f0 12968 ----- *
* 4643f028 12992 ----- *
* 4643f2e0 12992 ----- *
* 4643f598 12992 ----- *
* 4643f850 12968 ----- *
* 4643fb08 12968 ----- *
* 4643fdc0 12968 ----- *
* 46440078 12968 ----- *
* 46440330 12968 ----- *
* 464405e8 12968 ----- *
* 464408a0 12968 ----- *
* 46440b58 12968 ----- *
* 46440e10 12992 ----- *
* 464410c8 12968 ----- *
* 46441380 12968 ----- *
* 46441638 12968 ----- *
* 464418f0 12968 ----- *
* 465f5028 13016 ----- *
* 465f52e0 12968 ----- *
* 465f5598 12968 ----- *
* ... *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 12.10.xC15 (when available) or *
* 14.10.xC5. *
**************************************************************** | |
| Comment | |
Fixed in Informix Server 12.10.xC15 and 14.10.xC5. | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 02.09.2020 28.01.2021 28.01.2021 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
