IBM Support

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

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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 number

    IT33797

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-08-05

  • Closed date

    2021-01-22

  • Last modified date

    2021-01-22

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
23 January 2021