|
Problem IT39315
|
Status: Closed |
POTENTIAL MEMORY LEAK IN A SP ENV WHEN DYNAMIC SQL WITH CURSOR IS USED AND SQL ERRORS OCCURED IN THE SPL FLOW
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
There is a application environment calling in a loop SPs in a
very long session life time.
The SP is called within a cursor using resume and is using in a
simplified environment an
prepared statement with a cursor on top.
Given in the SP flow an SQL error occured e.g
LET _sql_stmt = "an valid SQL statement";
PREPARE stmt FROM _sql_stmt;
DECLARE cursor cursor FOR stmt;
OPEN cursor;
return "before FETCH" with resume;
-- something happened here generating an error
FETCH cursor INTO status;
return "before FREE" with resume;
CLOSE cursor;
FREE cursor;
FREE stmt;
return status;
Using this logic again and and again in every case an error
occured, the memory allocated in the
cursor and the dynamic statement cannot be freed and is
accumulated in the RALLOC part of the
session. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC8. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC8. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC8. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC8. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC8. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.12.2021
07.04.2022
07.04.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
