IBM Support

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

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

  • 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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
16 March 2021