home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList