DB2 - Problembeschreibung
Problem IC82699 | Status: Geschlossen |
MISSING ON RESETTING POINTER AFTER FREEING MEMORY BLOCK CAUSES UNEXPECTED CHECKING ON THE CONTENT OF POINTER. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 fix pack 7. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
This issue is fixed in DB2 version 9.7 fix pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87904 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 17.04.2012 05.10.2012 05.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |