|
Problem IC74352
|
Status: Closed |
ERROR HANDLING DURING INDEX PAGE PREFETCHING MIGHT CAUSE INSTANCE TO ABEND |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
When index page prefetching encounters an error (for example a
bad index page error), the error handling might attempt to
double free a piece of memory, bringing down the instance.
Index page prefetching can occur during index reorg, or a normal
select.
The trapping process will produce the following callstack
<StackTrace>
0x0900000005378BE0 sqloCrashOnCriticalMemoryValidationFailure +
0x20
0x0900000005379590 sqlofmblkEx + 0x490
0x0900000006274E5C sqlbServiceLeafRequest__FP11SQLB_pfMisc +
0x14BC
0x090000000626F3E8
sqlbPFPrefetcherEntryPoint__FP16sqbPrefetcherEdu + 0xAA8
0x090000000627D90C RunEDU__16sqbPrefetcherEduFv + 0x2C
0x09000000054780B8 EDUDriver__9sqzEDUObjFv + 0x278
0x0900000005477DF0 sqlzRunEDU__FPcUi + 0x10
0x09000000053C7F4C sqloEDUEntry + 0x2CC
</StackTrace>
With error messages that look like the following:
2011-02-01-19.37.13.415181-360 I1863695A2348 LEVEL: Severe
PID : 15139044 TID : 34183 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000
EDUID : 34183 EDUNAME: db2pfchr (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbServiceLeafRequest,
probe:4479
DATA #1 : String, 9 bytes
leafFixCB
DATA #2 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes
accessMethod: SQLB_POOL_RELATIVE
fixMode: 2 SQLBOLD/SQLBOLDS
buffptr: 0x070000028fcac000
bpdPtr: 0x07000000725f3308
dmDebugHdl: 0
objectPageNum: 49407
empDiskPageNum: 4294967295
unfixFlags: 0
dirtyState: SQLBCLEAN
fixInfoFlags:
regEDUid: 0 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* When index page prefetching encounters an error (for example *
* a *
* bad index page error), the error handling might attempt to *
* *
* double free a piece of memory, bringing down the instance. *
* *
* Index page prefetching can occur during index reorg, or a *
* normal select. *
* *
* *
* *
* The trapping process will produce the following callstack *
* *
* *
* *
* <StackTrace> *
* *
* 0x0900000005378BE0 *
* sqloCrashOnCriticalMemoryValidationFailure +0x20 *
* *
* 0x0900000005379590 sqlofmblkEx + 0x490 *
* *
* 0x0900000006274E5C sqlbServiceLeafRequest__FP11SQLB_pfMisc *
* +0x14BC *
* *
* 0x090000000626F3E8 *
* sqlbPFPrefetcherEntryPoint__FP16sqbPrefetcherEdu + 0xAA8 *
* *
* 0x090000000627D90C RunEDU__16sqbPrefetcherEduFv + 0x2C *
* *
* 0x09000000054780B8 EDUDriver__9sqzEDUObjFv + 0x278 *
* *
* 0x0900000005477DF0 sqlzRunEDU__FPcUi + 0x10 *
* *
* 0x09000000053C7F4C sqloEDUEntry + 0x2CC *
* *
* </StackTrace> *
* *
* *
* *
* With error messages that look like the following: *
* *
* *
* *
* 2011-02-01-19.37.13.415181-360 I1863695A2348 LEVEL: *
* Severe *
* PID : 15139044 TID : 34183 PROC : *
* db2sysc *
* 0 *
* *
* INSTANCE: db2inst1 NODE : 000 *
* *
* EDUID : 34183 EDUNAME: db2pfchr (SAMPLE) 0 *
* *
* FUNCTION: DB2 UDB, buffer pool services, *
* sqlbServiceLeafRequest, probe:4479 *
* *
* DATA #1 : String, 9 bytes leafFixCB *
* *
* DATA #2 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes *
* *
* accessMethod: SQLB_POOL_RELATIVE *
* *
* fixMode: 2 SQLBOLD/SQLBOLDS *
* *
* buffptr: 0x070000028fcac000 *
* *
* bpdPtr: 0x07000000725f3308 *
* *
* dmDebugHdl: 0 *
* *
* objectPageNum: 49407 *
* *
* empDiskPageNum: 4294967295 *
* *
* unfixFlags: 0 *
* *
* dirtyState: SQLBCLEAN *
* *
* fixInfoFlags: *
* *
* regEDUid: 0 *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V9.5 fixpack 8 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Fixed in V9.5 Fixpack 8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75696
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.02.2011
14.07.2011
14.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
