|
Problem IC82699
|
Status: Closed |
MISSING ON RESETTING POINTER AFTER FREEING MEMORY BLOCK CAUSES UNEXPECTED CHECKING ON THE CONTENT OF POINTER. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7 fix pack 7. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
This issue is fixed in DB2 version 9.7 fix pack 7. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC87904
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.04.2012
05.10.2012
05.10.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP7
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.7
|
 |
