|
Problem IC64890
|
Status: Closed |
SELF-DEADLATCH (INDMS LATCH) DURING RECREATE XML INDEX |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Under very rare circumstances a process can dead-latching
itsself
EDU name : db2agent (DUC8ECX2) 0
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000008F6022C getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x264
0x0900000008EBCFC8 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x104
0x09000000098FCC7C
sqloltch_ns_track__FCP13sqlo_latch_nsCUlCPCcT2P16SQLO_LATCH_TABL
ECbC14SQLO_LT_VALUES@glueA12 + 0x200
0x0900000008EB112C
sqldRowInsert__FP8sqeAgentUsT2UcUliPP10SQLD_VALUEP13SQLD_TDATARE
CP8SQLZ_RID + 0xF8
0x0900000008EECAC0
sqlrinsr__FP8sqlrr_cbUsT2iT2PP10SQLD_VALUEUlP8SQLZ_RID + 0x90
0x090000000A91E44C insert__16sqlrlCatalogScanFv + 0x25C
0x0900000009D030A8 sqlrlnsr__FiUsT2P10sqlrl_fldsP8SQLZ_RID +
0xF4
0x0900000008319334
xmlcPathsAddToTable__FP8sqlrr_cbPCcUi15SqlzXmlNodeKindPUi +
0x730
0x090000000AA0D2A8
xmlcGetPathIDInternal__FP8sqlrr_cbPCcUi15SqlzXmlNodeKindPUibP11X
MLSTORE_CB + 0x210
0x09000000080190EC
recreateColumnPathsIndex__13XmlrnNodeInfoFP17xmlDataDescriptor +
0x8C0
0x0900000008017E70
sqldPopulatePathsXIX__FP22SQLD_CREATE_INXPRED_CB + 0x294
0x0900000008F18020
sqldEvalDataPred__FP13SQLD_DFM_WORKPUlP10SQLD_DPRED + 0x414
0x0900000008ED8488 sqldReadNorm__FP13SQLD_DFM_WORKl + 0x80
0x0900000008EB3A88 @101@sqldFetchNext__FP13SQLD_DFM_WORK + 0x19C
0x0900000008EBC3C0 sqldFetchNext__FP13SQLD_DFM_WORK@glueA88 +
0x70
0x0900000008EBC284 sqldfrd__FP13SQLD_DFM_WORK + 0x238
0x0900000008ED7FA8 sqldfrd__FP13SQLD_DFM_WORK@glue4BC + 0x70
0x0900000008EE26A0
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT
3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x7C
0x09000000085803A8
@101@sqldSerialIndex__FP8sqeAgentP17SQLD_CREATEINX_CBP8SQLD_TCBP
9SQLD_IXCB + 0xB1C
0x090000000857C7D0
sqldCreateIndex__FP8sqeAgentP17SQLD_CREATEINX_CB + 0x1A7C
0x0900000009BB42A0
sqldIndexCreate__FP8sqeAgentP17SQLD_CREATEINX_CB + 0x45C
0x090000000A713DAC
sqlrlRecreateSingleIndex__FP8sqlrr_cbUsT2P8sqlrg_idP25sqlyk_keyX
form_threadListiPUcT6T7T6T2UcT2P17SQLD_CREATEINX_CB + 0x158
0x090000000A713810
sqlrlRecreateIndexObject__FP8sqlrr_cbP8sqlrg_idP17SQLD_CREATEINX
_CBUsT4P25sqlyk_keyXform_threadListP23SqlthJobProgressMonitor +
0x740
0x0900000009BB6490
sqlrlRecreateIndexes__FP8sqlrr_cbUsT2P8sqlrg_idiPUcT5T6T5T2PsUcP
8SqlthJobT2P14SQLP_LOCK_INFOP8SQLP_LSN + 0x9EC
0x0900000009C722B4 sqlrlrci__FP8sqlrr_cbUsT2 + 0x2EC
0x0900000009C71F10 sqlrlrci__FP8sqlrr_cbUsT2@glueD90 + 0x78
0x0900000008F553C8 sqlritaSimplePerm__FP8sqlrr_cb + 0x1BC
</StackTrace>
<LatchInformation>
Waiting on latch type: (SQLO_LT_SQLD_APP_CB__inDMSlatch) -
Address: (700000250038390), Line: 5587, File:
/wsdb/db2_v95fp3/aix64nocc/special_21824/engn/include/sqldinline
s.h
Holding Latch type: (SQLO_LT_SQLD_APP_CB__inDMSlatch) - Address:
(700000250038390), Line: 5587, File:
/wsdb/db2_v95fp3/aix64nocc/special_21824/engn/include/sqldinline
s.h
Holding Latch type: (SQLO_LT_SQLD_TCB__loadInProgress) -
Address: (700000262a29498), Line: 6923, File: sqldmcri.C
Holding Latch type: (SQLO_LT_SQLP_SAVEPOINTS__spLatch) -
Address: (7000002602e6048), Line: 177, File: sqlpsvpt.C
</LatchInformation>
This only occurs under following very rare circumstances:
- corrupted table: document id 0
- index marked bad so that recreate is neccessary.
If INDEXREC is set to RESTART, no connections to DB are
possible.
Use INDEXREC ACCESS to be able to connect to DB. |
| Problem Summary: |
USERS AFFECTED: All
PROBLEM DESCRIPTION:
see ERROR DESCRIPTION
PROBLEM SUMMARY:
see ERROR DESCRIPTION |
| Local Fix: |
n/a |
| available fix packs: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The complete fix for this problem first appears in DB2 UDB
Version 9.7 FixPak 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.12.2009
24.09.2010
24.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
