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