IBM Support

IT34696: MEMORY CRASH/TRAP WITH LOCAL PREDICATE ON OJ SUBSELECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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:
    <StackTrace>
    -------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
    

Local fix

  • Set DB2_ANTIJOIN=NO
    
    or set optimization level to less or equal to 1
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.6 or higher                            *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.6 or higher
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT34696

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-27

  • Closed date

    2021-03-31

  • Last modified date

    2021-03-31

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022