Running SQL query with nested IN predicates like WHERE ( C1 IN
()) IN () )
on a columnar table hits -901 error.
The -901 message in db2diag.log looks like below:
2021-02-17-12.19.33.568573+000 I4839715E3247 LEVEL:
Error
PID : 78018 TID : 47109868873472 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
BLUDB
APPHDL : 0-46818 APPID:
172.30.99.64.24007.210223221332
UOWID : 3 ACTID: 1
AUTHID : EPMREADCA HOSTNAME: dashmpp-head-0
EDUID : 309333 EDUNAME: db2agntcol (BLUDB) 1
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility,
probe:13984
DATA #1 : String, 245 bytes
AssertionFailedException: An assertion 'allowFailure' failed.
Additional info: No evaluator found for node: {OR:T13! {IN:T13!
COLUMN_GLOBALCODE:"A7"."DIVISION_CODE":T2(50,7,1208)
CODE_LIST:T2(50,-1,1208)}}
Thrown at EvaluationRoutine.cpp : 13984
DATA #2 : Function name in Library, 152 bytes
ibm_cde::query::EvaluationRoutine::InputDescription::InputDescri
ption(ibm_cde::query::EvaluationRoutine*, const
ibm_cde::query::SyntaxTree*, bool, bool)
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] 0x00002AAC739F0087
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0x947
[1] 0x00002AAC73991CF1
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x251
[2] 0x00002AAC73989E97
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xB7
[3] 0x00002AAC74EF0DFB
_ZN7ibm_cde5query17EvaluationRoutine16InputDescriptionC1EPS1_PKN
S0_10SyntaxTreeEbb + 0x65B
[4] 0x00002AAC74F1CD73
_ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter
nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA
+ 0x5F73
[5] 0x00002AAC74F2F446
_ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS
_4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0
+ 0x486
[6] 0x00002AAC757E8A95
_ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr
eeEPNS0_18NLJoinControlBlockE + 0x2C5
[7] 0x00002AAC757EDB99
_ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x769
[8] 0x00002AAC757F09CB
_ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x33B
[9] 0x00002AAC757F1AF0
_ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x110
[10] 0x00002AAC757D61FA
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6A
[11] 0x00002AAC760D8FC5
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x115
[12] 0x00002AAC7B2E1EDD _Z14sqlriInvokeCdeP8sqlrr_cb + 0x3D
[13] 0x00002AAC7B14659F
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4EF
[14] 0x00002AAC7ABC43AD _Z16sqlrr_smp_routerP8sqlrr_cb + 0x48D
[15] 0x00002AAC7ABC72A9
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xDC9
[16] 0x00002AAC78069ACC
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x7572ACC
[17] 0x00002AAC7806A802 _Z21sqleProcessSubRequestP8sqeAgent +
0xD2
[18] 0x00002AAC780AC648 _ZN8sqeAgent6RunEDUEv + 0x548
[19] 0x00002AAC7C16C264 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4
[20] 0x00002AAC7A49A046 sqloEDUEntry + 0x2A6
2021-02-17-12.19.33.624205+000 I4842963E2891 LEVEL:
Severe (Origin)
PID : 78018 TID : 47109868873472 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
BLUDB
APPHDL : 0-46818 APPID:
172.30.99.64.24007.210223221332
UOWID : 3 ACTID: 1
AUTHID : EPMREADCA HOSTNAME: dashmpp-head-0
EDUID : 309333 EDUNAME: db2agntcol (BLUDB) 1
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility,
probe:13984
MESSAGE : SQL0901N The SQL statement or command failed because
of a database
system error. (Reason "".)
DATA #1 :
'allowFailure' failed. Info: No evaluator found for node:
{OR:T13! {IN:T13!
COLUMN_GLOBALCODE:"A7"."DIVISION_CODE":T2(50,7,1208)
CODE_LIST:T2(50,-1,1208)}}
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAC72F663F9 pdLogPrintf + 0x79
[1] 0x00002AAC73989156
_ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x7C6
[2] 0x00002AAC73989E9F
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xBF
[3] 0x00002AAC74EF0DFB
_ZN7ibm_cde5query17EvaluationRoutine16InputDescriptionC1EPS1_PKN
S0_10SyntaxTreeEbb + 0x65B
[4] 0x00002AAC74F1CD73
_ZN7ibm_cde5query17EvaluationRoutine29formEvaluationRoutineInter
nalEPKNS0_10SyntaxTreeERKNS0_14QueryResourcesERNS_4data22TableA
+ 0x5F73
[5] 0x00002AAC74F2F446
_ZN7ibm_cde5query17EvaluationRoutine21formEvaluationRoutineEsRNS
_4data22TableAccessorAllocatorERKNS0_19QueryResultInfoListERNS0
+ 0x486
[6] 0x00002AAC757E8A95
_ZN7ibm_cde5query9Scheduler19genSingleTableQueryEPNS0_10SyntaxTr
eeEPNS0_18NLJoinControlBlockE + 0x2C5
[7] 0x00002AAC757EDB99
_ZN7ibm_cde5query9Scheduler19runSingleTableQueryEv + 0x769
[8] 0x00002AAC757F09CB
_ZN7ibm_cde5query9Scheduler17runCompositeQueryEv + 0x33B
[9] 0x00002AAC757F1AF0
_ZN7ibm_cde5query9Scheduler15runMasterThreadEPvPi + 0x110
[10] 0x00002AAC757D61FA
_ZN7ibm_cde5query17cdeEntryPointImplEP8sqeAgentPvS3_ + 0x6A
[11] 0x00002AAC760D8FC5
_ZN12cdeInterface16startCdeSubagentEP8sqeAgent + 0x115
[12] 0x00002AAC7B2E1EDD _Z14sqlriInvokeCdeP8sqlrr_cb + 0x3D
[13] 0x00002AAC7B14659F
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x4EF
[14] 0x00002AAC7ABC43AD _Z16sqlrr_smp_routerP8sqlrr_cb + 0x48D
[15] 0x00002AAC7ABC72A9
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xDC9
[16] 0x00002AAC78069ACC
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0x7572ACC
[17] 0x00002AAC7806A802 _Z21sqleProcessSubRequestP8sqeAgent +
0xD2
[18] 0x00002AAC780AC648 _ZN8sqeAgent6RunEDUEv + 0x548
[19] 0x00002AAC7C16C264 _ZN9sqzEDUObj9EDUDriverEv + 0x1A4
[20] 0x00002AAC7A49A046 sqloEDUEntry + 0x2A6
[21] 0x00002AAC708E2EA5 /usr/lib64/libpthread.so.0 + 0x7EA5
[22] 0x00002AAC818CA8DD clone + 0x6D
Indication due to:
2021-02-17-12.19.35.117701+000 I4849362E976 LEVEL:
Severe
PID : 78018 TID : 47109868873472 PROC :
db2sysc 1
INSTANCE: db2inst1 NODE : 001 DB :
BLUDB
APPHDL : 0-46818 APPID:
172.30.99.64.24007.210223221332
UOWID : 3 ACTID: 1
AUTHID : EPMREADCA HOSTNAME: dashmpp-head-0
EDUID : 309333 EDUNAME: db2agntcol (BLUDB) 1
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 47
sqlerrmc: unexpected error at EvaluationRoutine.cpp:13984
sqlerrp : SQLCT001
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
0x00002AAC80BDEE4D
_Z25ossDumpStackTraceInternalmR11OSSTrapFileiP9siginfo_tPvmm +
0x00ad
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAC80BDFAE2 ossDumpStackTraceV98 + 0x0022
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAC80BDB74A address: 0x00002AAC80BDB74A ; dladdress:
0x00002AAC80962000 ; offset in lib: 0x000000000027974A ;
(/head/home/db2inst1/sqllib/lib64/libdb2osse.so.1)
0x00002AAC7A31A1DC sqlo_trce + 0x084c
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7A498520 sqloDumpDiagInfoHandler + 0x0240
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC708EA630 address: 0x00002AAC708EA630 ; dladdress:
0x00002AAC708DB000 ; offset in lib: 0x000000000000F630 ;
(/usr/lib64/libpthread.so.0)
0x00002AAC708E7AA1 pthread_kill + 0x0031
(/usr/lib64/libpthread.so.0)
0x00002AAC7A498D94 sqloDumpEDU + 0x0054
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7369F5CF _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi +
0x097f
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7AB7FEF7 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x06c7
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7C168AB0 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x00b0
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7C169455
_Z12sqlzeSqlCodeP8sqeAgentjmjP5sqlcaitP13__va_list_tag + 0x0185
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7AC8B6C1 sqlrrSqlCode + 0x0311
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC73989263
_ZN7ibm_cde8services24AssertionFailedException4doneEv + 0x08d3
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC73989E9F
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0x00bf
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC76138FE4
_ZN7ibm_cde5query6Parser16addCastOperatorsEPNS0_10SyntaxTreeERKN
S0_14QueryResourcesERKNS0_18QueryInfoContainerE + 0x19b4
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC76143342
_ZN7ibm_cde5query6Parser7prepareEPNS0_10SyntaxTreeEbi + 0x0182
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7615056F
_ZN7ibm_cde5query6Parser23prepareSingleTableQueryEPNS0_10SyntaxT
reeEb + 0x00bf
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC76150AC4
_ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE
NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryReso
urcesERNSA_22TableAccessorAllocatorERNS0_18QueryInfoContainerEP1
3SQLO_MEM_POOLPS1_ + 0x0394
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC760E7465
_ZN12cdeInterface14initializeDataEP8sqlrr_cbP17sqlriCdeStatement
+ 0x1375
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC760EA5A8
_ZN12cdeInterface15ExecuteNoOutputEP8sqlrr_cbP17sqlriCdeStatemen
t + 0x0058
(/head/home/db2inst1/sqllib/lib64/libdb2e.so.1)
0x00002AAC7B0ADE6D _Z12sqlriCdeExecP8sqlrr_cb + 0x019d |
