IBM Support

IC93892: DB2 MIGHT CRASH WHEN YOU ARE INSERTING XML FILE CONTAINING LARGE TEXT NODE TO THE XML COLUMN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 might crash when you are inserting XML file containing large
    text node to the XML column.
    Once this happens, you will notice the following entry in the
    db2diag.log:
    
    2013-05-16-08.35.13.526356+120 I553420A566        LEVEL: Warning
    PID     : 17363                TID  : 934         PROC : db2sysc
    0
    INSTANCE: DB2INST1             NODE : 000         DB   :
    DB2INST1
    APPHDL  : 0-11094              APPID: 1.0.0.1.40739.130516054911
    AUTHID  : DB2ADMIN
    EDUID   : 934                  EDUNAME: db2agent (DB2INST1) 0
    FUNCTION: DB2 UDB, RAS/PD component,
    pdEDUIsInDB2KernelOperation, probe:600
    DATA #1 : String, 83 bytes
    __1cSXmlrnNodePersisterPgrowNodeContent6MpnMXmlsNidStack_pnOXmlr
    nParseNode_pvIbb_i_
    DATA #2 : String, 4 bytes
    xmls
    
    During the processing, the FODC_Trap directory is created, where
    the relevant stack is dumped:
    
    <StackTrace>
    ##### Object: /opt/IBM/db2/V9.7fp6/lib64/libdb2e.so.1
    __1cSXmlrnNodePersisterbAwriteSubtreeLargerThanPage6MpnOXmlrnPar
    seNode__i_(0xffffffff62b715c0,0x0,0xc0400,0x1,0x22ed2b0,0xffffff
    fb7dff5818) + 0xc
    __1cSXmlrnNodePersisterUselectAndWriteRegion6MpnOXmlrnParseNode_
    p2b_i_(0xffffffff62b715c0,0x0,0xfffffffb7dff5af8,0x1,0xfffffffb7
    dff5918,0x0) + 0x228
    __1cSXmlrnNodePersisterbPgetNodeFreeSpaceEnsureNonzeroAvailabili
    ty6MpnOXmlrnParseNode_brI_i_(0xffff0000,0xffffffff7b9aa47b,0xc05
    f0,0x1000,0xffffffff62b715c0,0xffffffff636ae000) + 0xe0
    __1cSXmlrnNodePersisterPgrowNodeContent6MpnMXmlsNidStack_pnOXmlr
    nParseNode_pvIbb_i_(0xc7b10,0xffffffff636ae000,0x1d200000,0xffff
    ffff7b9aa47b,0xffffffff7b9a9d85,0x1000) + 0x180
    __1cLXmlrnWriterLprocessText6MpcI_i_(0xfffffffb8e822498,0xffffff
    ff62b71c30,0xffffffff664e5480,0xffffffff62b71d80,0x0,0xffffffff7
    c85a808) + 0x304
    __1cbBXmlrpDocumentHandlerAdapterNdocCharacters6MkpkHkIkb_v_(0xf
    fffffff661701b8,0xffffffff64b601d0,0x9553,0x0,0x19e020c,0xffffff
    ff66170598) + 0xfc
    ##### Object: /opt/IBM/db2/V9.7fp6/lib64/libDB2xml4c.so.57.0
    __1cJxml4c_5_7MIGXMLScannerMsendCharData6Mrn0AJXMLBuffer__v_(0xf
    fffffff7e602b60,0xffffffff66170da0,0x2000,0x8004,0xffffffff7e641
    e78,0x9553) + 0x530
    __1cJxml4c_5_7MIGXMLScannerMscanCharData6Mrn0AJXMLBuffer__v_(0xf
    fffffff66170bb8,0xffffffff66170da0,0x1064,0x1c008,0xffffffff7420
    7798,0x8004) + 0x588
    __1cJxml4c_5_7MIGXMLScannerLscanContent6M_b_(0xffffffff66170bb8,
    0x1,0xffffffff7420a610,0xffffffff66170da0,0xffffffff66170e68,0xf
    fffffff66170c78) + 0x1c4
    __1cJxml4c_5_7MIGXMLScannerMscanDocument6Mrkn0ALInputSource__v_(
    0xffffffff66170bb8,0xfffffffb7dff6308,0xffffffff7e602b60,0x2cd6c
    c,0xc95d0,0xffffffff744c9fd8) + 0xa4
    ##### Object: /opt/IBM/db2/V9.7fp6/lib64/libdb2e.so.1
    __1cSXmlrpParserScannerMscanDocument6MrnQXmlrpInputSource__nPXml
    rpParserBaseLeResultCode__(0xffffffff661701a0,0xfffffffb838b81d8
    ,0xfffffffb838b81d8,0xfffffffb7dff653c,0x4b0,0x0) + 0x6c
    __1cbCxmlrnStreamingInsertDocument6FpnIsqeAgent_pnLXmlrnIUD_CB_H
    HpnTXmlrnDjxInputStream__i_(0x203700080,0xfffffffb7dff6618,0xfff
    fffff7e61cfd0,0x0,0x0,0xfffffffb838b8120) + 0x350
    __1cVsqlriBindinExtDta2Xml6FpnOdb2UCinterface_pnQsqlri_ExtDtaDat
    a_l_i_(0xffffffff6640d310,0xffffffff4b6fff00,0x100,0x0,0x0,0xfff
    fffff6640d380) + 0x518
    __1cRsqlribniLobCbDrda6FpnOdb2UCinterface__i_(0x0,0xfffffffb838b
    80e0,0xe,0xfffffffb7dff6a37,0x7fffffff,0x8) + 0x18a0
    __1cIsqlribni6FpnIsqlrr_cb__i_(0xfffffffb6f079680,0xffffffff7d4a
    e510,0xffffffff7d4ae510,0xffffffff7d4ae510,0x1b800000,0x40) +
    0x60c
    __1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff
    ffff6640d350,0xfffffffb6f079680,0xc91c8,0x2000,0x1400) + 0x668
    __1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_i_i_(0x4b48,0x1
    400,0xfffffffb6f079680,0xffffffff630fd7e0,0xffffffff630fd880,0x4
    ) + 0x2cec
    __1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff
    b6efca800,0x0,0x0,0x0,0x0,0xffffffff630fd7e0) + 0x450
    __1cTsqljs_ddm_excsqlstt6FpnOdb2UCinterface_pnNsqljDDMObject__i_
    (0xfffffffb6efca800,0xfffffffb8e8207c8,0xffffffff7d4ae270,0x0,0x
    1,0xfffffffb8e820080) + 0x884
    __1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pn
    Odb2UCinterface__i_(0xfffffffb8e820080,0xfffffffb7dff7588,0xffff
    fffb6efca800,0x200b,0x2000,0x1c90002d) + 0x280
    __1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_pnIsqeAgent_
    b_i_(0x0,0xfffffffb6efca800,0x203700080,0xfffffffb8e820e08,0x203
    703d48,0xfffffffb8e820080) + 0x714
    __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
    b_i_(0x0,0x203700080,0x0,0xfffffffb6efca800,0xfffffffb8e820080,0
    x203703d48) + 0x848
    __1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_
    b_i_(0x203700080,0xfffffffb6efca380,0x1400,0xfffffffb6efca800,0x
    0,0xfffffffb8e820080) + 0x1e0c
    __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0xfffffffb8e
    820080,0x0,0xfffffffb7dffff30,0xfffffffb6efca380,0x203700080,0xf
    fffffff7c85a808) + 0x1074
    __1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x201f5a680,
    0xffffffffffffffff,0x5800,0xfffffffb6f07b400,0xfffffffb6f07b400,
    0xfffffffb7dffff30) + 0x1c0
    __1cIsqeAgentGRunEDU6M_v_(0x203700080,0x2037016c0,0x18280400,0xf
    fffffff7c85a808,0xffffffff7e2a9d50,0x7268) + 0x884
    __1cKsqlzRunEDU6FpcI_v_(0xfffffffb7dffdd20,0xffffffff7810a080,0x
    1b9dcac,0x18d00000,0x0,0xffffffff7c85a808) + 0xd4
    sqloEDUEntry(0xfffffffb70bf5650,0xfffffffb7dffff30,0x8,0xfffffff
    f7e2a9dc8,0x18780000,0x0) + 0x3d4
    ##### Object: /lib/sparcv9/libc.so.1
    _thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x488
    </StackTrace>
    
    
    Further you will notice the statement that caused crash:
    
    2013-05-16-08.35.13.648315+120 I580736A781        LEVEL: Severe
    PID     : 17363                TID  : 934         PROC : db2sysc
    0
    INSTANCE: DB2INST1             NODE : 000         DB   :
    DB2INST1
    APPHDL  : 0-11094              APPID: 1.0.0.1.40739.130516054911
    AUTHID  : DB2ADMIN
    EDUID   : 934                  EDUNAME: db2agent (DB2INST1) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_sibling,
    probe:140
    MESSAGE : section stmt
    DATA #1 : Hexdump, 54 bytes
    0xFFFFFFFE0B3AD600 : 494E 5345 5254 2049 4E54 4F20 5864 7773
    INSERT INTO Xdws
    0xFFFFFFFE0B3AD610 : 436C 6F62 7320 2864 6F63 4E61 6D65 2C20
    Clobs (docName,
    0xFFFFFFFE0B3AD620 : 636F 6E74 656E 7429 2056 414C 5545 5320
    content) VALUES
    0xFFFFFFFE0B3AD630 : 283F 2C20 3F29
    (?, ?)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 fixpack 9.                        *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.7 fixpack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93892

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-07-03

  • Closed date

    2013-12-17

  • Last modified date

    2013-12-17

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

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

    IC93900 IC95502

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC93892

Modified date: 17 December 2013