|
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
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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
|
 |
