DB2 - Problem description
| Problem IC71477 | Status: Closed |
INSTANCE PANICS WITH ERROR "EXPECTED LATCH TO BE HELD" | |
| product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
| Problem description: | |
Instance panics and crashes with the following message in the
db2diag.log
2010-07-27-12.25.44.623481+120 E58407708A2265 LEVEL: Severe
(OS)
PID : 2302062 TID : 1 PROC :
db2pfchr 1
INSTANCE: dwhprod NODE : 001
FUNCTION: DB2 UDB, SQO Latch Tracing,
SQLO_SLATCH_CAS64::releaseConflictComple, probe:330
MESSAGE :
ZRC=0x870F011E=-2029059810=SQLO_LATCH_ERROR_EXPECTED_HELD
"expected latch to be held."
CALLED : OS, -, unspecified_system_function
DATA #1 : String, 39 bytes
Attempting to unlock an invalid latch:
DATA #2 : File name, 16 bytes
sqloLatchCAS64.C
DATA #3 : Source file line number, 8 bytes
980
DATA #4 : Codepath, 8 bytes
4
DATA #5 : String, 125 bytes
0x0000000000000000: {
held X: 0
reserved for X: 0
shared holders: 0
firstSharIndex: 0x0
firstExclIndex: 0x0
}
DATA #6 : LatchMode, PD_TYPE_LATCH_MODE, 8 bytes
0x0 (invalid mode)
DATA #7 : String, 394 bytes
{
state = 0x0000000000000000
= {
held X: 0
reserved for X: 0
shared holders: 0
firstSharIndex: 0x0
firstExclIndex: 0x0
}
starve X mode = true
xWaitCount = 0
requestCount = 0
identity = SQLB_BPD::bpdLatch (38)
}
DATA #8 : Hexdump, 16 bytes
0x0780000222E869D0 : 0002 2600 0001 0000 0026 0001 0000 0000
..&......&......
CALLSTCK:
[0] 0x090000000305FEC0
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7
+ 0x298
[1] 0x090000000305FB44
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7@glueA3
+ 0x98
[2] 0x0900000002F0A308
releaseConflictComplex__17SQLO_SLATCH_CAS64Fv + 0x33C
[3] 0x09000000027989A4
sqlbBlockAreaErrorUnchain__FP20SQLB_BLOCK_VICTIM_CBUiP11SQLB_pfM
isc
+ 0x10
[4] 0x0900000002798888
sqlbBlockAreaErrorHandler__FiP20SQLB_BLOCK_VICTIM_CBUiPcP16SQLB_
OBJECT_DESCP11SQLB_pfMisc
+ 0x24C
[5] 0x0900000003308260
sqlbProcessRange__FP16SQLB_OBJECT_DESCUiT2P11SQLB_pfMisc + 0x50C
[6] 0x0900000005A62E00
.sqlbServiceRangeRequest__FP11SQLB_pfMisc_fdprpro_clone_263 +
0x11C
[7] 0x09000000036B58BC sqlbPFPrefetcherEntryPoint__FPcUi +
0x6C
[8] 0x09000000035FB668
sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270
[9] 0x09000000035F9AF0 @49@sqloRunGDS__Fv + 0xDC
Trap file shows the following function stack trace
</Siginfo_t>
Signal #36 (SIGPRE): si_code is 0 (SI_USER:Sent by kill,
sigsend, raise.) si_pid is 2302062, si_uid is 18, si_value is
00000000
</SignalDetails>
0x09000000033F7200 sqloDumpEDU + 0x14
0x090000000275546C sqle_panic__Fv + 0x34
0x090000000305FEC8
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7
+ 0x2A0
0x090000000305FB44
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7@glueA3
+ 0x98
0x0900000002F0A308 releaseConflictComplex__17SQLO_SLATCH_CAS64Fv
+ 0x33C
0x09000000027989A4
sqlbBlockAreaErrorUnchain__FP20SQLB_BLOCK_VICTIM_CBUiP11SQLB_pfM
isc
+ 0x10
0x0900000002798888
sqlbBlockAreaErrorHandler__FiP20SQLB_BLOCK_VICTIM_CBUiPcP16SQLB_
OBJECT_DESCP11SQLB_pfMisc
+ 0x24C
0x0900000003308260
sqlbProcessRange__FP16SQLB_OBJECT_DESCUiT2P11SQLB_pfMisc + 0x50C
0x0900000005A62E00
.sqlbServiceRangeRequest__FP11SQLB_pfMisc_fdprpro_clone_263 +
0x11C
0x09000000036B58BC sqlbPFPrefetcherEntryPoint__FPcUi + 0x6C
<LatchInformation>
Holding Latch type:
(SQLO_LT_SQLB_HASH_BUCKET_GROUP_HEADER__groupLatch) - Address:
(780000245873d00), Line: 2802, File: sqlbpfchr.C
Holding Latch type: (SQLO_LT_SQLD_TCB__datExist) - Address:
(7800002a1ff28f0), Line: 7786, File: sqldtcb.C
</LatchInformation> | |
| Problem Summary: | |
Users Effected: All Users Problem Description: Instance crashes with info listed above. | |
| Local Fix: | |
| available fix packs: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
| Solution | |
First fixed in DB2 Version 9.7, Fix Pack 4 | |
| Workaround | |
Upgrade to DB2 Version V9.7 FP4 | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.09.2010 02.05.2011 15.09.2011 |
| Problem solved at the following versions (IBM BugInfos) | |
9.7., 9.7.FP4 | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 9.7.0.4 |
|