IBM Support

IT22111: CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Instance may crash with a stack similar to the following:
    <StackTrace>
    -------Frame------ ------Function + Offset------
    0x090000001D8433F0
    getNextOutputAggPayload__Q3_7ibm_cde5query14PayloadStorageFUlRQ3
    _7ibm_cde5query17GroupByRowManagerPQ3_7ibm_cde5query20GroupAggLo
    cationDataRCQ2_3std6vectorXTQ3_7ibm_cde5types8DataTypeTQ3_7ibm_c
    de8services9AllocatorXTQ3_7ibm_cde5types8DataType__ + 0x25C
    0x090000001D7E627C
    mergeSpilledEarlyMergedHTsToGHT__Q3_7ibm_cde5query19GroupByContr
    olBlockFCUiRCiRCQ2_3std6vectorXTQ3_7ibm_cde5types8DataTypeTQ3_7i
    bm_cde8services9AllocatorXTQ3_7ibm_cde5types8DataType__CPQ3_7ibm
    _cde5query32LookupGroupingHashTableEvaluator + 0xB1C
    0x090000001D7E7088
    completeGroupbyAggregationProcessing__Q3_7ibm_cde5query19GroupBy
    ControlBlockFCUiCPQ3_7ibm_cde5query32LookupGroupingHashTableEval
    uatorRQ3_7ibm_cde5query16RuntimeStatEntry + 0x2AC
    0x090000001D846710
    processInputsSynchronously__Q3_7ibm_cde5query32LookupGroupingHas
    hTableEvaluatorFv + 0xBC
    0x090000001DD09E8C
    evaluate__Q3_7ibm_cde5query9EvaluatorFbT1RQ4_7ibm_cde5query9Eval
    uator21EvaluatorRestartStatePQ3_7ibm_cde5query19OptPredicateTrac
    ker + 0xC00
    0x090000001DC92DF4
    evaluate__Q3_7ibm_cde5query17EvaluationRoutineFUiP15sql_static_d
    ata + 0x44C
    0x090000001DC930D0
    runThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x90
    0x090000001C93D0D0
    cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0
    0x090000001BBF24AC startCdeSubagent__12cdeInterfaceFP8sqeAgent +
    0x1E4
    0x0900000011EA9C18 sqlriInvokeCde__FP8sqlrr_cb + 0xA0
    0x0900000014ABFDFC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
    0x90
    0x09000000158F0D88
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x7E4
    0x090000001591BB10
    sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x107C
    0x0900000012BD9DAC @82@sqleSubRequestRouter__FP8sqeAgentPUiPUl +
    0x1850
    0x090000001553758C RunEDU__8sqeAgentFv + 0x35A4C
    0x09000000154B7738 RunEDU__8sqeAgentFv + 0x124
    0x09000000142CCAE4 EDUDriver__9sqzEDUObjFv + 0x130
    0x0900000013F5E2D4 sqloEDUEntry + 0x3A0
    </StackTrace>
    
    Crash is data dependent and does not always occur.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 2 Fix Pack 2 iFix001 or higher       *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 2 Fix Pack 2 iFix001
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22111

  • 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

    2017-08-23

  • Closed date

    2017-10-11

  • Last modified date

    2017-10-11

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

    IT20328

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"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:
29 June 2020