|
Problem IT17747
|
Status: Closed |
DEADLATCHing during multiple index info pages creation in PureScale |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.10.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
