DB2 - Problem description
Problem IT20328 | Status: Closed |
CRASH MAY OCCUR WHEN USING COLUMN ORGANIZED TABLES WHEN HASH TABLE NEEDS TO BE SPILLED FOR A GROUPBY | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem 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. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fix Pack 9 or later * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 24.04.2017 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |