IT33797: MEMORY LEAK IN SQALLOC.C:1949 WHEN RUNNING JAVA PROG PERFORMING INSERTS & UPDATES WHERE PLACEHOLDERS MATCH THE COMPOSITE INDEX

APAR status

• Closed as program error.

Error 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.
  

Local fix

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.                                                   *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.10.xC5.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels