IBM Support

IT33321: DB2 MAY TRAP ON MEMORY VALIDATION FAILURE DUE TO CORRUPT BLOCK HEADER IN SQLRA_SQLW_MEM_FREE_SIBLING_LIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 may trap on memory validation failure. Symptom in the
    db2diag.log file will report a "Memory validation failure" at
    "sqloDiagnoseFreeBlockFailure" with a stack pointing to
    sqlra_sqlW_mem_free_sibling_list:
    
    ...
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    MESSAGE : Memory validation failure, diagnostic file dumped.
    DATA #1 : String, 21 bytes
    Corrupt block header.
    DATA #2 : File name, 39 bytes
    21730.4376861075728.mem_diagnostics.txt
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
    [0] 0x000003FF8DFF37D2
    _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb +
    0x40A
    [1] 0x000003FF8DFCEA28
    /db2/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xB9CEA28
    [2] 0x000003FF8DFC7042 sqlofmblkEx + 0xA72
    [3] 0x000003FF8F1A940E _Z8sqlristmP8sqlrr_cbP9sqlri_shdi + 0x4FA
    [4] 0x000003FF8EC99754
    _Z32sqlra_sqlW_mem_free_sibling_listP8sqlrr_cbP23sqlra_workspace
    _siblingPm + 0x328C
    [5] 0x000003FF8EC937BA
    _Z24sqlra_sqlW_mem_freespaceP8sqlrr_cbmPmi + 0xD26
    [6] 0x000003FF8EC8DCBE
    _Z28sqlra_sqlW_check_for_cleanupP8sqlrr_cbmP7OSSTick + 0x7CA
    [7] 0x000003FF8EC89A66
    _Z33sqlra_sqlW_get_static_section_newP8sqlrr_cbP20sqlra_cached_s
    ection + 0x10EE
    [8] 0x000003FF8EB7E346
    _Z17sqlra_get_sectionP8sqlrr_cbPhsS1_sS1_tmP16db2UCprepareInfoP1
    5db2UCCursorInfoij + 0x24C6
    [9] 0x000003FF8E812DF6
    _Z21sqlrr_sql_request_preP14db2UCinterfacejiP16db2UCprepareInfoP
    15db2UCCursorInfo + 0x9B6
    [10] 0x000003FF8E87D7A0
    _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0x2B0
    [11] 0x000003FF84DF03A6
    _Z7csmOpenP14db2UCinterfaceP15db2UCCursorInfo + 0xBA
    [12] 0x000003FF85781760 _ZN10pvmPackage10openCursorEj + 0x2C8
    [13] 0x000003FF8577C00A
    _ZN10pvmPackage14executeSectionEP5sqlcajb + 0xE1E
    [14] 0x000003FF8577A4BA _ZN3PVM12executeQueryEjb + 0x13A
    [15] 0x000003FF85769704 _ZN3PVM3runEv + 0x624
    [16] 0x000003FF85799CE6 pvm_entry + 0x40A
    [17] 0x000003FF8DF1EFC2 sqloInvokeFnArgs + 0x2D1E
    [18] 0x000003FF8F12B8A6
    /db2/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xCB2B8A6
    [19] 0x000003FF8F128FE4 _Z18sqlriInvokeInvokerP10sqlri_ufobb +
    0x2FC
    [20] 0x000003FF8F1273C4 _Z9sqlricallP8sqlrr_cb + 0x4DC
    [21] 0x000003FF8EF809DC
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x6CC
    [22] 0x000003FF8E8C2570
    _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x1D74
    [23] 0x000003FF8E8827E0
    _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x878
    [24] 0x000003FF8C0E055E
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x3DE
    [25] 0x000003FF8C0A025E
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x1E2
    [26] 0x000003FF8C0A1C78
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0xF5C
    [27] 0x000003FF8C08612A
    /db2/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x9A8612A
    [28] 0x000003FF8C085254
    /db2/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x9A85254
    [29] 0x000003FF8C084DAE
    /db2/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x9A84DAE
    [30] 0x000003FF8C083AA0
    _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x1C8
    [31] 0x000003FF8BAAA5A8 _ZN8sqeAgent6RunEDUEv + 0x434
    [32] 0x000003FF903C691E _ZN9sqzEDUObj9EDUDriverEv + 0x49E
    [33] 0x000003FF8E0281E8 sqloEDUEntry + 0x724
    [34] 0x000003FF95F88B5E /lib64/libpthread.so.0 + 0x8B5E
    [35] 0x000003FF819F9F2A /lib64/libc.so.6 + 0xF9F2A
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to version 11.1 mod 4 fix pack 6                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in version 11.1 mod 4 fix pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT33321

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-06-25

  • Closed date

    2021-03-15

  • Last modified date

    2021-03-15

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022