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