DB2 - Problem description
Problem IC97698 | Status: Closed |
DB2 TRAP IN SQLRA_CACHE_DEL_DEP_VAR() DUE TO FREE A FREED MEMORY | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - 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: crmm06 NODE : 003 DB : SCDM06 APPHDL : 0-35218 APPID: 10.105.130.88.3037.131028094743 AUTHID : LZ_IBAS EDUID : 54814 EDUNAME: db2agntp (SCDM06) 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: crmm06 NODE : 003 DB : SCDM06 APPHDL : 0-35218 APPID: 10.105.130.88.3037.131028094743 AUTHID : LZ_IBAS EDUID : 54814 EDUNAME: db2agntp (SCDM06) 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: "/scdm06/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: * * Users who use db2 v9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v9.7 fixpack 10 or above * **************************************************************** | |
Local Fix: | |
Solution | |
The problem is first fixed in db2 v9.7 fixpack 10 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.11.2013 11.11.2014 31.01.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP10 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.10 |