|
Problem IT15784
|
Status: Closed |
TRAP IN DPF ENVIRONMENT WHEN COMPLEX QUERY WITH AGGREGATION IS RUN |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - 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 10.5 Fix Pack 9 or higher *
**************************************************************** |
| 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 |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.06.2016
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
