DB2 - Problem description
Problem IT09175 | Status: Closed |
DB2 CRASH AT SQLNGMEMBLOCKLOOKUP | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
The trap file shows the following info: </Siginfo_t> Signal #11 (SIGSEGV): si_addr is 0x070000286FFFFFFC, si_code is 0x00000032 (SEGV_MAPERR:Address not mapped to object.) </SignalDetails> <Registers> IAR: 090000001C50ABCC MSR: A00000000000D032 LR: 090000001C50AE40 CTR: 0000000000000000 XER: 0000000C FPSCR: 82020000 CR: 88224044 GPR[00]: 0000000000000022 GPR[01]: 07000018FAFED9A0 GPR[02]: 09001000A42CE598 GPR[03]: 0000000000000000 GPR[04]: 07000029801BA660 GPR[05]: 070000287000000C GPR[06]: 07000018FAFEDB50 GPR[07]: 0000000000000000 GPR[08]: 0700001B05A502A0 GPR[09]: 090000001D1411A8 GPR[10]: 00000000FCEDDECF GPR[11]: 0000000000000000 GPR[12]: 090000001C50AE14 GPR[13]: 0000000126373800 GPR[14]: 09001000A42C8B78 GPR[15]: 0000000000000000 GPR[16]: 0000000000000000 GPR[17]: 0000000000000000 GPR[18]: 07000029807703F8 GPR[19]: 0000000000000000 GPR[20]: FFFFFFFF81BEFFFA GPR[21]: 070000298077C5E0 GPR[22]: 0000000000000002 GPR[23]: 0000000000000001 GPR[24]: 0000000000000000 GPR[25]: 0000000000000000 GPR[26]: 0700001B05A502A0 GPR[27]: 0000000000000000 GPR[28]: 070000288097DA50 GPR[29]: 070000298095E040 GPR[30]: 0000000000000000 GPR[31]: 0000000000000000 FPR[00]: 40B09C32C0000000 FPR[01]: 3FF0000000000000 FPR[02]: 40B09C32C0000000 FPR[03]: FFF8000000000209 FPR[04]: 3FF0000000000000 FPR[05]: 0000000000000000 FPR[06]: 41DFFFFFFFC00000 FPR[07]: 0000000000000000 FPR[08]: 0000000000000000 FPR[09]: 0000000000000000 FPR[10]: 0000000000000000 FPR[11]: 0000000000000000 FPR[12]: 0000000000000000 FPR[13]: 0000000000000000 FPR[14]: 0000000000000000 FPR[15]: 0000000000000000 FPR[16]: 0000000000000000 FPR[17]: 0000000000000000 FPR[18]: 0000000000000000 FPR[19]: 0000000000000000 FPR[20]: 0000000000000000 FPR[21]: 0000000000000000 FPR[22]: 0000000000000000 FPR[23]: 0000000000000000 FPR[24]: 0000000000000000 FPR[25]: 0000000000000000 FPR[26]: 0000000000000000 FPR[27]: 0000000000000000 FPR[28]: 0000000000000000 FPR[29]: 0000000000000000 FPR[30]: 0000000000000000 FPR[31]: 0000000000000000 </Registers> <POFDisassembly> 0x090000001C50ABAC : E9229E90 ld r9,-24944(r2) 0x090000001C50ABB0 : E8880090 ld r4,144(r8) 0x090000001C50ABB4 : 38A5000C addi r5,r5,12 0x090000001C50ABB8 : E9492AC0 ld r10,10944(r9) 0x090000001C50ABBC : 60000000 ori r0,r0,0x0 0x090000001C50ABC0 : 60000000 ori r0,r0,0x0 0x090000001C50ABC4 : 60000000 ori r0,r0,0x0 0x090000001C50ABC8 : 60210000 ori r1,r1,0x0 >>>> 0x090000001C50ABCC : 80E5FFF0 lwz r7,-16(r5) 0x090000001C50ABD0 : 38A5FFF0 addi r5,r5,-16 0x090000001C50ABD4 : 7C075040 cmpl cr0,r7,r10 0x090000001C50ABD8 : 4082FFF4 bne cr0,0x1C50ABCC # 4,bit2 0x090000001C50ABDC : E8E5FFF4 ld r7,-12(r5) 0x090000001C50ABE0 : 2C270000 cmpi cr0,r7,0 </POFDisassembly> <StackTrace> -------Frame------ ------Function + Offset------ 0x090000001C50ABCC sqlngMemBlockLookup__FP9sqlng_blkPvUlRP15sqlngSectObject + 0x11C 0x090000001C50AE3C sqlngSectSetPtrInternal__FP9sqlng_blkPvT2Ul + 0x148 0x090000001A681264 sqlng_build_DATAPARTMAP_obj__FP9sqlng_blk16sqlri_ctree_typeP9sql nq_ftbPP17sqlri_datapartmap + 0x500 0x090000001BB7D8E4 sqlng_build_TAOB_obj__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb + 0xE98 0x090000001A6B0F70 sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb + 0x4BC 0x090000001A6F3760 sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb@glue 1678 + 0x94 0x090000001A605700 sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator + 0x1A8 0x090000001C5065E0 sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 0x1B8 0x090000001C505C94 sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 0x208 0x090000001BB8B25C sqlng_process_delete_op__FP9sqlng_blkP19sqlno_plan_operator + 0x45C 0x090000001C5065E0 sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + 0x1B8 0x090000001C505C94 sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + 0x208 0x090000001C50595C sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator + 0x1E8 0x090000001C50339C sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x1AC 0x090000001C508530 sqlng_main__FP9sqlnq_qur + 0x6E4 0x090000001C9D153C sqlng_main__FP9sqlnq_qur@glue17A4 + 0x10C 0x090000001C9D10B0 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x308 0x090000001C8865C8 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x40 0x090000001C9ACE1C sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ LOCK_INFOP16sqlra_cached_varPiPUl + 0x7F4 0x090000001C9AA5B8 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x5E0 0x090000001C9A71B0 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x708 0x090000001C9A4470 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x140 0x090000001C9A4210 sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x25C 0x0900000019908110 executeSection__10pvmPackageFP5sqlcaUib + 0x670 0x090000001A2E5D60 executeQuery__3PVMFUib + 0x1A4 0x090000001A2E4A60 run__3PVMFv + 0x454 0x090000001A2E2298 pvm_entry + 0x460 0x090000001C76CB5C sqloInvokeFnArgs + 0xCC 0x090000001A17CE80 sqloInvokeFnArgs@glue4C1 + 0x78 0x0900000018CC20A4 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x1E0 0x090000001C76A3E0 sqlriInvokeInvoker__FP10sqlri_ufobb + 0x100 0x090000001C990EE8 sqlricall__FP8sqlrr_cb + 0x198 0x090000001C7E8B84 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x28 0x090000001C9A4874 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x544 0x090000001C9A4210 sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x25C 0x090000001C9A3EBC sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x850 0x090000001C9A35FC sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x1C 0x090000001C7A971C .sqljsParse.fdpr.clone.77__FP13sqljsDrdaAsCbP14db2UCinterfaceP8s qeAgentb + 0x240 0x090000001C791D44 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xAA8 0x090000001C586658 @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA0 0x090000001C5862CC @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x260 0x090000001C585D94 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x1EC 0x090000001C6643D8 RunEDU__8sqeAgentFv + 0x298 0x090000001C659D58 EDUDriver__9sqzEDUObjFv + 0xE4 0x090000001C661CFC sqloEDUEntry + 0x260 </StackTrace> | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users who use db2 v9.7 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to db2 v9.7 fixpack 11 or above * **************************************************************** | |
Local Fix: | |
Solution | |
The problem is first fixed in db2 v9.7 fixpack 11 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.05.2015 08.10.2015 08.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP11 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.11 |