DB2 - Problem description
Problem IT34696 | Status: Closed |
MEMORY CRASH/TRAP WITH LOCAL PREDICATE ON OJ SUBSELECT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
db2 query may abend when the following conditions are met: -There is at least one inner join -There is at least one outer join under the inner join -There are multiple local predicates on one of the branches of outer join stack of trap shows: -------Frame------ ------Function + Offset------ 0x0900000000536014 pthread_kill + 0xD4 0x0900000000535864 _p_raise + 0x44 0x09000000000398E8 raise + 0x48 0x09000000000562E4 abort + 0xC4 0x090000001C0B85F8 sqloExitEDU + 0x298 0x090000001C125144 sqle_panic__Fi + 0x7A4 0x090000001C0D7CA8 sqloCrashOnCriticalMemoryValidationFailure + 0x48 0x090000001C143270 diagnoseMemoryCorruptionAndCrash__13SQLO_MEM_POOLFUlCPCcCb + 0x4F0 0x090000001C14AA44 MemTreeGet__13SQLO_MEM_POOLFCUlT1PP17SqloChunkSubgroupPUi + 0x864 0x090000001C142BBC allocateMemoryBlock__13SQLO_MEM_POOLFCUlT1UiT1PP17SqloChunkSubgr oupPUiCP12SMemLogEvent + 0xFC 0x090000001C0D2FA0 sqloGetMemoryBlockExtended + 0xAA0 0x090000001F8A5F40 IPRA.$sqlnr_reorder_OJ_qgm_action__FCP9sqlnq_oprR17sqlnq_qunElem ListT2PP13sqlnq_deplistPiRP9sqlnq_qtbCP3loc + 0x180 0x090000001F8975E4 sqlnr_reorder_IJ_qgm__FCP9sqlnq_qunCP9sqlnq_oprPP13sqlnq_deplist PiRP9sqlnq_qtbCP3loc + 0x1DE4 0x090000001F86A3B0 sqlnr_qrwprep_phase2__FP3locPi + 0x3B50 0x090000001F8EA84C sqlnr_prep2_action__FP10sqlnr_qrwaPiP14sqlnr_progress + 0x4C 0x090000001F77DC98 sqlnr_comp__FPiiP16sqlnr_rule_stateP10sqlnr_qrwaP14sqlnr_progres s + 0x218 0x090000001F77E044 sqlnr_seq__FPiP10sqlnr_qrwaP14sqlnr_progressP12sqlnr_rclass + 0xC4 0x090000001F77E548 sqlnr_rcc__FiP10sqlnr_qrwaPiP14sqlnr_progress + 0x308 0x090000001F8EBE34 sqlnr_exe__FP9sqlnq_qur + 0x854 0x090000001F9794A0 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_enviT7PP9sqlnq_qur + 0x74C0 0x090000001F971F68 sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq lrr_cmpl_env + 0x28 0x0900000021930EE4 sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_ LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xBE4 0x090000001CE267E4 sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14 SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0xA84 0x0900000021922C70 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xC50 0x090000001E1D9920 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x3120 0x090000001E18057C sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x87C 0x09000000235ADBE0 sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x1220 0x09000000235221C8 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x268 0x0900000023525264 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x2264 0x09000000234F023C IPRA.$sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE9C 0x09000000234F8954 sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 0x09000000234EE2F0 IPRA.$sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x13F0 0x09000000234EB73C sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x33C 0x090000001C1F6C20 RunEDU__8sqeAgentFv + 0xB60 0x090000001C1D0E40 EDUDriver__9sqzEDUObjFv + 0x300 0x090000001C0B1E00 sqloEDUEntry + 0x360 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Local Fix: | |
Set DB2_ANTIJOIN=NO or set optimization level to less or equal to 1 | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * **************************************************************** | |
Comment | |
Upgrade to Db2 11.1.4.6 or higher | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2020 31.03.2021 31.03.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |