IBM Support

IT27993: DPF INSTANCE MAY CRASH DUE TO MEMORY CORRUPTION WHEN CALLING STORED PROCEDURE.

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

  • DPF Instance may crash due to memory corruption when calling
    Stored procedure.
    
    2019-01-14-14.31.08.604673-300 I297377755E428        LEVEL:
    Severe
    PID     : 129799               TID : 139925930825472 PROC :
    db2fmp (
    INSTANCE: db2inst1             NODE : 014
    HOSTNAME: host3
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : Synchronization Semaphore ID
    DATA #1 : Hexdump, 8 bytes
    0x00007F430B66CD54 : 0200 0000 0000 0000
    ........
    
    2019-01-14-14.31.08.604824-300 I297378184E341        LEVEL:
    Severe
    PID     : 129799               TID : 139925930825472 PROC :
    db2fmp (
    INSTANCE: db2inst1             NODE : 014
    HOSTNAME: host3
    FUNCTION: DB2 UDB, common communication, sqlccFreeIPCs,
    probe:100
    RETCODE : ZRC=0x800F00FC=-2146500356=SQLO_INV_PARM "Invalid
    input parameter"
    
    2019-01-14-14.31.08.604937-300 I297378526E420        LEVEL:
    Severe
    PID     : 129799               TID : 139925930825472 PROC :
    db2fmp (
    INSTANCE: db2inst1             NODE : 014
    HOSTNAME: host3
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
    logging function), probe:50
    MESSAGE : IPC Semaphore Set ID
    DATA #1 : Hexdump, 8 bytes
    0x00007F430B66CD34 : 8281 D872 0000 0000
    ...r....
    
    2019-01-14-14.31.08.825967-300 E297393675E1032       LEVEL:
    Critical
    PID     : 124535               TID : 140232666113792 PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014            DB   :
    SAMPLE
    APPHDL  : 1-29257              APPID:
    10.1.1.1.65272.190114193108
    AUTHID  : db2inst1             HOSTNAME: host3
    EDUID   : 309284               EDUNAME: db2agntp (SAMPLE) 14
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloDiagnoseFreeBlockFailure, probe:10
    MESSAGE : ADM14001C  An unexpected and critical error has
    occurred: "Panic".
              The instance may have been shutdown as a result.
    "Automatic" FODC
              (First Occurrence Data Capture) has been invoked and
    diagnostic
              information has been recorded in directory
              "/home/db2inst1/db2dump/HOST_host3/FODC_Panic_2019-
              01-14-14.31.08.813903_0014/". Please look in this
    directory for
              detailed evidence about what happened and contact IBM
    support if
              necessary to diagnose the problem.
    
    2019-01-14-14.31.08.839490-300 I297395703E602        LEVEL: Info
    PID     : 129799               TID : 139925932271360 PROC :
    db2fmp (
    INSTANCE: db2inst1             NODE : 014            DB   :
    SAMPLE
    APPID   : 10.1.1.1.65272.190114193108
    HOSTNAME: host3
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerFmpListener,
    probe:1999
    MESSAGE : ZRC=0xFFFFFB95=-1131
              SQL1131N  A stored procedure process has been
    terminated abnormally.
              Routine name: "". Specific name: "".
    
    DATA #1 : String, 46 bytes
    FMP exiting with error. Last agent registered:
    DATA #2 : EDUID, 4 bytes
    309352
    
    2019-01-14-14.31.08.839757-300 I297396306E505        LEVEL:
    Warning
    PID     : 129799               TID : 139925932271360 PROC :
    db2fmp (
    INSTANCE: db2inst1             NODE : 014            DB   :
    SAMPLE
    APPID   : 10.1.1.1.65272.190114193108
    HOSTNAME: host3
    FUNCTION: DB2 UDB, routine_infrastructure,
    sqlerWorkerThreadEntry, probe:1022
    MESSAGE : ZRC=0xFFFFFB95=-1131
              SQL1131N  A stored procedure process has been
    terminated abnormally.
              Routine name: "". Specific name: "".
    
    2019-01-14-14.31.08.896867-300 E297406826E2636       LEVEL:
    Severe
    PID     : 124535               TID : 140232666113792 PROC :
    db2sysc 14
    INSTANCE: db2inst1             NODE : 014            DB   :
    SAMPLE
    APPHDL  : 1-29257              APPID:
    10.1.1.1.65272.190114193108
    EDUID   : 309284               EDUNAME: db2agntp (SAMPLE) 14
    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, 42 bytes
    124535.140232666113792.mem_diagnostics.txt
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are resolved to the nearest symbol)
      [0] 0x00007FA9648AF935
    _ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKcb +
    0x285
      [1] 0x00007FA9648AAA48
    _ZN13SQLO_MEM_POOL10MemTreeGetEmmPP17SqloChunkSubgroupPj + 0x188
      [2] 0x00007FA9648AFAEC
    _ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmjmPP17SqloChunkSubgrou
    pPjP12SMemLogEvent + 0x6C
      [3] 0x00007FA96488CDF0 sqloGetMemoryBlockExtended + 0xFF0
      [4] 0x00007FA962DCDC0E
    _Z14sqlerGetFMPIPCP18SQLCC_INITSTRUCT_Tj + 0x18E
      [5] 0x00007FA95F5CA9EE
    _Z12sqlccGetIPCsP18SQLCC_INITSTRUCT_TP26SQLCC_IPC_CON_REQST_DATA
    _Tb + 0xB7E
      [6] 0x00007FA962E06008
    _Z16sqlerAllocFmpIPCPP18SQLCC_INITSTRUCT_TP8sqeAgenti + 0x188
      [7] 0x00007FA962DFA635
    _Z22sqlerGetFmpThreadEntryP11sqlerFmpRowP14sqlerFmpHandleP17sqle
    rFmpParmsBaseb + 0xB75
      [8] 0x00007FA962DF85CE
    _Z19sqlerGetFmpFromPoolP14sqlerFmpHandleP17sqlerFmpParmsBase +
    0x11CE
      [9] 0x00007FA962DF594E
    _Z24sqlerInvokeFencedRoutineP13sqlerFmpParms + 0x5FE
      [10] 0x00007FA96569F1F9 _Z18sqlriInvokeInvokerP10sqlri_ufobb +
    0x4A9
      [11] 0x00007FA9656A67BC _Z8sqlriutfP8sqlrr_cb + 0x79C
      [12] 0x00007FA9656DD72F _Z11sqlri_tfopnP8sqlrr_cbP9sqlri_tao +
    0x10F
      [13] 0x00007FA96548E4EC _Z8sqlriopnP8sqlrr_cbP9sqlri_taoPi +
    0x4AC
      [14] 0x00007FA965608558 _Z7sqlritaP8sqlrr_cb + 0xB78
      [15] 0x00007FA96552498D
    _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4BD
      [16] 0x00007FA964F583A6 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x806
      [17] 0x00007FA964F54D55
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x1075
      [18] 0x00007FA962A827A2
    /home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x546B7A2
      [19] 0x00007FA962A81070 _Z21sqleProcessSubRequestP8sqeAgent +
    0x3E0
      [20] 0x00007FA962AB58B7 _ZN8sqeAgent6RunEDUEv + 0x5D7
      [21] 0x00007FA966377F4E _ZN9sqzEDUObj9EDUDriverEv + 0x1BE
      [22] 0x00007FA9648D92B8 sqloEDUEntry + 0x578
      [23] 0x0000003457607AA1 /lib64/libpthread.so.0 + 0x7AA1
      [24] 0x00000034572E893D clone + 0x6D
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27993

  • 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

    2019-02-05

  • Closed date

    2020-01-16

  • Last modified date

    2020-01-16

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

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

    PH15540

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"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":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 January 2020