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 |
|