DB2 - Problembeschreibung
Problem IC71662 | Status: Geschlossen |
An XML LOAD hangs with deadlatch between SP latch and INDPS latch | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in version 9.5 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 04.10.2010 21.12.2010 21.12.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP7 | |
Problem behoben lt. FixList in der Version | |
9.1.0.7 | |
9.5.0.7 |