DB2 - Problem description
Problem IT17023 | Status: Closed |
DEADLATCHing during multiple index info pages creation in PureScale | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem 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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Fix Pack 1 * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows | |
Solution | |
First Fixed in DB2 11.1 Fix Pack 1 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.09.2016 09.05.2017 09.05.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
11.1.1.1 |