IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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:
    X.X.X.X.0000.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   : X.X.X.X.0000.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   : X.X.X.X.0000.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:
    X.X.X.X.0000.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

    2022-03-31

  • 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":"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