|
Problem IC77934
|
Status: Closed |
SEG-V IN SQLRA_HASH_DEL_STMT OR SQLRA_CACHE_DEL_VAR FUNCTIONS DURING PACKAGE CACHE EVICTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
A trap and instance shutdown can be seen with the following
signature in the db2diag.log
2011-07-13-16.00.12.337415-240 I16730848A1839 LEVEL: Severe
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:10
MESSAGE : Possible memory corruption detected.
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes
0x820F0002
DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8
bytes
0x00000000000000e0
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes
Object not dumped: Address: 0x00000000000000C8 Size: 24 Reason:
Possible offset from NULL pointer
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes
Object not dumped: Address: 0x00000000000000E0 Size: 48 Reason:
Possible offset from NULL pointer
CALLSTCK:
[0] 0x0900000010D1F8D4 pdLog + 0x88
[1] 0x0900000011245E90
@78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0xF0
[2] 0x0900000011245CD0
sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb@glue6CF + 0x78
[3] 0x0900000010C283A0 sqlofmblkEx + 0x4D4
[4] 0x0900000010F8C944
sqlra_hash_del_stmt__FP13SQLO_MEM_POOLP17sqlra_anchor_stmtP17sql
ra_cached_stmtPi
+ 0x74
[5] 0x0900000010F8C7D0
sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq
lra_cached_stmtPi
+ 0x28
[6] 0x09000000109C7348
sqlra_cache_del_empty_stmt__FP8sqlrr_cbP17sqlra_anchor_stmtP17sq
lra_cached_stmtPi@glue111B
+ 0x70
[7] 0x0900000011D3E478
sqlra_cache_del_var__FP8sqlrr_cbP16sqlra_cached_variP23sqlra_cac
hed_dependency
+ 0x208
[8] 0x09000000137FD804
sqlra_csm_drop_var__FP8sqlrr_cbPP16sqlra_cached_variP23sqlra_cac
hed_dependencyPi
+ 0x428
[9] 0x0900000013803D44
sqlra_csm_flush_vars_anchor__FP8sqlrr_cbP17sqlra_anchor_stmt +
0x25C
other segmentation faults in sqlra_ code may also result,
including ones with
sqlra_cache_del_var
in the stack |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All server types *
****************************************************************
* PROBLEM DESCRIPTION: *
* seg-v in sqlra_hash_del_stmt or sqlra_cache_del_var *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP5 or subsequent fix pack. *
**************************************************************** |
| Local Fix: |
increasing package cache size (pckcachesz) may decrease
likelihood of hitting this problem. |
| available fix packs: |
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 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem fixed in DB2 Version 9.7 Fix Pack 5 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC77940
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.08.2011
27.02.2012
20.09.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP9,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
