IBM Support

IT17023: DEADLATCHing during multiple index info pages creation in PureScale

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In PureScale environment, if a table has multiple indexes
    defined, and these indexes are creating their respective info
    pages concurrently, db2 might get into a deadlatching situation.
    
    Conditions to get into deadlatching:
    - PureScale
    - Multiple indexes on the same table
    - info pages are being created at the same time.
    
    At the event of deadlatching, two agents will have call stack as
    follow:
    
    Agent 1 (Holds SQLO_LT_SQLD_TCB_LOTCH__tcbIndexValidityLotch,
    and Waits SQLO_LT_SQLD_TCB__loadInProgress):
    0x0900000000111B14 thread_wait + 0x94
    0x090000000952F8E4 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
    0x6E4
    0x090000000952FFE4 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x84
    0x090000000A9C4DD8
    sqldLoadTCBObjDesc__FP8sqeAgentP8SQLD_TCBP11SQLB_OBJECTPP16SQLB_
    OBJECT_DESCi + 0x1978
    0x090000000A9C69D8
    sqldFixTCBObj__FP8sqeAgentP11SQLB_OBJECTPP8SQLD_TCBPP16SQLB_OBJE
    CT_DESCiUiT6 + 0x338
    0x090000000A9ED890
    sqldRefreshObj__FP8sqeAgentP16SQLB_OBJECT_DESCUiT3 + 0x30
    0x090000000B34A408
    sqlbSearchOneSMPPage__FP8SQLB_BPDP12SQLB_POOL_CBP16SQLB_OBJECT_D
    ESCUiT4PUiPbPUcP11SQLB_FIX_CBP12SQLB_GLOBALS + 0x928
    0x090000000B34D440
    sqlbFixAndSearchOneSMPPage__FP12SQLB_POOL_CBP16SQLB_OBJECT_DESCU
    ibPUiPbT6UsP11SQLB_FIX_CBP12SQLB_GLOBALS + 0x2900
    0x090000000B34F488
    sqlbSearchSomeSMPs__FUiT1bPUiPbT4P12SQLB_POOL_CBP16SQLB_OBJECT_D
    ESCT5UsP11SQLB_FIX_CBP12SQLB_GLOBALS + 0x108
    0x090000000B32DA70
    sqlbAllocateExtent__FP12SQLB_GLOBALSP12SQLB_POOL_CBP16SQLB_OBJEC
    T_DESCPUiUs + 0x2CB0
    0x090000000AB71F2C
    sqlbDMScheckObjAlloc__FP16SQLB_OBJECT_DESCUliT3PPUiP12SQLB_GLOBA
    LS + 0x36C
    0x090000000B227100
    sqlbExtendObject__FP12SQLB_GLOBALSP16SQLB_OBJECT_DESCUiN23PFP8sq
    eAgentP9SQLB_PAGEPv_vPvT3PUiP11SQLB_FIX_CB + 0x49E0
    0x090000000B18ED4C
    sqliGetPages__FP7SQLI_CBPUcPUiP14SQLI_PAGE_DESCUiP17SQLI_FRPGMAP
    _DESCP11SQLI_SMPLOCiP11SQLB_FIX_CBP19SQLI_INX_PAGE_CACHE + 0xF
    0x090000000B18705C
    IPRA.$sqliSearchMapsAndGetPage__FP7SQLI_CBUlT2PUiP11SQLI_SMPLOCP
    19SQLI_INX_PAGE_CACHEP14SQLI_PAGE_DESC + 0x97C
    0x090000000B1859E0
    IPRA.$sqliGetPageFromCache__FP7SQLI_CBUlT2PUiP11SQLI_SMPLOCP19SQ
    LI_INX_PAGE_CACHEP14SQLI_PAGE_DESC + 0x2C0
    0x090000000B183194
    sqliGetPageBufferPool__FP7SQLI_CBPUiUiiP14SQLI_PAGE_DESC + 0x3D4
    0x090000000B1769DC
    sqliIP_GetNewPage__FP7SQLI_CBP14SQLI_PAGE_DESCPUi + 0x2BC
    0x090000000B1764D0
    sqliIP_CreatePage__FP7SQLI_CBP14SQLI_PAGE_DESCUi + 0x3E30
    0x090000000B1723C8
    sqliIP_FixPage__FP7SQLI_CBP14SQLI_PAGE_DESCiUiPUl + 0x1A8
    0x090000000D5ED95C sqliHardenJITS__FP7SQLI_CBP14SQLI_PAGE_DESCUl
    + 0x217C
    0x090000000A1EB59C
    sqliaddk__FP8sqeAgentP9SQLD_IXCBP8SQLD_KEY12SQLI_KEYDATAP14SQLP_
    LOCK_INFOP8SQLP_LRBUlP10SQLI_IXPCRPPv + 0x111C
    0x090000000BCF28C4
    sqldKeyInsert__FP13SQLD_DFM_WORKP16SQLD_TABLE_CACHET2P13SQLD_TDA
    TARECP15SQLD_TDATAREC32iUl + 0x3E4
    0x090000000BD00038
    sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
    0x1BD8
    0x090000000BC12B14
    sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
    oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xD4
    0x090000000FD605E4 sqlriisr__FP8sqlrr_cb + 0x2C4
    0x090000000BB12008 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x608
    0x090000000D424790 sqlrr_process_execute_request__FP8sqlrr_cbib
    + 0x5270
    
    Agent 2 (Holds SQLO_LT_SQLD_TCB__loadInProgress, Waits
    SQLO_LT_SQLD_TCB_LOTCH__tcbIndexValidityLotch )
    
    0x0900000000111B14 thread_wait + 0x94
    0x090000000952F8E4 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
    0x6E4
    0x090000000952FFE4 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x84
    0x090000000B175E2C
    sqliIP_CreatePage__FP7SQLI_CBP14SQLI_PAGE_DESCUi + 0x378C
    0x090000000B1723C8
    sqliIP_FixPage__FP7SQLI_CBP14SQLI_PAGE_DESCiUiPUl + 0x1A8
    0x090000000D5ED95C sqliHardenJITS__FP7SQLI_CBP14SQLI_PAGE_DESCUl
    + 0x217C
    0x090000000A1EB59C
    sqliaddk__FP8sqeAgentP9SQLD_IXCBP8SQLD_KEY12SQLI_KEYDATAP14SQLP_
    LOCK_INFOP8SQLP_LRBUlP10SQLI_IXPCRPPv + 0x111C
    0x090000000BCF28C4
    sqldKeyInsert__FP13SQLD_DFM_WORKP16SQLD_TABLE_CACHET2P13SQLD_TDA
    TARECP15SQLD_TDATAREC32iUl + 0x3E4
    0x090000000BD00038
    sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP8SQLZ_RIDPPv +
    0x1BD8
    0x090000000BC12B14
    sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEQ3_10sqlri_iudo11t_iud
    oFlags17t_iudoFlagsKernelP8SQLZ_RIDPPv + 0xD4
    0x090000000FD605E4 sqlriisr__FP8sqlrr_cb + 0x2C4
    0x090000000BB12008 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x608
    0x090000000D424790 sqlrr_process_execute_request__FP8sqlrr_cbib
    + 0x5270
    0x090000000EE8F420 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo
    + 0x5E0
    0x09000000102D6ABC
    sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x5BC
    0x090000001025B3E0
    sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
    interface + 0x280
    0x090000001025E450
    sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
    0x2250
    0x090000001022EDE4
    IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x964
    0x09000000102379B4
    sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
    0x090000001022D3D0
    IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13D0
    0x090000001022A834 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
    0x334
    0x09000000097113E0 RunEDU__8sqeAgentFv + 0xB40
    0x09000000096F4CA0 EDUDriver__9sqzEDUObjFv + 0x2E0
    0x09000000095E9694 sqloEDUEntry + 0x374
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 11.1 Fix Pack 1                               *
    ****************************************************************
    

Problem conclusion

  • First Fixed in DB2 11.1 Fix Pack 1
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT17023

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-09-13

  • Closed date

    2017-05-09

  • Last modified date

    2017-05-09

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

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

    IT17747 IT17748

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 June 2020