home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT03396 Status: Closed

DB2 TRAP IN SQLRA_CACHE_DEL_DEP_VAR() DUE TO FREE A FREED MEMORY

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
db2diag.log shows the following error: 
 
2013-10-28-17.49.38.151099+480 I345794540A2028    LEVEL: Severe 
PID     : 406192               TID  : 54814       PROC : db2sysc 
3 
INSTANCE: INST1               NODE : 003         DB   : TESTDB 
APPHDL  : 0-35218              APPID: APPID1 
AUTHID  : LZ_IBAS 
EDUID   : 54814                EDUNAME: db2agntp (TESTDB) 3 
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 
0x070000045ae0b040 
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 
0x070000045AE0B028 : FAB0 7000 0045 ADD0 3332 E287 053F 5AAF 
..p..E..32...?Z. 
0x070000045AE0B038 : FAB0 7000 0045 ADD0 
..p..E.. 
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 
0x070000045AE0B040 : 0000 0000 0000 0000 0700 0004 4873 36B8 
............Hs6. 
0x070000045AE0B050 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x070000045AE0B060 : 0000 0000 0000 0000 DB2C AFE8 0000 1CD0 
.........,...... 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x090000000FB0AA84 pdLog + 0xF4 
  [1] 0x090000001154AC08 
@78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0x14C 
  [2] 0x090000000F924080 sqlofmblkEx + 0x88 
  [3] 0x09000000128A6BF4 
sqlra_cache_del_dep_var__FP8sqlrr_cbPP18sqlra_list_dep_vari + 
0x378 
  [4] 0x09000000128B0098 
sqlra_inval_obj_hard__FP8sqlrr_cbP23sqlra_anchor_dependencyP23sq 
lra_cached_dependencyUiiPUsT4 + 0x228 
  [5] 0x09000000128AD5F0 
sqlra_inval_vars_hard__FP8sqlrr_cbUcPUcUiT3sT4iPUsT4 + 0x984 
  [6] 0x09000000128CAD24 
sqlra_event_inval_hard__FP8sqlrr_cbP20sqlr_rpc_apm_request + 
0x208 
  [7] 0x0900000011750888 
sqlra_execute_event__FP8sqlrr_cbP20sqlr_rpc_apm_request + 0x478 
  [8] 0x09000000117A7E00 
sqlrk_apm_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtUiPP15SQLR_RPCME 
SSAGE + 0x2B8 
  [9] 0x09000000107D8C30 sqlrr_rpc_router__FP8sqlrr_cb + 0x65C 
 
2013-10-28-17.49.39.112927+480 E345826909A1547    LEVEL: Severe 
PID     : 406192               TID  : 54814       PROC : db2sysc 
3 
INSTANCE: INST1               NODE : 003         DB   : TESTDB 
APPHDL  : 0-35218              APPID: APPID1 
AUTHID  : LZ_IBAS 
EDUID   : 54814                EDUNAME: db2agntp (TESTDB) 3 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:999 
MESSAGE : Memory validation failure, diagnostic file dumped. 
DATA #1 : String, 21 bytes 
Corrupt block header. 
DATA #2 : File name, 32 bytes 
406192.54814.mem_diagnostics.txt 
CALLSTCK: (Static functions may not be resolved correctly, as 
they are resolved to the nearest symbol) 
  [0] 0x090000000FB0AA84 pdLog + 0xF4 
  [1] 0x0900000011540DC8 
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb + 
0x290 
  [2] 0x090000001154B19C 
@78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0x6E0 
  [3] 0x090000000F924080 sqlofmblkEx + 0x88 
  [4] 0x09000000128A6BF4 
sqlra_cache_del_dep_var__FP8sqlrr_cbPP18sqlra_list_dep_vari + 
0x378 
  [5] 0x09000000128B0098 
sqlra_inval_obj_hard__FP8sqlrr_cbP23sqlra_anchor_dependencyP23sq 
lra_cached_dependencyUiiPUsT4 + 0x228 
  [6] 0x09000000128AD5F0 
