|
Problem IT33467
|
Status: Closed |
CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPLIED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901
|
| product: |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 |
| Problem description: |
SELECT fails with -901, db2diag.log files shows
parserWrapper/JoinRewriter stack like
AssertionFailedException: An assertion 'false' failed.
Additional info: cannot fetch column name _VARIABLE:H0:T10!
Thrown at JoinRewriter.cpp : 2237
DATA #2 : Function name in Library, 9 bytes
getColumn
DATA #3 : File name, 16 bytes
JoinRewriter.cpp
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x0000100003ED9730 pdLog + 0x640
[1] 0x0000100005032388
_ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co
mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait
+ 0xB38
[2] 0x0000100004F86620
_ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo
nentIDEPKc + 0x220
[3] 0x0000100004F7B63C
_ZN7ibm_cde8services24AssertionFailedException17constructAndThro
wENS0_11ComponentIDEPKcmS4_S4_RNS0_16CdeOStringStreamE + 0xFC
[4] 0x00001000097E509C
_ZN7ibm_cde5query12JoinRewriter9getColumnEPKNS0_10SyntaxTreeEb +
0x26C
[5] 0x00001000097E6490
_ZN7ibm_cde5query12JoinRewriter12addAuxColumnERKNS0_17JoinRewrit
erEntryEbPKNS0_10SyntaxTreeESbIcSt11char_traitsIcENS_8services9
+ 0xF0
[6] 0x00001000097E8F58
_ZN7ibm_cde5query12JoinRewriter21addAuxColumnsFromTreeERKNS0_17J
oinRewriterEntryEPKNS0_10SyntaxTreeEbb + 0x3A8
[7] 0x00001000097E9688
_ZN7ibm_cde5query12JoinRewriter15setupAuxColumnsEPKNS0_10SyntaxT
reeE + 0x308
[8] 0x00001000097FD464
_ZN7ibm_cde5query12JoinRewriter7rewriteEPKNS0_10SyntaxTreeE +
0x474
[9] 0x000010000968B2AC
_ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE
NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryRes
+ 0x1E7C
[10] 0x000010000956F9E0
_ZN12cdeInterface14initializeDataEP8sqlrr_cbP17sqlriCdeStatement
+ 0x2A70
[11] 0x000010000957CFF8
_ZN12cdeInterface15ExecuteNoOutputEP8sqlrr_cbP17sqlriCdeStatemen
t + 0xA8
[12] 0x00001000101D1078 _Z12sqlriCdeExecP8sqlrr_cb + 0x1F8
[13] 0x0000100010272D10
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x410
[14] 0x000010000FAD87D0 _Z16sqlrr_dss_routerP8sqlrr_cb + 0xA40
[15] 0x000010000FAD73A4
_Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xEE4
[16] 0x000010000C4F9E20
/head/home/db2inst1/sqllib/lib64/libdb2e.so.1 + 0xC219E20
[17] 0x000010000C4F4440 _Z21sqleProcessSubRequestP8sqeAgent +
0x2400
[18] 0x000010000C573E74 _ZN8sqeAgent6RunEDUEv + 0x9F4
[19] 0x00001000115FDA04 _ZN9sqzEDUObj9EDUDriverEv + 0x344
[20] 0x00001000115FD69C _Z10sqlzRunEDUPcj + 0x1C
[21] 0x000010000F1FF5F4 sqloEDUEntry + 0x334
[22] 0x0000100000088B94 /lib64/libpthread.so.0 + 0x8B94
[23] 0x00001000186F85F4 clone + 0xE4
...
EDUID : 11244 EDUNAME: db2agntp (BLUDB) 1
FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:2237
MESSAGE : SQL0901N The SQL statement or command failed because
of a database
system error. (Reason "".)
DATA #1 :
'false' failed. Info: cannot fetch column name _VARIABLE:H0:T10! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v115m5fp0 or later *
**************************************************************** |
| Local Fix: |
db2set DB2_EXTENDED_OPTIMIZATION="COL_HSJN_WITH_RESID OFF"
instance restart
static packages will need to be rebound. |
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.07.2020
19.11.2020
19.11.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
