|
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) |