sqlra_inval_vars_hard__FP8sqlrr_cbUcPUcUiT3sT4iPUsT4 + 0x984 
  [7] 0x09000000128CAD24 
sqlra_event_inval_hard__FP8sqlrr_cbP20sqlr_rpc_apm_request + 
0x208 
  [8] 0x0900000011750888 
sqlra_execute_event__FP8sqlrr_cbP20sqlr_rpc_apm_request + 0x478 
  [9] 0x09000000117A7E00 
sqlrk_apm_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtUiPP15SQLR_RPCME 
SSAGE + 0x2B8 
 
2013-10-28-17.54.52.556724+480 E368929501A1258    LEVEL: 
Critical 
PID     : 406192               TID  : 54814       PROC : db2sysc 
3 
INSTANCE: INST1               NODE : 003         DB   : TESTDB 
APPHDL  : 0-35218              APPID: APPID1 
AUTHID  : LZ_IBAS 
EDUID   : 54814                EDUNAME: db2agntp (TESTDB) 3 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:90 
MESSAGE : ADM14011C  A critical failure has caused the following 
type of error: 
          "Trap". The DB2 database manager cannot recover from 
the failure. 
          First Occurrence Data Capture (FODC) was invoked in 
the following 
          mode: "Automatic". FODC diagnostic information is 
located in the 
          following directory: 
 
"/testdb/crmm06/sqllib/db2dump/FODC_Panic_2013-10-28-17.49.38.99 
8897_ 
          0003/". 
DATA #1 : Signal Number Recieved, 4 bytes 
11 
DATA #2 : Siginfo, 64 bytes 
0x070000058AC09DC0 : 0000 000B 0000 0000 0000 0033 0000 0000 
...........3.... 
0x070000058AC09DD0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x070000058AC09DE0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x070000058AC09DF0 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
 
The trap file shows: 
 
</Siginfo_t> 
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is 
0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.) 
</SignalDetails> 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000011542028 sqloCrashOnCriticalMemoryValidationFailure + 
0x34 
0x0900000011540DD0 
diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb + 
0x298 
0x090000001154B19C 
@78@sqloDiagnoseFreeBlockFailure__FP8SMemFBlkCb + 0x6E0 
0x090000000F924080 sqlofmblkEx + 0x88 
0x09000000128A6BF4 
sqlra_cache_del_dep_var__FP8sqlrr_cbPP18sqlra_list_dep_vari + 
0x378 
0x09000000128B0098 
sqlra_inval_obj_hard__FP8sqlrr_cbP23sqlra_anchor_dependencyP23sq 
lra_cached_dependencyUiiPUsT4 + 0x228 
0x09000000128AD5F0 
sqlra_inval_vars_hard__FP8sqlrr_cbUcPUcUiT3sT4iPUsT4 + 0x984 
0x09000000128CAD24 
sqlra_event_inval_hard__FP8sqlrr_cbP20sqlr_rpc_apm_request + 
0x208 
0x0900000011750888 
sqlra_execute_event__FP8sqlrr_cbP20sqlr_rpc_apm_request + 0x478 
0x09000000117A7E00 
sqlrk_apm_router__FP8sqlrr_cbP16sqlkdRqstRplyFmtUiPP15SQLR_RPCME 
SSAGE + 0x2B8 
0x09000000107D8C30 sqlrr_rpc_router__FP8sqlrr_cb + 0x65C 
0x0900000011459AD8 
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x5FC 
0x09000000107CAFE4 sqleSubRequestRouter__FP8sqeAgentPUiT2 + 
0x3FC 
0x090000000F6BEF60 sqleProcessSubRequest__FP8sqeAgent + 0x2D5C 
0x090000000FDDFBEC RunEDU__8sqeAgentFv + 0xEC 
0x090000000F86D418 EDUDriver__9sqzEDUObjFv + 0xF4 
0x090000000F8641CC sqloEDUEntry + 0x264 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* User who use db2 v10.1 fixpack 4 or earlier fixpack          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2 v10.1 fixpack 5 or above                      * 
****************************************************************
Local Fix:
Solution
The problem is first fixed in db2 v10.1 fixpack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.07.2014
15.07.2015
31.01.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList