DB2 - Problembeschreibung
Problem IT09939 | Status: Geschlossen |
DB2 might return SQL0901N when executing query with ROLLUP or Group BY | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
DB2 might return SQL0901N under the following conditions: 1) Query contains atleast one rollup or cube 2) The query contains atleast one UNION ALL clause Error Message : ASSERTION - 'currentNode.getChild(1)->tokType()==OP_AS' Stack : 2015-01-28-16.31.17.716404-300 I13735930E3701 LEVEL: Error PID : 9664 TID : 140070384297728 PROC : db2sysc INSTANCE: regress1 NODE : 000 DB : BLUDB APPHDL : 0-1425 APPID: 9.26.98.0.39235.150128214050 AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09 EDUID : 4417 EDUNAME: db2agent (BLUDB) FUNCTION: DB2 UDB, CDE Trace, cdeDiagnosticsFacility, probe:9200 DATA #1 : String, 189 bytes AssertionFailedException: An assertion 'currentNode.getChild(1)->tokType()==OP_AS' failed. Additional info: bad CAST clause {CAST:T0 AS:T0 DATE:T10 NULLABLE:T0} Thrown at Parser.cpp : 9200 DATA #2 : Function name in Library, 122 bytes static void ibm_cde::query::Parser::simplifyCastNode(ibm_cde::query::SyntaxT ree &, const ibm_cde::query::QueryResources &) DATA #3 : File name, 10 bytes Parser.cpp CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol) [0] 0x00007F6A5A764D00 _ZN7ibm_cde8services6Tracer9traceDataENS0_11ComponentIDENS0_16Co mmonTraceLevelENS1_10TraceEventEPKcmS6_PKvmRKSbIcSt11char_trait + 0x710 [1] 0x00007F6A5E49CA5B _ZNK7ibm_cde8services13BaseException14traceExceptionENS0_11Compo nentIDEPKc + 0x22B [2] 0x00007F6A5E49ACE7 _ZN7ibm_cde8services24AssertionFailedException17constructAndThro wENS0_11ComponentIDEPKcmS4_S4_RKNS0_16CdeOStringStreamE + 0x97 [3] 0x00007F6A5ABB7819 _ZN7ibm_cde5query6Parser16simplifyCastNodeERNS0_10SyntaxTreeERKN S0_14QueryResourcesE + 0x829 [4] 0x00007F6A5ABB6C35 _ZN7ibm_cde5query6Parser16addCastOperatorsEPNS0_10SyntaxTreeERKN S0_14QueryResourcesERKNS0_18QueryInfoContainerE + 0x2345 [5] 0x00007F6A5ABA986D _ZN7ibm_cde5query6Parser7prepareEPNS0_10SyntaxTreeEPNS0_17QueryA rgumentListEbi + 0x3AD [6] 0x00007F6A5AB9C8E6 _ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryRes + 0x10B6 [7] 0x00007F6A5E612FF5 _ZN7ibm_cde5query6Parser18prepareNestedQueryEPNS0_10SyntaxTreeES 3_RKNS_4data8DataBaseERKNS0_14QueryResourcesEP13SQLO_MEM_POOL + 0x2A5 [8] 0x00007F6A5AB9C5FD _ZN7ibm_cde5query6Parser13parserWrapperERKSbIcSt11char_traitsIcE NS_8services9AllocatorIcEEERKNS_4data8DataBaseERKNS0_14QueryRes + 0xDCD [9] 0x00007F6A5E608C87 _ZN12cdeInterface14initializeDataEP8sqlrr_cbP17sqlriCdeStatement + 0x1267 [10] 0x00007F6A5E5F2B23 _ZN12cdeInterface13openTableScanEP8sqlrr_cbP17sqlriCdeStatement + 0x63 [11] 0x00007F6A5D6E7313 _Z12sqlriCdeOpenP8sqlrr_cbP17sqlriCdeStatement + 0xF33 [12] 0x00007F6A6036256C _Z13sqlriCdeQueryP8sqlrr_cb + 0x3DC [13] 0x00007F6A60362AF1 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1B1 [14] 0x00007F6A5D53B87F _Z27sqlrr_process_fetch_requestP14db2UCinterface + 0x1BF [15] 0x00007F6A5D537639 _Z10sqlrr_openP14db2UCinterfaceP15db2UCCursorInfo + 0xA89 [16] 0x00007F6A5C6C7281 _Z16sqljs_ddm_opnqryP14db2UCinterfaceP13sqljDDMObject + 0x3F1 [17] 0x00007F6A6028E9F6 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x3C6 [18] 0x00007F6A5C6B2FAC _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x36C [19] 0x00007F6A5C6AD47F /home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33D447F [20] 0x00007F6A5C6AB96C /home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33D296C [21] 0x00007F6A5C6A89C9 /home/regress1/sqllib/lib64/libdb2e.so.1 + 0x33CF9C9 [22] 0x00007F6A5C6A85BB _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xEB [23] 0x00007F6A5C3ACBAF _ZN8sqeAgent6RunEDUEv + 0xACF [24] 0x00007F6A5DB96B87 _ZN9sqzEDUObj9EDUDriverEv + 0xF7 [25] 0x00007F6A5D36E5C3 sqloEDUEntry + 0x303 [26] 0x00007F6A646437B6 /lib64/libpthread.so.0 + 0x77B6 [27] 0x00007F6A58132D6D clone + 0x6D . . . . . . . . . . . . --- Line 237947 --- SQLCODE -901 message 2015-01-28-16.31.18.549885-300 I13745048E900 LEVEL: Severe PID : 9664 TID : 140070384297728 PROC : db2sysc INSTANCE: regress1 NODE : 000 DB : BLUDB APPHDL : 0-1425 APPID: 9.26.98.0.39235.150128214050 AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09 EDUID : 4417 EDUNAME: db2agent (BLUDB) FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:250 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 35 sqlerrmc: unexpected error at Parser.cpp:9200 sqlerrp : SQLCT001 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFDC10 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 2015-01-28-16.31.18.550165-300 I13745949E663 LEVEL: Severe PID : 9664 TID : 140070384297728 PROC : db2sysc INSTANCE: regress1 NODE : 000 DB : BLUDB APPHDL : 0-1425 APPID: 9.26.98.0.39235.150128214050 AUTHID : REGRESS1 HOSTNAME: vmsvtlnx64x09 EDUID : 4417 EDUNAME: db2agent (BLUDB) FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:275 MESSAGE : MASTER TIME INFO DATA #1 : Hexdump, 32 bytes 0x00007F64D11A2CC0 : DC51 C954 0000 0000 A601 0000 3171 0600 .Q.T........1q.. 0x00007F64D11A2CD0 : 3171 0600 DC51 C954 0000 0000 0000 0000 1q...Q.T........ | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * The issue is fixed in FP7 release * **************************************************************** | |
Local-Fix: | |
Lösung | |
The issue is fixed in FP7 release | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 08.07.2015 02.11.2015 29.04.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |