DB2 - Problem description
Problem IT22780 | Status: Closed |
CRASH MAY OCCUR DURING CDE JOIN WHEN PROCESSING A LARGE AMOUNT OF DATA | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Crash may occur during CDE Join when processing a large amount of data. Crash stack will show similar to the following: <StackTrace> __intel_avx_rep_memset + 0x01b1 _ZNK7ibm_cde5query10ColumnDesc10extractColILb0ELb1EEEvPvPKlRmRj + 0x0063 _ZN7ibm_cde5query16ExtractEvaluatorILb1EE7processINS_5types7Inte gerIaLb0EEENS4_12VarLenStringELb0ELb1EEEvv + 0x0570 _ZN7ibm_cde5query16ExtractEvaluatorILb1EE26processInputsSynchron ouslyEv + 0x02b4 _ZN7ibm_cde5query9Evaluator8evaluateEbbRNS1_21EvaluatorRestartSt ateEPNS0_19OptPredicateTrackerE + 0x03a9 _ZN7ibm_cde5query17EvaluationRoutine8evaluateEjP15sql_static_dat a + 0x030c _ZN7ibm_cde5query9Scheduler13evaluateChainEPNS0_17EvaluationRout ineERm + 0x0284 _ZN7ibm_cde5query9Scheduler15runWorkerThreadEPvPi + 0x0363 ... Cleaned up stack shows as: <StackTrace> memset + 0x01b1 ibm_cde::query::ColumnDesc::extractCol<false, true>(void*, long const*, unsigned long&, unsigned int&) const + 0x0063 ibm_cde::query::ExtractEvaluator<true>::process<ibm_cde::types:: Integer<signed char, false>, ibm_cde::types::VarLenString,false, true>() + 0x0570 ibm_cde::query::ExtractEvaluator<true>::processInputsSynchronous ly() + 0x02b4 ibm_cde::query::Evaluator::evaluate(bool, bool, ibm_cde::query::Evaluator::EvaluatorRestartState&, ibm_cde::query::OptPredicateTracker*) + 0x03a9 ibm_cde::query::EvaluationRoutine::evaluate(unsigned int,sql_static_data*) + 0x030c ibm_cde::query::Scheduler::evaluateChain(ibm_cde::query::Evaluat ionRoutine*, unsigned long&) + 0x0284 ibm_cde::query::Scheduler::runWorkerThread(void*, int*) + 0x0363 ... | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Db2 Column Organized Users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.3.3 or later. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows | |
Solution | |
First fixed in Db2 11.1.3.3. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.10.2017 15.03.2018 15.03.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |