Informix - Problem description
Problem IT33797 | Status: Closed |
MEMORY LEAK IN SQALLOC.C:1949 WHEN RUNNING JAVA PROG PERFORMING INSERTS & UPDATES WHERE PLACEHOLDERS MATCH THE COMPOSITE INDEX | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Situation: long running sessions which perform inserts and updates. If the where clause uses the columns of the composite index, then a memory leak is observed. This can be seen if the engine is started with "RALLOC_MODE POOL" and the program paused every 1000 iterations â ¦ onstat -g mem | grep ^31 31.H.sdrebi V 464d3040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 46424040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 274432 3280 2076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 2014 onstat -g mem | grep ^31 31.H.sdrebi V 46451040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 467f9040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 2834432 3280 22076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 22014 onstat -g mem | grep ^31 31.H.sdrebi V 46690040 4096 640 3 1 31*O0 V 463c9040 4096 768 1 1 31.H.ext V 45e30040 8192 864 23 1 31.H.ext V 46a06040 16384 3392 42 1 31.H.sd V 45f95040 16384 3640 45 2 31.H.sd V 464e8040 5394432 3280 42076 2 31 V 46459040 77824 4120 107 3 onstat -g afr 0x464e8040 | grep sqalloc.c:1949 | wc -l -> 42014 If the index is dropped, then the leak is not seen. The memory is returned to the server if the session exits. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC15 and 14.10.xC5. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * 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: * * See Error Description * **************************************************************** * 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 : | 05.08.2020 22.01.2021 22.01.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |