Once you execute query on the columnar table, the following
error might be returned:
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "unexpected error at
EvaluationRoutine.cpp:4678".)
SQLSTATE=58004
After the error, you can find following information in the
db2diag.log:
2014-03-18-12.17.33.688547-240 I1966A3168 LEVEL: Error
PID : 31391998 TID : 16300 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB : TEST
APPHDL : 0-35 APPID:
*LOCAL.db2inst1.140318161440
AUTHID : db2inst1 HOSTNAME: p6db2serv
EDUID : 16300 EDUNAME: db2agntcol (TEST)
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:4678
DATA #1 : String, 419 bytes
AssertionFailedException: An assertion
'currentNode->getChild(0)->tokType() == OP_EXTRACT_GB &&
currentNode->getChild(0)->getNumChild() == 1' failed. Additional
info: Unexpected child for agg, must be EXTRACT_GB with 1 arg
{MAXVECTOR:T5(14,0) {+:T5(14,0) {*:T5(13,0)
COLUMN_VALUE:"A0"."LGDDTER":T5(8,0) _SINT32:1000.:T5(5,0)}
{CAST:T5(13,0) COLUMN_VALUE:"A0"."LGDZEIT":T5(4,0)}}}
Thrown at EvaluationRoutine.cpp : 4678
DATA #2 : Function name in Library, 255 bytes
ibm_cde::query::EvaluationRoutine::formEvaluationRoutineInternal
(const SyntaxTree *, const QueryResources &,
TableAccessorAllocator &, QueryInfoContainer &,
ibm_cde::query::QueryArgumentID, const QueryResultInfoMap &,
bool, const MemPoolHandle, const Samp
DATA #3 : File name, 21 bytes
EvaluationRoutine.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000013AA51340
traceData__Q3_7ibm_cde8services6TracerFCQ3_7ibm_cde8services11Co
mponentIDCQ3_7ibm_cde8services16CommonTraceLevelCQ4_7ibm_cde8se
+ 0x8A0
[1] 0x090000013AA81B50
traceException__Q3_7ibm_cde8services13BaseExceptionCFQ3_7ibm_cde
8services11ComponentIDPCc + 0x1D0
[2] 0x090000013C47C024
trace__Q3_7ibm_cde8services24AssertionFailedExceptionFCQ3_7ibm_c
de8services11ComponentID + 0x24
[3] 0x090000013C49DAA0
formEvaluationRoutineInternal__Q3_7ibm_cde5query17EvaluationRout
ineFPCQ3_7ibm_cde5query10SyntaxTreeRCQ3_7ibm_cde5query14QueryRe
+ 0xC5C0
[4] 0x090000013C490868
formEvaluationRoutine__Q3_7ibm_cde5query17EvaluationRoutineFsRQ3
_7ibm_cde4data22TableAccessorAllocatorRCQ2_3std3mapXTsTPQ3_7ibm
+ 0x748
[5] 0x090000013CA4B17C
runSingleTableQuery__Q3_7ibm_cde5query9SchedulerFv + 0x43C
[6] 0x090000013CA4AC68 runQuery__Q3_7ibm_cde5query9SchedulerFv
+ 0x2E8
[7] 0x090000013CA4E1FC
runSchedThreadTask__Q3_7ibm_cde5query9SchedulerFPvPi + 0x19C
[8] 0x090000013CA63580
cdeEntryPointImpl__Q2_7ibm_cde5queryFP8sqeAgentPvT2 + 0xC0
[9] 0x090000013C05D944
startCdeSubagent__12cdeInterfaceFP8sqeAgent + 0xC4
[10] 0x090000006D658574 sqlriInvokeCde__FP8sqlrr_cb + 0x9C
[11] 0x090000006B5366DC
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x40C
[12] 0x090000006A74FD7C
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0x52B8
[13] 0x090000006A6E8FE0
sqlrr_subagent_router__FP8sqeAgentP12SQLE_DB2RA_T + 0xCE4
[14] 0x090000006A6E9C0C
@81@sqleSubRequestRouter__FP8sqeAgentPUiPUl + 0x42C
[15] 0x090000006AA3EE30 RunEDU__8sqeAgentFv + 0x2ED2C
[16] 0x090000006AA8D65C RunEDU__8sqeAgentFv + 0xDC
[17] 0x090000006BE33D58 EDUDriver__9sqzEDUObjFv + 0x128
[18] 0x090000006AE587D8 sqloEDUEntry + 0x3A0
[19] 0x09000000005EED30 _pthread_body + 0xF0
[20] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF |
