DB2 - Problem description
Problem IT21736 | Status: Closed |
TRAP IN DPF ENVIRONMENT WHEN COMPLEX QUERY WITH AGGREGATION IS RUN | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Trap in DPF environment when Complex query with Aggregation is run; Possible stack : -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAB62399D5 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0385 (/db2home/crmm06/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB62395DC ossDumpStackTraceV98 + 0x002c (/db2home/crmm06/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB623567D _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00fd (/db2home/crmm06/sqllib/lib64/libdb2osse.so.1) 0x00002AAAB0BD47B4 sqlo_trce + 0x0404 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0C5E1EC sqloEDUCodeTrapHandler + 0x02ac (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x000000399600F710 address: 0x000000399600F710 ; dladdress: 0x0000003996000000 ; offset in lib: 0x000000000000F710 ; (/lib64/libpthread.so.0) 0x0000000000427CB0 __intel_ssse3_rep_memcpy + 0x2240 (db2sysc 34) 0x00002AAAB1BB1B9A _Z16sqlkt_pack_tupleP10SQLD_FIELDP9sqlri_taolPP10SQLD_VALUEP5sql catP8sqeAgent + 0x06ca (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAB1BB0796 _Z8sqlktinsP7sqlr_dbP8sqeAgentP10sqlri_iudoP5sqlcat + 0x0236 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAB1254055 _Z9sqlritqb2P8sqlrr_cb + 0x0185 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEF20E57 _Z8sqlriag1P8sqlrr_cb + 0x0257 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAB1C7E3B2 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x01b2 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAB0F3494B _Z16sqlrr_dss_routerP8sqlrr_cb + 0x071b (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAAEDFEBB7 _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0ae7 (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAADC1674D address: 0x00002AAAADC1674D ; dladdress: 0x00002AAAAAABC000 ; offset in lib: 0x000000000315A74D ; (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAADC151EB _Z21sqleProcessSubRequestP8sqeAgent + 0x030b (/db2home/crmm06/sqllib/lib64/libdb2e.so.1) 0x00002AAAADC3068F _ZN8sqeAgent6RunEDUEv + 0x048f Cleaned up stack: 6 __intel_ssse3_rep_memcpy 7 sqlkt_pack_tuple 8 sqlktins 9 sqlritqb2 10 sqlriag1 11 sqlriSectInvoke 12 sqlrr_dss_router 13 sqlrr_subagent_router 14 sqleSubRequestRouter 15 sqleProcessSubRequest 16 sqeAgent::RunEDU It is important to have sqlriag1 in the stack to identify if you are hitting this error. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 11.1 Mod 2 Fix Pack 2. * **************************************************************** | |
Local Fix: | |
The workaround is to turn off pushdown feature, but that can cause some performance impact: db2set DB2_TCG_DEFAULT_OPTIONS="set disable_pushdown on". | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT15784 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.08.2017 12.10.2017 12.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |