IC89223: TRAP IN RECYCLEANDREINIT FOR AN INTERRUPTED XML QUERY IN DPF

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

Local fix

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                           *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in v9.7 Fixpack 8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89223

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-19

  • Closed date

    2013-03-28

  • Last modified date

    2013-03-28

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC91741

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC89223

Modified date:

2013-03-28

Translate my page

Machine Translation

Content navigation