DB2 - Problem description
Problem IT21812 | Status: Closed |
PURESCALE MEMBER STUCK IN CRASH RECOVERY. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
This problem can occur where one member is stuck waiting for another member and dead latch occurs: Member 0 is stuck waiting for 0x0900000000117718 thread_wait + 0x98 0x090000000DC20568 sqloWaitEDUWaitPost + 0x3E4 0x090000000E0377C8 sqlplWaitOnWP__FCP9sqeBsuEduCP14SQLP_LOCK_INFOCP8SQLP_LRBCP15SQL P_LTRN_CHAINCbN25 + 0x18C0 0x090000000E03C2B8 sqlplrq__FP9sqeBsuEduP14SQLP_LOCK_INFO + 0x198 0x090000000E042DFCsqlbgbGetPagePLock_IUO__FP8SQLB_BPDP11SQLB_FIX _CBPUlPbUl + 0x5D0 0x090000000E042DFCsqlbgbGetPagePLock_IUO__FP8SQLB_BPDP11SQLB_FIX _CBPUlPbUl + 0x5D0 0x090000000DFC519C sqlbGetPageFromDisk__FP11SQLB_FIX_CBi + 0x4AC 0x090000000DEF019C sqlbfix__FP11SQLB_FIX_CB + 0x2944 , ./50266308.35772.000.stack.txt -- db2agnti(TEPPROD) -- 2016-08-23-23.10.53.740240(Signal #30) Which means its stuck in global buffer pool. On Member 1 if I look at the applications that are in OUW-Executing, see they are also stuck: 0x0900000000117718 thread_wait + 0x98 0x090000000C6B5124 getConflictComplex__17SQLO_SLATCH_CAS64FCUl + 0xED8 0x090000000C6B41F8 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x108 0x090000000C72A5D0 sqlbfix__FP11SQLB_FIX_CB + 0x204 0x090000000E4ED220 sqldcsl_objExtend__FP10SQLDCSL_WAUi + 0x23A8 0x090000000E4EFEC0 @163@sqldcsl_searchChunks__FP10SQLDCSL_WAUi + 0xFA8 0x090000000F7D6CC4 sqldcsl_findPageForSpace__FP13SQLDCSL_RSVCBUlT2 +0x143C 0x090000000E7CFA94 xmls_GetBlockForRegion__FP11XMLSTORE_CBUiPUsT3 +0x478 0x090000000E7CF6D8 xmls_GetBlockForRegion__FP11XMLSTORE_CBUiPUsT3 +0xBC | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT18421 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 24.10.2017 24.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |