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

Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

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

• RB10 PSN

     UP