DB2 - Problem description
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) |