|
Problem IC71662
|
Status: Closed |
An XML LOAD hangs with deadlatch between SP latch and INDPS latch |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
An XML LOAD hangs with deadlatch between SP latch and INDPS
latch.
An XML LOAD's db2lrid EDU holds an SP latch and is waiting for
an INDPS latch, while a db2lfrm EDU of the same LOAD (trying to
insert XML data) holds an INDPS latch and is waiting for an SP
latch. This leads to LOAD hanging. (This is a timing-dependent
problem that is relatively rare.)
The stack for db2lrid EDU looks like (this is from Linux; may
vary slightly on other platforms):
...
0x00002B5E93900865 sqloSpinLockConflict + 0x01c5
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E957ACD1A address: 0x00002B5E957ACD1A ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x0000000003354D1A ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E94C3859D
_Z25sqlpBeginINDPSLoggingModeP8sqeAgentP11SQLP_TENTRY + 0x0097
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9393D71A _Z11sqlpInitBFIP8sqeAgentmP9SQLP_LSN8 +
0x01aa
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E935AFB69
_Z20sqlbDMScheckObjAllocP16SQLB_OBJECT_DESCmiiPPjP12SQLB_GLOBALS
+ 0x0663
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E935AF399
_Z22sqlbDMSCheckAllocationP16SQLB_OBJECT_DESCmjPjP12SQLB_GLOBALS
+ 0x0069
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93E18AF8
_Z17sqlbLoadGetExtentP12SQLB_GLOBALSP16SQLB_OBJECT_DESCjPjPc +
0x00b4
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9532B617 address: 0x00002B5E9532B617 ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x0000000002ED3617 ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9532AAED
_Z21sqluCreateAndInitPageP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_D
ESCS4_S4_tbh
+ 0x0133
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93AE3543
_Z11sqlulGetRIDP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_DESCS4_S4_P
13SQLD_DPG_DATAlP18SQLU_DMRECORD_LISTPbPt
+ 0x0207
(/vbs/INST/lib/libdb2e.so.1)
...
The stack for db2lfrm EDU looks like:
...
0x00002B5E93900865 sqloSpinLockConflict + 0x01c5
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E957AB1E5 address: 0x00002B5E957AB1E5 ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x00000000033531E5 ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E94C2D328
_Z14sqlpGetSPLatchP8sqeAgentP15SQLP_SAVEPOINTSPii + 0x0088
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E957AB6A2 _Z9sqlpSpReqP8sqeAgentiPm + 0x02ee
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E935E3DE3
_Z13sqldRowInsertP8sqeAgenttthmiPP10SQLD_VALUEP13SQLD_TDATARECP8
SQLZ_RID
+ 0x0559
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93A2D159
_Z8sqlrinsrP8sqlrr_cbttitPP10SQLD_VALUEmP8SQLZ_RID + 0x0069
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E95149C0B _ZN16sqlrlCatalogScan6insertEv + 0x02f5
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9513AC70 _Z8sqlrlnsrittP10sqlrl_fldsP8SQLZ_RID +
0x0108
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9567B8D7
_Z19xmlcPathsAddToTableP8sqlrr_cbPKcj15SqlzXmlNodeKindPj +
0x021d
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9567BC13
_Z21xmlcGetPathIDInternalP8sqlrr_cbPKcj15SqlzXmlNodeKindPjbP11XM
LSTORE_CB
+ 0x01a7
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B5F5AD
_Z13xmlcGetPathIDP11XMLSTORE_CBPKcj15SqlzXmlNodeKindPj + 0x001b
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B5F6AC
_ZN12XmlrnNodeMgr9getPathIDEP14SqlzXmlQNameIDt15SqlzXmlNodeKindR
jbb
+ 0x0042
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B654CA
_ZN11XmlrnWriter19updateNodePathLevelEP14XmlrnParseNodejj +
0x007e
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B651EF
_ZN11XmlrnWriter12setNodeNamesEP14XmlrnParseNodejjjjPKv + 0x0075
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B64A60
_ZN11XmlrnWriter16processStartNodeEN12XmlrnNodeHdr8NodeKindEjjjj
PKv
+ 0x016c
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93B64012
_ZN11XmlrnWriter12startElementEjjjPK16XmlrpElementPSVI + 0x0028
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E956F7152
_ZN27XmlrpDocumentHandlerAdapter15tdhStartElementEjPKtS1_RKN9xml
4c_5_611RefVectorOfINS2_7XMLAttrEEEjPKNS2_17SchemaElementDeclEP2
3XmlrpElementPSVIAdapterb
+ 0x0060
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E956F5C00
_ZN27XmlrpDocumentHandlerAdapter12startElementERKN9xml4c_5_614XM
LElementDeclEjPKtRKNS0_11RefVectorOfINS0_7XMLAttrEEEjbb
+ 0x016a
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E99F7F880
_ZN9xml4c_5_612IGXMLScanner14scanStartTagNSERb + 0x08ba
(/vbs/INST/lib/libDB2xml4c.so.56)
0x00002B5E99F7BB92 _ZN9xml4c_5_612IGXMLScanner11scanContentEv +
0x012e
(/vbs/INST/lib/libDB2xml4c.so.56)
0x00002B5E99F7B6CF
_ZN9xml4c_5_612IGXMLScanner12scanDocumentERKNS_11InputSourceE +
0x00a1
(/vbs/INST/lib/libDB2xml4c.so.56)
0x00002B5E956FDE1A
_ZN18XmlrpParserScanner12scanDocumentER16XmlrpInputSource +
0x00a6
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E956FD590
_ZN15XmlrpParserImpl5parseER16XmlrpInputSource + 0x000a
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E956BD93D address: 0x00002B5E956BD93D ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x000000000326593D ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E956BC69C _Z19xmlrnInsertDocumentP11XmlrnIUD_CB +
0x0776
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E935CC70A
_Z21sqldInsertXMLDocumentP8sqeAgentP8SQLD_TCBiP10sqlz_valueP14SQ
LXMS_XDADESCS6_
+ 0x03c8
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9534E4C9 address: 0x00002B5E9534E4C9 ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x0000000002EF64C9 ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E9535065C
_Z22sqluLoadFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_
VALUEiP8SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB
+ 0x0ca8
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E93ADF9D4
_Z14sqluLoadFormatP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_VALUEiP8
SQLD_TCBPiPhP15SQLD_XOR_UPDATEP8SQLD_CCB
+ 0x004a
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E95329945
_Z15sqluFormatDMRecP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBjPP10SQLD
_VALUEP14sqlrg_mdc_infoP12SQLU_RP_INFOji
+ 0x04eb
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E952F4CB4 address: 0x00002B5E952F4CB4 ; dladdress:
0x00002B5E92458000 ; offset in lib: 0x0000000002E9CCB4 ;
(/vbs/INST/lib/libdb2e.so.1)
0x00002B5E952F0906 _Z8sqluldatPhj + 0x0a4e
(/vbs/INST/lib/libdb2e.so.1)
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* An XML LOAD hangs with deadlatch between SP latch and INDPS *
* latch. *
* *
* An XML LOAD's db2lrid EDU holds an SP latch and is waiting *
* for an INDPS latch, while a db2lfrm EDU of the same LOAD *
* (trying to insert XML data) holds an INDPS latch and is *
* waiting for an SP latch. This leads to LOAD hanging. (This *
* is a timing-dependent problem that is relatively rare.) *
* *
* The stack for db2lrid EDU looks like (this is from Linux; *
* may vary slightly on other platforms): *
* *
* ... *
* 0x00002B5E93900865 sqloSpinLockConflict + 0x01c5 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E957ACD1A address: 0x00002B5E957ACD1A ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x0000000003354D1A ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E94C3859D *
* _Z25sqlpBeginINDPSLoggingModeP8sqeAgentP11SQLP_TENTRY + *
* 0x0097 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9393D71A _Z11sqlpInitBFIP8sqeAgentmP9SQLP_LSN8 + *
* 0x01aa *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E935AFB69 *
* _Z20sqlbDMScheckObjAllocP16SQLB_OBJECT_DESCmiiPPjP12SQLB_GLOBA
* + 0x0663 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E935AF399 *
* _Z22sqlbDMSCheckAllocationP16SQLB_OBJECT_DESCmjPjP12SQLB_GLOBA
* + 0x0069 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93E18AF8 *
* _Z17sqlbLoadGetExtentP12SQLB_GLOBALSP16SQLB_OBJECT_DESCjPjPc *
* + 0x00b4 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9532B617 address: 0x00002B5E9532B617 ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x0000000002ED3617 ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9532AAED *
* _Z21sqluCreateAndInitPageP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE
* + 0x0133 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93AE3543 *
* _Z11sqlulGetRIDP13SQLUCACB_TYPEP8sqeAgentP13SQLO_QUE_DESCS4_S4
* + 0x0207 *
* (/vbs/INST/lib/libdb2e.so.1) *
* ... *
* *
* *
* The stack for db2lfrm EDU looks like: *
* *
* ... *
* 0x00002B5E93900865 sqloSpinLockConflict + 0x01c5 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E957AB1E5 address: 0x00002B5E957AB1E5 ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x00000000033531E5 ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E94C2D328 *
* _Z14sqlpGetSPLatchP8sqeAgentP15SQLP_SAVEPOINTSPii + 0x0088 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E957AB6A2 _Z9sqlpSpReqP8sqeAgentiPm + 0x02ee *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E935E3DE3 *
* _Z13sqldRowInsertP8sqeAgenttthmiPP10SQLD_VALUEP13SQLD_TDATAREC
* + 0x0559 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93A2D159 *
* _Z8sqlrinsrP8sqlrr_cbttitPP10SQLD_VALUEmP8SQLZ_RID + 0x0069 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E95149C0B _ZN16sqlrlCatalogScan6insertEv + 0x02f5 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9513AC70 _Z8sqlrlnsrittP10sqlrl_fldsP8SQLZ_RID + *
* 0x0108 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9567B8D7 *
* _Z19xmlcPathsAddToTableP8sqlrr_cbPKcj15SqlzXmlNodeKindPj + *
* 0x021d *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9567BC13 *
* _Z21xmlcGetPathIDInternalP8sqlrr_cbPKcj15SqlzXmlNodeKindPjbP11
* + 0x01a7 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B5F5AD *
* _Z13xmlcGetPathIDP11XMLSTORE_CBPKcj15SqlzXmlNodeKindPj + *
* 0x001b *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B5F6AC *
* _ZN12XmlrnNodeMgr9getPathIDEP14SqlzXmlQNameIDt15SqlzXmlNodeKin
* + 0x0042 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B654CA *
* _ZN11XmlrnWriter19updateNodePathLevelEP14XmlrnParseNodejj + *
* 0x007e *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B651EF *
* _ZN11XmlrnWriter12setNodeNamesEP14XmlrnParseNodejjjjPKv + *
* 0x0075 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B64A60 *
* _ZN11XmlrnWriter16processStartNodeEN12XmlrnNodeHdr8NodeKindEjj
* + 0x016c *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93B64012 *
* _ZN11XmlrnWriter12startElementEjjjPK16XmlrpElementPSVI + *
* 0x0028 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E956F7152 *
* _ZN27XmlrpDocumentHandlerAdapter15tdhStartElementEjPKtS1_RKN9x
* + 0x0060 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E956F5C00 *
* _ZN27XmlrpDocumentHandlerAdapter12startElementERKN9xml4c_5_614
* + 0x016a *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E99F7F880 *
* _ZN9xml4c_5_612IGXMLScanner14scanStartTagNSERb + 0x08ba *
* (/vbs/INST/lib/libDB2xml4c.so.56) *
* 0x00002B5E99F7BB92 *
* _ZN9xml4c_5_612IGXMLScanner11scanContentEv + 0x012e *
* (/vbs/INST/lib/libDB2xml4c.so.56) *
* 0x00002B5E99F7B6CF *
* _ZN9xml4c_5_612IGXMLScanner12scanDocumentERKNS_11InputSourceE
* + 0x00a1 *
* (/vbs/INST/lib/libDB2xml4c.so.56) *
* 0x00002B5E956FDE1A *
* _ZN18XmlrpParserScanner12scanDocumentER16XmlrpInputSource + *
* 0x00a6 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E956FD590 *
* _ZN15XmlrpParserImpl5parseER16XmlrpInputSource + 0x000a *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E956BD93D address: 0x00002B5E956BD93D ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x000000000326593D ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E956BC69C _Z19xmlrnInsertDocumentP11XmlrnIUD_CB + *
* 0x0776 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E935CC70A *
* _Z21sqldInsertXMLDocumentP8sqeAgentP8SQLD_TCBiP10sqlz_valueP14
* + 0x03c8 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9534E4C9 address: 0x00002B5E9534E4C9 ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x0000000002EF64C9 ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E9535065C *
* _Z22sqluLoadFormatFixedVarP8sqeAgentP13SQLD_TDATARECS2_PP10SQL
* + 0x0ca8 *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E93ADF9D4 *
* _Z14sqluLoadFormatP8sqeAgentP13SQLD_TDATARECS2_PP10SQLD_VALUEi
* + 0x004a *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E95329945 *
* _Z15sqluFormatDMRecP13SQLUCACB_TYPEP17SQLU_FORMATTER_CBjPP10SQ
* + 0x04eb *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E952F4CB4 address: 0x00002B5E952F4CB4 ; dladdress: *
* 0x00002B5E92458000 ; offset in lib: 0x0000000002E9CCB4 ; *
* (/vbs/INST/lib/libdb2e.so.1) *
* 0x00002B5E952F0906 _Z8sqluldatPhj + 0x0a4e *
* (/vbs/INST/lib/libdb2e.so.1) *
* ... *
****************************************************************
* RECOMMENDATION: *
* Upgrade to version 9.5 Fix Pack 7. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in version 9.5 Fix Pack 7. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.10.2010
21.12.2010
21.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
