IBM Support

IT39916: POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • On a multi-member instance it is possible for memory corruption
    to occur when the PD_GET_DIAG_HIST table function is called.
    When this occurs the stack looks like this:
    
    diagnoseMemoryCorruptionAndCrash
    
    SQLO_MEM_POOL::MemTreePut
    sqlofmblkEx
    sqlrwGetWLMTableFunctionMergedResult
    sqlerTrustedRtnCallbackRouter
    wlmGetNextBuffer
    pd_get_diag_hist_v10fp3
    sqloInvokeFnArgs
    sqlriInvokerTrusted
    sqlriInvokeInvoker
    sqlri_tfftc
    sqlriFetch
    sqlrita
    sqlriSectInvoke
    sqlrr_process_fetch_request
    sqlrr_fetch
    sqljs_ddm_cntqry
    sqljsParseRdbAccessed
    sqljsParse
    sqljsSqlam
    sqljsDriveRequests
    sqljsDrdaAsInnerDriver
    sqljsDrdaAsDriver
    RunEDU
    EDUDriver
    sqloEDUEntry
    pthread_body
    
    And the following probes occur in the db2diag.log:
    
    2022-01-13-13.21.45.425137+060 I295537047A688    LEVEL: Severe
    PID   : 42533144       TID : 403615     PROC : db2sysc 3
    INSTANCE: db2inst1        NODE : 003      DB  : MYDB1
    APPHDL : 3-7123        APPID: *N3.db2inst1.220104145349
    UOWID  : 1          ACTID: 1
    AUTHID : DB2INST1        HOSTNAME: MYHOST1
    EDUID  : 403615        EDUNAME: db2agent (MYDB1) 3
    FUNCTION: DB2 UDB, WLM, sqlrwGetWLMTableFunctionMergedResult,
    probe:6
    CALLED : DB2 UDB, relation data serv, sqlrkrpc_nl
    RETCODE : ZRC=0x80120003=-2146303997=SQLR_INTRP
         ?Statement interrupt, detected at RDS?
         DIA8003C The interrupt has been received.
    
    
    2022-01-13-13.21.45.428887+060 E295537736A870    LEVEL: Error
    PID   : 42533144       TID : 403615     PROC : db2sysc 3
    INSTANCE: db2inst1        NODE : 003      DB  : MYDB1
    APPHDL : 3-7123        APPID: *N3.db2inst1.220104145349
    UOWID  : 1          ACTID: 1
    AUTHID : DB2INST1        HOSTNAME: MYHOST1
    EDUID  : 403615        EDUNAME: db2agent (MYDB1) 3
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:30
    MESSAGE : ADM14005E The following error occurred: ?Panic?. First
    Occurrenc
         Data Capture (FODC) has been invoked in the following mode:
         ?Automatic?. Diagnostic information has been recorded in
    the
         directory named
    
    ?/db2home/db2inst1/sqllib/db2dump/DIAG0003/FODC_Panic_2022-01-13
    -1
    3.21.
         45.426676_42533144_403615_003/?.
    
    
    2022-01-13-13.21.45.433275+060 E295538607A2804   LEVEL: Severe
    PID   : 42533144       TID : 403615     PROC : db2sysc 3
    INSTANCE: db2inst1        NODE : 003      DB  : MYDB1
    APPHDL : 3-7123        APPID: *N3.db2inst1.220104145349
    UOWID  : 1          ACTID: 1
    AUTHID : DB2INST1        HOSTNAME: MYHOST1
    EDUID  : 403615        EDUNAME: db2agent (MYDB1) 3
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:999
    MESSAGE : Memory validation failure, diagnostic file dumped.
    DATA #1 : String, 28 bytes
    Corrupt pool free tree node.
    DATA #2 : File name, 35 bytes
    42533144.403615.mem_diagnostics.txt
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
     [0] 0x09000000131B1388
    diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb +
    0x4E8
     [1] 0x09000000131B9C3C
    MemTreePut__13SQLO_MEM_POOLFP8SMemNodeUlP17SqloChunkSubgroup +
    0x6DC
     [2] 0x09000000131475CC sqlofmblkEx + 0xDEC
     [3] 0x090000001A656100
    sqlrwGetWLMTableFunctionMergedResult__FUiPPv + 0x6A0
     [4] 0x0900000013E7A818 sqlerTrustedRtnCallbackRouter__FUiPPv +
    0x378
     [5] 0x090000002EDE6F88 wlmGetNextBuffer + 0xE8
     [6] 0x090000002EE53684 pd_get_diag_hist_v10fp3 + 0x11E4
     [7] 0x090000001310A414 sqloInvokeFnArgs + 0x5B94
     [8] 0x09000000157F5240
    IPRA.$sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorInt
    fb + 0xC60
     [9] 0x09000000157ECE28 sqlriInvokeInvoker__FP10sqlri_ufobb +
    0x2008
     [10] 0x090000001A1F4BC4 sqlri_tfftc__FP8sqlrr_cbP9sqlri_tao +
    0x324
     [11] 0x0900000015AAEBBC sqlriFetch__FP8sqlrr_cbP9sqlri_taol +
    0x21C
     [12] 0x09000000177CA2B8 sqlrita__FP8sqlrr_cb + 0x8F8
     [13] 0x0900000015EE1A28
    sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x688
     [14] 0x0900000015347C14
    sqlrr_process_fetch_request__FP14db2UCinterface + 0xD14
     [15] 0x090000001534376C
    sqlrr_fetch__FP14db2UCinterfaceP15db2UCCursorInfo + 0x1FCC
     [16] 0x090000001A6D6E40
    sqljs_ddm_cntqry__FP14db2UCinterfaceP13sqljDDMObject + 0x4C0
     [17] 0x090000001A66A000
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x220
     [18] 0x090000001A66D134
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x22B4
     [19] 0x0900000013DD9E7C
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xEFC
     [20] 0x0900000013DE2634
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
     [21] 0x0900000013DD7D9C
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x141C
     [22] 0x0900000013DD51BC
    sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x33C
     [23] 0x0900000013265920 RunEDU__8sqeAgentFv + 0xB60
     [24] 0x090000001323F840 EDUDriver__9sqzEDUObjFv + 0x300
     [25] 0x090000001311E500 sqloEDUEntry + 0x360
     [26] 0x09000000005ACFE8 _pthread_body + 0xE8
     [27] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
    
    
    2022-01-13-13.21.45.454486+060 I295541412A570    LEVEL: Severe
    PID   : 42533144       TID : 403615     PROC : db2sysc 3
    INSTANCE: db2inst1        NODE : 003      DB  : MYDB1
    APPHDL : 3-7123        APPID: *N3.db2inst1.220104145349
    UOWID  : 1          ACTID: 1
    AUTHID : DB2INST1        HOSTNAME: MYHOST1
    EDUID  : 403615        EDUNAME: db2agent (MYDB1) 3
    FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
    probe:10
    MESSAGE : DIA0505I Execution of a component signal handling
    function has begun.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 v11.1.4.6                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest fix pack 11.5.7                            *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IT39916

  • 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

    2022-02-09

  • Closed date

    2022-03-22

  • Last modified date

    2022-04-16

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

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

    IT39938

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