|
Problem IC75687
|
Status: Closed |
TRAP IN SQMRECORDHELPER DUE TO CORRUPTED MEMORY USED BY DB2 MONITORING AND EVENT LOCKING |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 engine might trap due to memory corruption while trying to
log a lockwait event.
You will see following message in db2diag.log:
2011-02-28-16.04.35.993380+060 E706908E1689 LEVEL: Severe
PID : 16260 TID : 46914024237376PROC :
db2sysc 0
INSTANCE: db2inst NODE : 000 DB :
SAMPLE
APPHDL : 0-5951 APPID:
*LOCAL.db2inst.110228150432
AUTHID : DB2INST
EDUID : 2416 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, SQO Memory Management,
sqloDiagnoseFreeBlockFailure, probe:999
MESSAGE : Memory validation failure, diagnostic file dumped.
DATA #1 : String, 28 bytes
Corrupt pool free tree node.
DATA #2 : File name, 40 bytes
16260.46914024237376.mem_diagnostics.txt
CALLSTCK:
[0] 0x00002AAAAB9BF964 pdLog + 0x398
[1] 0x00002AAAAD38C383
_ZN13SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrashEmPKc +
0x241
[2] 0x00002AAAAE06F503
_ZN13SQLO_MEM_POOL10MemTreeGetEmmPPvPP17SqloChunkSubgroupPP12SMe
mLostNode
+ 0x4A9
[3] 0x00002AAAAE06FB6F
_ZN13SQLO_MEM_POOL19allocateMemoryBlockEmmmjmPPvPP17SqloChunkSub
groupPP12SMemLostNodeP12SMemLogEvent
+ 0x295
[4] 0x00002AAAAE06D6DD sqlogmblkEx + 0x4E3
[5] 0x00002AAAABC0EA30
_ZN15sqmRecordHelperC9EP19sqmFastWriterRecord14sqmRecordTypesmRi
+ 0xCA
[6] 0x00002AAAABC0E964
_ZN15sqmRecordHelperC1EP19sqmFastWriterRecord14sqmRecordTypesmRi
+ 0x6
[7] 0x00002AAAABC392BA
_ZN13sqmLockEvents23collectPastActivityInfoEP9sqeBsuEduP19sqmFas
tWriterRecordP19sqlrr_past_activityjmbb
+ 0xC6
[8] 0x00002AAAABC38D90
_ZN13sqmLockEvents22collectOwnerActivitiesEP9sqeBsuEduP14sqeAppl
icationP21sqmFastWriterQueueMgrP12sqzDataChainI19sqmFastWriterR
+ 0x2C2
[9] 0x00002AAAACA54A49
_ZN13sqmLockEvents21createLockOwnerRecordEP9sqeBsuEdujP14SQLP_LO
CK_INFOP18sqlrw_threshold_cbP12sqzDataChainI19sqmFastWriterReco
+ 0x711
The agent stack looks like:
sqloCrashOnCriticalMemoryValidationFailure
SQLO_MEM_POOL32diagnoseMemoryCorruptionAndCrash
SQLO_MEM_POOL10MemTreeGet
SQLO_MEM_POOL19allocateMemoryBlock
sqlogmblkEx
sqmRecordHelper
sqmRecordHelper
sqmLockEvents
sqmLockEvents
sqmLockEvents
sqmLockEvents
sqlplnfd
sqlplrq
sqldLockTable
sqldScanOpen
sqlriopn
sqlritaSimplePerm |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Problem Description above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.7 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
|
| 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 |
First fixed in DB2 Version 9.7 ix Pack 5. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75690
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.04.2011
09.12.2011
09.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
