|
Problem IT27901
|
Status: Closed |
INDEX RECLAIM EXTENTS MAY HOLD ALTER TABLE LOCK INDEFINITELY WHILE PROCESSING A LOOP
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
During an index structure modification (i.e. index page split)
the index may enter a transient state in which REORG INDEX ...
RECLAIM EXTENTS may traverse a cycle in the index indefinitely
causing the REORG INDEX RECLAIM EXTENTS to hang indefinitely.
An Example Stack a snapshot of the reclaim traversing this cycle
in the index tree
-------Frame------ ------Function + Offset------
0x0900000057C37A34
IPRA.$sqlbAddPageToDirtyList__FP11SQLB_FIX_CBP8SQLB_BPDb + 0x7F4
0x0900000057C30D4C
IPRA.$sqlbFindPageInBPOrSim__FP11SQLB_FIX_CBiUlP15SQLB_BufferPoo
l + 0x114C
0x0900000057C2D45C sqlbfix__FP11SQLB_FIX_CB + 0x55C
0x0900000058CDDE44 sqlifix__FP7SQLI_CBP14SQLI_PAGE_DESCUii +
0x84
0x09000000599AAEFC sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
0x31FC
0x09000000599AB108
IPRA.$next_level__FP7SQLI_CBP11SQLI_SDGLOBUsUi + 0x28
0x09000000599A823C sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
0x53C
0x09000000599AB108
IPRA.$next_level__FP7SQLI_CBP11SQLI_SDGLOBUsUi + 0x28
0x09000000599A823C sqlischd__FP7SQLI_CBP11SQLI_SDGLOBUsUi +
0x53C
0x09000000599EEAA4 sqliTryToMovePage__FP7SQLI_CB + 0x324
0x09000000599EDCC8
sqliReclaimCollocatePages__FP15SQLI_RECLAIM_CB + 0x2E8
0x09000000599F195C
sqliReorgReclaimExtents__FP8sqeAgentP8SQLD_TCBUlP17SQLD_CREATEIN
X_CB + 0x97C
0x090000005D36B270
sqldCleanupIndexesAndOrReclaimExtents__FP8sqeAgentP17SQLD_CREATE
INX_CBUl + 0x950
0x090000005B0388C4
IPRA.$sqlrreorg_inx_cleanup_and_or_reclaim__FP8sqlrr_cbP8sqlrg_i
diP17SQLD_CREATEINX_CBP8sqlrg_pdUsUl + 0x1AA4
0x090000005B035474
sqlrreorg_indexes__FP8sqlrr_cbUsT2P8sqlrg_idT2iT6UlPUcT6T9T6C11s
qlrrstringT13_sUcP8sqlrg_pd + 0x3F54
0x090000005B02C2B4 sqlrreorg_sendinfo__FP14db2UCinterfacei +
0x2954
0x090000005D295900 sqlrr_reorg_indexes__FP14db2UCinterfacei +
0x1C0
0x090000005DC74040
sqlerKnownProcedure__FiPcPiP5sqldaT4P13sqlerFmpTableP8sqeAgentP5
sqlca + 0xA40
0x0900000057E3AAD0 sqlerCallDL__FP14db2UCinterfaceP9UCstpInfo +
0x1770
0x090000005DDE6844
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x4C4
0x090000005DD6B260
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x280
0x090000005DD6E2E4
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x2264
0x090000005DD3A89C
IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C
0x090000005DD43394
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4
0x090000005DD38960
IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13E0
0x090000005DD35DB4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x334
0x09000000570F21A0 RunEDU__8sqeAgentFv + 0xB60
0x09000000570D4D20 EDUDriver__9sqzEDUObjFv + 0x2E0
0x0900000056FC3C14 sqloEDUEntry + 0x374 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher *
**************************************************************** |
| Local Fix: |
Interrupt / force the current REORG INDEX .. RECLAIM EXTENTS and
retry |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.01.2019
20.01.2020
20.01.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
