IC87904: MISSING ON RESETTING POINTER AFTER FREEING MEMORY BLOCK CAUSES UNEXPECTED CHECKING ON THE CONTENT OF POINTER.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The instance crashed during insert into xml column using
    parameter marker.
    
    On db2diag.log file, there is an indication that the crash has
    happened after a query execution with a XML column and caused a
    memory issue:
    
    2011-12-25-21.55.26.597754+000 I30301E1505         LEVEL: Severe
    PID     : 11946                TID  : 47582885701952PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000          DB   : DBTEST
    APPHDL  : 0-6186               APPID:
    10.208.82.206.36589.11122521554
    AUTHID  : AUTHID
    EDUID   : 188                  EDUNAME: db2agent (DBTEST) 0
    FUNCTION: DB2 UDB, SQO Memory Management,
    sqloMemBlockReallocate, probe:20
    MESSAGE : ZRC=0x820F0002=-2112946174=SQLO_INV_MEM "Invalid
    memory addr"
              DIA8561C A invalid memory block was encountered.
    DATA #1 : String, 41 bytes
    Invalid parameter.  *ppMemBlock is NULL:
    DATA #2 : Pointer, 8 bytes
    0x00002b46c0ff4e30
    CALLSTCK:
      [0] 0x00002B2A30E55886 pdLog + 0x398
      [1] 0x00002B2A31377B7F sqloMemBlockReallocate + 0x2A9
      [2] 0x00002B2A335043E9
    _Z15xpcInsertPathIDP8sqeAgentP9SQLD_IXCBj + 0x273
      [3] 0x00002B2A33504AEE
    _Z20xmlsXMLColPathInsertP11XMLSTORE_CBP14SqlzXmlQNameIDj15SqlzXm
    lNodeKindPj + 0x326
      [4] 0x00002B2A3162EAFB
    _ZN12XmlrnNodeMgr9getPathIDEP14SqlzXmlQNameIDt15SqlzXmlNodeKindR
    jbb + 0x9B
      [5] 0x00002B2A31633E29
    _ZN11XmlrnWriter19updateNodePathLevelEP14XmlrnParseNodejj + 0x7D
      [6] 0x00002B2A31634434
    _ZN11XmlrnWriter12setNodeNamesEP14XmlrnParseNodejjjjPKv + 0x72
      [7] 0x00002B2A316335F0
    _ZN11XmlrnWriter16processStartNodeEN12XmlrnNodeHdr8NodeKindEjjjj
    PKv + 0x16E
      [8] 0x00002B2A334B94DB _ZN11XmlrnWriter13startDocumentEv +
    0x61
      [9] 0x00002B2A3347E3C2
    _ZN27XmlrnDocumentHandlerVisitor9enterNodeEP19XmlrnNodeDescripto
    rRt + 0x65C
    
    2011-12-25-21.55.26.818096+000 I31807E508          LEVEL: Severe
    PID     : 11946                TID  : 47582885701952PROC :
    db2sysc 0
    INSTANCE: db2inst1           NODE : 000          DB   : DBTEST
    APPHDL  : 0-6186               APPID:
    10.208.82.206.36589.11122521554
    AUTHID  : AUTHID
    EDUID   : 188                  EDUNAME: db2agent (DBTEST) 0
    FUNCTION: DB2 UDB, Xml Storage and Index Manager,
    xmlsXMLColPathInsert, probe:350
    DATA #1 : String, 50 bytes
    Severe error while expanding xml column path cache
    
    
    This is the generated Stack Trace from FODC trap file:
    
    <StackTrace>
    -----FUNC-ADDR---- ------FUNCTION + OFFSET------
    0x00002B2A355F7D07 ossDumpStackTraceEx + 0x01ef
    0x00002B2A355F2ACE _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm +
    0x00cc
    0x00002B2A3285DE90 sqlo_trce + 0x040a
    0x00002B2A328A41E8 sqloEDUCodeTrapHandler + 0x025a
    0x00002B2A2FD48B10 address: 0x00002B2A2FD48B10 ; dladdress:
    0x00002B2A2FD3A000 ; offset in lib: 0x000000000000EB10 ;
    0x00002B2A36244265 gsignal + 0x0035
    0x00002B2A36245D10 abort + 0x0110
    0x00002B2A313992FF sqloExitEDU + 0x014d
    0x00002B2A31C9C773 _Z10sqle_panicv + 0x00ab
    0x00002B2A3134A11A _Z9sqloPanicPKc + 0x0006
    0x00002B2A3285D990
    _ZNK17SQLO_SLATCH_CAS6420dumpDiagInfoAndPanicEPKcjmmlmiS1_mi +
    0x01e4
    0x00002B2A3134DCCC
    _ZN17SQLO_SLATCH_CAS6422releaseConflictComplexEv + 0x02b4
    0x00002B2A3134D9E1 _ZN17SQLO_SLATCH_CAS6415releaseConflictEv +
    0x0033
    0x00002B2A33612577 address: 0x00002B2A33612577 ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x00000000036BC577 ;
    0x00002B2A33504348 _Z15xpcInsertPathIDP8sqeAgentP9SQLD_IXCBj +
    0x01d2
    0x00002B2A33504AEE
    _Z20xmlsXMLColPathInsertP11XMLSTORE_CBP14SqlzXmlQNameIDj15SqlzXm
    lNodeKindPj + 0x0326
    0x00002B2A3162EAFB
    _ZN12XmlrnNodeMgr9getPathIDEP14SqlzXmlQNameIDt15SqlzXmlNodeKindR
    jbb + 0x009b
    0x00002B2A31633E29
    _ZN11XmlrnWriter19updateNodePathLevelEP14XmlrnParseNodejj +
    0x007d
    0x00002B2A31634434
    _ZN11XmlrnWriter12setNodeNamesEP14XmlrnParseNodejjjjPKv + 0x0072
    
    0x00002B2A316335F0
    _ZN11XmlrnWriter16processStartNodeEN12XmlrnNodeHdr8NodeKindEjjjj
    PKv + 0x016e
    0x00002B2A334B94DB _ZN11XmlrnWriter13startDocumentEv + 0x0061
    0x00002B2A3347E3C2
    _ZN27XmlrnDocumentHandlerVisitor9enterNodeEP19XmlrnNodeDescripto
    rRt + 0x065c
    0x00002B2A334B8915
    _ZN18XmlrnVisitorDriver12visitSubtreeEP12XmlrnVisitorRt + 0x01d1
    
    0x00002B2A33488C1A address: 0x00002B2A33488C1A ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x0000000003532C1A ;
    0x00002B2A3348AD63 _Z19xmlrnInsertDocumentP11XmlrnIUD_CB +
    0x0aaf
    0x00002B2A30EFE65E
    _Z21sqldInsertXMLDocumentP8sqeAgentP8SQLD_TCBiP10sqlz_valueP14SQ
    LXMS_XDADESCS6_ + 0x04b0
    0x00002B2A31B3BBB1 address: 0x00002B2A31B3BBB1 ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x0000000001BE5BB1 ;
    0x00002B2A33552882
    _Z22sqldFullFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_
    VALUEmP8SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB + 0x1686
    0x00002B2A30F20623
    _Z14sqldFullFormatP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_VALUEmP8
    SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB + 0x002d
    0x00002B2A30F1C99B
    _Z13sqldRowInsertP8sqeAgenttthmiPP10SQLD_VALUEP13SQLD_TDATARECP8
    SQLZ_RID + 0x0e03
    0x00002B2A314D1F3D
    _Z8sqlrinsrP8sqlrr_cbttitPP10SQLD_VALUEmP8SQLZ_RID + 0x0069
    0x00002B2A314DEBE4 _Z8sqlriisrP8sqlrr_cb + 0x0156
    0x00002B2A335E0605 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm
    + 0x00eb
    0x00002B2A314261FE _Z29sqlrr_process_execute_requestP8sqlrr_cbi
    + 0x0d80
    0x00002B2A32A605C2
    _Z17sqlrr_array_inputP14db2UCinterfacePP15db2UCdiagStructmt +
    0x1358
    0x00002B2A3106095C
    _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject +
    0x08ea
    0x00002B2A33579357
    _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U
    Cinterface + 0x007d
    0x00002B2A31048B72
    _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x035a
    0x00002B2A31043122 address: 0x00002B2A31043122 ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x00000000010ED122 ;
    0x00002B2A31044CB1 address: 0x00002B2A31044CB1 ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x00000000010EECB1 ;
    0x00002B2A310440FA address: 0x00002B2A310440FA ; dladdress:
    0x00002B2A2FF56000 ; offset in lib: 0x00000000010EE0FA ;
    0x00002B2A31043E55 _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T +
    0x0111
    0x00002B2A30F811FF _ZN8sqeAgent6RunEDUEv + 0x09f1
    0x00002B2A3161450C _ZN9sqzEDUObj9EDUDriverEv + 0x00a6
    0x00002B2A31614463 _Z10sqlzRunEDUPcj + 0x0009
    0x00002B2A31399A8D sqloEDUEntry + 0x02e9
    0x00002B2A2FD4073D address: 0x00002B2A2FD4073D ; dladdress:
    0x00002B2A2FD3A000 ; offset in lib: 0x000000000000673D ;
    0x00002B2A362E7F6D clone + 0x006d
    </StackTrace>
    
    This APAR may also be caused by a stale pointer being passed to
    the xmlColPathCache function.  The trap file will contain the
    following stack information:
    
    Stack #1             Signal #11        Timestamp
    2012-07-01-23.33.14.778862
    0        ossDumpStackTraceEx
    1        OSSTrapFile::dumpEx
    2        sqlo_trce
    3        sqloEDUCodeTrapHandler
    4        __pthread_mutex_cond_lock
    5        sqldKeyInsert
    6        sqldRowInsert
    7        sqlrinsr
    8        sqlriisr
    9        sqlriSectInvoke
    10       sqlrr_dss_router
    11       sqlrr_subagent_router
    12       sqleSubRequestRouter
    13       sqleProcessSubRequest
    14       sqeAgent::RunEDU
    15       sqzEDUObj::EDUDriver
    16       sqlzRunEDU
    17       sqloEDUEntry
    18       pthread_create@@GLIBC_2.2.5
    19       clone
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10 fix pack 2.                        *
    ****************************************************************
    

Problem conclusion

  • This issue is fixed in DB2 version 10 fix pack 2.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC87904

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-11-04

  • Closed date

    2012-12-28

  • Last modified date

    2012-12-28

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

    IC82699

  • 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

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC87904

Modified date:

2012-12-28

Translate my page

Machine Translation

Content navigation