|
Problem IT18421
|
Status: Closed |
PURESCALE MEMBER STUCK IN CRASH RECOVERY. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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: *
* PURESCALE MEMBER STUCK IN CRASH RECOVERY. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* First fixed in fix pack 9 of v10.5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in fix pack 9 of v10.5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.12.2016
27.09.2017
27.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
