IBM Support

IC70959: INSERT OR UPDATE WITH INDEX COMPRESSION MAY CAUSE MEMORY CORRUPT ION AND CRASH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If the indexes for a table are compressed then any of the
    following operations can cause a crash :
    
    - INSERT
    - UPDATE
    - IMPORT
    - LOAD
    - CREATE INDEX
    - REORG INDEXES
    
    The following are example stacktraces for the crash:
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    sqloCrashOnCriticalMemoryValidationFailure + 0x20
    diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCc + 0x27C
    diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCc@glue7C4
    +x78
    MemTreeGet__13SQLO_MEM_POOLFCUlT1PPvPP17SqloChunkSubgroupPP12SMe
    mLostNode + 0x54
     .allocateMemoryBlock.fdpr.clone.26__13SQLO_MEM_POOLFCUlUlT1UiT1
    PPvPP17SqloChunk
    SubgroupPP12SMemLostNodeCP12SMemLogEvent + 0x80
    sqlogmblkEx + 0x72C
    sqldAllocWorkArea__FP8sqeAgentP16SQLD_WORK_MEMORYUiiN23PPc +
    0x98
    sqldAllocWorkArea__FP8sqeAgentP16SQLD_WORK_MEMORYUiiN23PPc@glue5
    68 + 0x8C
    sqldGetWorkArea__FP8sqeAgentiPPcUiT2@glueC2A + 0x2C
    @147@sqlipcLogPrefixImprovement__FP7SQLI_CBP14SQLI_PAGE_DESCT2lP
    9SQLI_SLOT + 0x1FC
    @147@sqlipcCopyTempPgToCurrentPg__FP7SQLI_CBP14SQLI_PAGE_DESCP9S
    QLI_SLOTT2lP6ACT_PG + 0x270
    @147@sqlipcPhysicalMerge__FP7SQLI_CBP6ACT_PGP14SQLI_PAGE_DESCP27
    SQLI_PREFIX_META
    _DATA_TABLEUlN25lP9SQLI_SLOT  + 0x688
    sqlipcOptimizePrefixes__FP7SQLI_CBP6ACT_PGP14SQLI_PAGE_DESCP9SQL
    I_SLOTUlT5PUl + 0x62C
    sqlipcOptimizePrefixes__FP7SQLI_CBP6ACT_PGP14SQLI_PAGE_DESCP9SQL
    I_SLOTUlT5PUl@glue1500 + 0x74
    @147@addkeyToLeaf__FP7SQLI_CBP11SQLI_SAGLOBP9SQLI_SLOT + 0x814
    </StackTrace>
    
    
    <StackTrace>
    -------Frame------ ------Function + Offset------
    ?unknown + 0x0
    memcpy__FPvPCvUl + 0x2C
    sqlo_md_mcpy + 0x208
    sqlipcUseLongerPrefix__FP7SQLI_CBPcN32PUs +  0xFB4
    sqlipcPutNewSuffixOnTempPg__FP7SQLI_CBP14SQLI_PAGE_DESCT2lN24P21
    SQLI_PREFIX_META_DATA + 0x4F0
    sqlipcCopyModifiedSuffixesWithRelocate__FP7SQLI_CBP14SQLI_PAGE_D
    ESCT2P9SQLI_SLOTUl + 0x520
    sqlipcPhysicalMerge__FP7SQLI_CBP6ACT_PGP14SQLI_PAGE_DESCP27SQLI_
    PREFIX_META_DATA_TABLEUlN25lP9SQLI_SLOT + 0x4D0
    sqlipcOptimizePrefixes__FP7SQLI_CBP6ACT_PGP14SQLI_PAGE_DESCP9SQL
    I_SLOTUlT5PUl + 0x4A0
    sqliNormalAddKey__FP7SQLI_CBP14SQLI_PAGE_DESCP9SQLI_SLOTP8SQLD_K
     EYP12SQLI_KEYDATA + 0x4AC
    sqliakn__FP7SQLI_CBP14SQLI_PAGE_DESCP9SQLI_SLOTP8SQLD_KEYP12SQLI
    _KEYDATAPUc + 0x668
    addkeyToLeaf__FP7SQLI_CBP11SQLI_SAGLOBP9SQLI_SLOT + 0x2C8
    procLeaf2Add__FP7SQLI_CBP11SQLI_SAGLOBP9SQLI_SLOTiP12SQLI_KEYDAT
    A + 0x4D4
    sqlischa__FP7SQLI_CBP11SQLI_SAGLOBiUi + 0xFC4
    next_level__FP7SQLI_CBP11SQLI_SAGLOBiUi + 0x138
    sqlischa__FP7SQLI_CBP11SQLI_SAGLOBiUi + 0xF4C
    sqliaddk__FP8sqeAgentP9SQLD_IXCBP8SQLD_KEYP12SQLI_KEYDATAP14SQLP
    _LOCK_INFOP8SQLP
    _LRBUlP10SQLI_IXPCR + 0xF88
    sqldKeyInsert__FP13SQLD_DFM_WORKP16SQLD_TABLE_CACHET2P13SQLD_TDA
    TARECiUl + 0x7B4
    sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP13SQLD_TDATARE
    CP8SQLZ_RID + 0x1230
    sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEUlP8SQLZ_RID + 0xE8
    sqlriisr__FP8sqlrr_cb + 0x4F0
    sqlriExecThread__FP8sqlrr_cbP12sqlri_opparm + 0x584
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x4DC
    sqlrr_process_execute_request__FP8sqlrr_cbi + 0x1880
    sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x5A4
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5D8
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x1E0
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x21
    C
    sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x4AC
    
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x15C
    sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x478
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +  0x23C
    RunEDU__8sqeAgentFv + 0x3AC
    EDUDriver__9sqzEDUObjFv + 0x19C
    sqlzRunEDU__FPcUi + 0x3C
    sqloEDUEntry + 0x6A4
    </StackTrace>
    

Local fix

  • db2set DB2_INDEX_COMPRESSION=OFF
    followed by db2stop/db2start to pick up this change,
    then drop and recreate the indexes.
    
    Alternatively use the ALTER INDEX command with the COMPRESS NO,
    following by using the REORG INDEXES command to recreate the
    problem index as uncompressed
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7.3a.                                       *
    ****************************************************************
    

Problem conclusion

  • The problem was first fixed in DB2 9.7.3a.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70959

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-09-06

  • Closed date

    2010-11-02

  • Last modified date

    2011-01-25

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

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

    IC77559

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN UP

       CIRCUMVE

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
25 January 2011