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
(?, ?) |
