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) |