|
Problem IC89223
|
Status: Closed |
TRAP IN RECYCLEANDREINIT FOR AN INTERRUPTED XML QUERY IN DPF |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
If ALL of the following conditions are true:
1) On DPF, a query is run that flows an XML column on a TQ
2) A table in the query has it's XML column defined with a
specific inline length.
For example:
create table tester(col1 xml inline length 2000)
3) The query is interrupted (for example, force applications, or
some other event or error that interrupts the query).
...then there is a chance that the cleanup logic for terminating
the query may reference an empty internal structure, cause the
trap/crash.
The trap will be sustained by DB2. The following is the stack
that corresponds to this problem:
-------Frame------ ------Function + Offset------
0x09000000050E2D60
recycleAndReinit__24SqlriXmlDeferredTempListFP30SqlriXmlDeferred
TempMemoryPool + 0x70
0x090000000544A5F8
m_decrDeferCount__27SqlriXmlDeferredTempManagerFP24SqlriXmlDefer
redTempListP8sqlrr_cbb + 0x1EC
0x0900000004D7EC48
unDeferDeleteXTemps__27SqlriXmlDeferredTempManagerFR8XMLS_XIDP8s
qlrr_cb + 0x194
0x0900000004D7E924
doGarbageCollect__29sqlktLargeObjCacheXMLValueMgrFR23sqlktLargeO
bjCacheValue + 0xA0
0x0900000004D7E3D8 evictionNotice__23sqlktLargeObjCacheValueFv +
0xA4
0x0900000004D81BF8
evictEntry__30sqlktLargeObjCacheGatewayOnTQAFUl@AF277_219 +
0x11C
0x0900000004D7E110
evictEntry__30sqlktLargeObjCacheGatewayOnTQAFUl + 0x1C
0x0900000004D4791C
destroyLargeObjCacheGateway__25sqlktLargeObjCacheGatewayFRP25sql
ktLargeObjCacheGateway + 0x88
0x0900000004764654 sqlktdrp__FP8sqeAgentP9sqlri_taoi + 0x704
0x0900000004766794 sqlktdrp__FP8sqeAgentP9sqlri_taoi@glueBCB +
0x78
0x0900000005242E3C sqlridrp__FP8sqlrr_cbP9sqlri_tao + 0x17C
0x0900000005ACE8E8 sqlridrp__FP8sqlrr_cbP9sqlri_tao@glueBC2 +
0x80
0x0900000005ACECC8 sqlricls_complex__FP8sqlrr_cbilN23 + 0x9C
0x0900000005BDA2C8 sqlricls_complex__FP8sqlrr_cbilN23@glue8B8 +
0x128
0x0900000005BDE968 @44@259738@sqlricls__FP8sqlrr_cbiN32 + 0xB0
0x0900000006C0250C sqlriecc__FP8sqlrr_cbilT3 + 0xEC4
0x0900000006F85260 sqlriCloseExecuteSectionComplex__FP8sqlrr_cbi
+ 0x4B8
0x090000000991CEE4
.sqlrr_process_execute_request.fdpr.clone.2089__FP8sqlrr_cbi +
0xB54
0x0900000005BB3630
.sqlrr_execute.fdpr.clone.1820__FP14db2UCinterfaceP9UCstpInfo +
0x208
0x0900000005BB2FA8
.sqljs_ddm_excsqlstt.fdpr.clone.201__FP14db2UCinterfaceP13sqljDD
MObject + 0xB80
0x0900000005BB1DE8
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x104
0x0900000005BB2184
.sqljsParse.fdpr.clone.31__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s
qeAgentb + 0x260
0x0900000005BB0C04 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x2EC
0x09000000059EE608
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA4
0x09000000049C1708
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x38C
0x09000000059EDCE0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x1D0
0x0900000005A61504 RunEDU__8sqeAgentFv + 0x2F0
0x0900000005A5B0CC EDUDriver__9sqzEDUObjFv + 0xD8
0x0900000005AC3A10 sqloEDUEntry + 0x260 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Any using XML in a DPF environment *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 Fixpack 8 or later *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
Problem first fixed in v9.7 Fixpack 8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC91741
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.12.2012
28.03.2013
28.03.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
