DB2 - Problem description
Problem IT23649 | Status: Closed |
DB2 MIGHT TRAP WHEN EXECUTING A QUERY REFERENCING NODENUMBER OR DBPARTITIONNUM FUNCTION IN DPF ENVIRONMENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The problem can occur in DPF during compilation of a SQL statement containing the following - a subselect with nodenumber or dbpartitionnum function in the select list and a group by clause - the nodenumber/dbpartitionnum output from the subselect is joined to another table If you hit this failure, you will see the following stack: 0x00007EFE26095716 _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm + 0x0356 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2osse.so.1) 0x00007EFE2609535B ossDumpStackTraceV98 + 0x002b (/etrade/home/pp1edwi1/sqllib/lib64/libdb2osse.so.1) 0x00007EFE26091507 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00d7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2osse.so.1) 0x00007EFE2D267357 sqlo_trce + 0x03c7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2D3CE411 sqloEDUCodeTrapHandler + 0x03b1 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x0000003C6D20F7E0 address: 0x0000003C6D20F7E0 ; dladdress: 0x0000003C6D200000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x00007EFE2C5A1E9A _Z25sqlno_dpf_order_normalizeP13sqlno_globalsP17sqlno_order_clas sP21sqlno_plan_propertiesP10sqlno_apcbPS2_ + 0x017a (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C540608 _Z16sqlno_test_orderP13sqlno_globalsP19sqlno_plan_operatorP17sql no_order_classP13SQLNN_BOOLEANS5_P9sqlno_set + 0x0258 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C53F5D1 _Z21sqlno_test_propertiesP13sqlno_globalsP9sqlno_qtbP20sqlno_req _propertiesP19sqlno_plan_operatorP13SQLNN_BOOLEANS8_PjS9_ + 0x04b1 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C53ED13 _Z15sqlno_need_glueP13sqlno_globalsP9sqlno_qtbP20sqlno_req_prope rtiesP19sqlno_plan_operatorP13SQLNN_BOOLEANS8_ + 0x0143 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C53BA3E _Z19sqlno_get_best_planP13sqlno_globalsP9sqlno_qtbP18sqlno_join_ contextP20sqlno_req_properties9sqlno_setP13SQLNN_BOOLEANPP19sqln o_plan_operatorPS7_ + 0x027e (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C4CDC64 _Z16sqlno_crule_mgjnP13sqlno_globalsP13sqlno_contextP9sqlnq_sat9 sqlno_setS5_S5_S5_S5_S5_PjS6_P10sqlno_hintS6_bP11sqlno_qpcsbP14s qlno_planlist + 0x0524 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C4C7504 _Z24sqlno_crule_join_choicesP13sqlno_globalsP13sqlno_contextP9sq lnq_sat9sqlno_setS5_S5_S5_S5_S5_17sqlno_join_choiceS5_jj13SQLNN_ BOOLEANS7_P10sqlno_qpteP10sqlno_hintbPjP11sqlno_qpcsbP14sqlno_pl anlistSG_SG_SG_ + 0x0714 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C4C6C28 _Z22sqlno_crule_join_orderP13sqlno_globalsP13sqlno_contextP9sqln q_sat9sqlno_setS5_S5_S5_S5_S5_17sqlno_join_choiceP11sqlno_qpcsbj j13SQLNN_BOOLEANS9_P10sqlno_hintbPjP14sqlno_planlist + 0x04e8 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C4C630D _Z21sqlno_crule_join_rootP13sqlno_globalsP13sqlno_context9sqlno_ setS3_S3_S3_S3_S3_17sqlno_join_choiceP11sqlno_qpcsbjjP10sqlno_hi ntPjP14sqlno_planlist + 0x019d (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C4EB0EE _Z16sqlno_crule_joinP13sqlno_globalsP9sqlno_qtbP11sqlno_qpcsb + 0x066e (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C6680B0 _Z28sqlno_gen_partitions_for_QTBP13sqlno_globalsP9sqlno_sfbP15sq lno_sfws_plan + 0x03f0 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C666FD7 _Z18sqlno_plan_end_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_opr + 0x03e7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C6745AE _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ opr + 0x0ace (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673912 _Z14sqlno_walk_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_ qun + 0x00e2 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C679B08 _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ LNN_BOOLEAN + 0x00b8 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673BC3 _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ opr + 0x00e3 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673912 _Z14sqlno_walk_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_ qun + 0x00e2 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C679B08 _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ LNN_BOOLEAN + 0x00b8 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673BC3 _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ opr + 0x00e3 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673912 _Z14sqlno_walk_qunP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq_ qun + 0x00e2 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C679B08 _Z13sqlno_call_sfP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvS5_i13SQ LNN_BOOLEAN + 0x00b8 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673BC3 _Z14sqlno_each_oprP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_ opr + 0x00e3 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C673667 _Z13sqlno_top_qtbP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurP9sqlnq_q tb + 0x00d7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C672F59 _Z14sqlno_each_qurP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurS4_ + 0x04b9 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C678526 _Z14sqlno_scan_qgmP13sqlno_globalsP9sqlno_sfbP9sqlnq_qur + 0x0206 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C599947 _Z19sqlno_planning_scanP13sqlno_globalsP9sqlnq_quri + 0x03c7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C598A28 _Z20sqlno_planning_phaseP13sqlno_globalsP9sqlnq_qurii + 0x04c8 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C59532B _Z9sqlno_exeP9sqlnq_qur + 0x0fab (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C29D1DC _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x4d4c (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2C298481 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0021 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DCB091B _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP _LOCK_INFOP16sqlra_cached_varPiS5_Pb + 0x10eb (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DCCD696 _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK _INFOPP16sqlra_cached_varS8_bSA_Pb + 0x0966 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DD6D2A8 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0f18 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DA25706 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x15c6 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DA05C6E _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x083e (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE281964A3 _ZN10pvmPackage14executeSectionEP5sqlcajb + 0x0c43 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE281957C1 _ZN3PVM12executeQueryEjb + 0x0101 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2819AF35 _ZN3PVM3runEv + 0x0cb5 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE281B3C7E pvm_entry + 0x01ae (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2D2C03C4 sqloInvokeFnArgs + 0x71d4 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2E17D554 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x2594 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2E16F8F5 _Z18sqlriInvokeInvokerP10sqlri_ufobb + 0x1bb5 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2E16D3A0 _Z9sqlricallP8sqlrr_cb + 0x01d0 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DFF4CF7 _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x04b7 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2DA22092 _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x0f32 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2D9F7203 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x02a3 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2BBF90A4 _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x06c4 (/etrade/home/pp1edwi1/sqllib/lib64/libdb2e.so.1) 0x00007EFE2BBC403B _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x010b | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * See Error Description * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to 10.5Fp10 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.01.2018 11.07.2018 11.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |