|
Problem IT23742
|
Status: Closed |
DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING OR PREDICATES AND EXISTS PREDICATES |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
DB2 might abend when queries contain:
1. OR predicates
2. EXISTS/IN/NOT EXISTS predicates are ORed with local
predicates
3. local predicates containing EXISTS/IN/NOT EXISTS sub-queries
When trap occurs, the following crashed stack can be observed:
<StackTrace>
-------Frame------ ------Function + Offset------
0x09000000176758E8
sqlno_analyze_countingSQ__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qt
bP9sqlnq_pidP9sqlno_prd13SQLNN_BOOLEAN + 0x3A8
0x0900000017675ED0
sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x2F0
0x0900000017676170
sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
0x0900000017676170
sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
0x0900000017676170
sqlno_finish_tree_walk__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidP9sqlno_prdP9sqlnq_qunT613SQLNN_BOOLEAN + 0x590
0x090000001767B120
sqlno_analyze_relop__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP9sq
lnq_pidP9sqlno_prd + 0x900
0x090000001767E5E4
sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
P9sqlnq_pidPi + 0x584
0x090000001767F3D8
sqlno_analyze_ANDORNOT__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidPi + 0x318
0x090000001767E590
sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
P9sqlnq_pidPi + 0x530
0x090000001767F3D8
sqlno_analyze_ANDORNOT__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtbP
9sqlnq_pidPi + 0x318
0x090000001767E590
sqlno_analyze_pred_expr__FP13sqlno_globalsP9sqlno_sfbP9sqlno_qtb
P9sqlnq_pidPi + 0x530
0x0900000017688408
sqlno_assign_optprd__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sq
lnq_prdPi + 0x4A8
0x0900000017688D28
sqlno_assign_prd__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_oprP9sqlnq
_prd + 0x168
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1C758
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x3B8
0x0900000017672470
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x370
0x0900000017672A98
sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
nq_oprP9sqlnq_qun + 0x378
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1CB90
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x7F0
0x0900000017672470
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x370
0x0900000017672A98
sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
nq_oprP9sqlnq_qun + 0x378
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1CB90
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x7F0
0x0900000017672470
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x370
0x0900000017672A98
sqlno_assign_walk_quns_and_ff__FP13sqlno_globalsP9sqlno_sfbP9sql
nq_oprP9sqlnq_qun + 0x378
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1CB90
sqlno_each_opr__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qunP9sqlnq_o
pr + 0x7F0
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1D378
sqlno_top_qtb__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurP9sqlnq_qt
b + 0x158
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F1D964
sqlno_each_qur__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qurT3 +
0x344
0x0900000014F185B8
sqlno_call_sf__FP13sqlno_globalsP8sqlno_sfP9sqlno_sfbPvT4i13SQLN
N_BOOLEAN + 0x338
0x0900000014F18A08
sqlno_scan_qgm__FP13sqlno_globalsP9sqlno_sfbP9sqlnq_qur + 0x1A8
0x0900000012A97A40
sqlno_prep_phase__FP13sqlno_globalsP9sqlnq_qur + 0xC40
0x0900000012A9AEB0 sqlno_exe__FP9sqlnq_qur + 0x1C50
0x0900000012A7AC30
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x12D90
0x0900000012A8682C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x8C
0x0900000011898768
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0x1F88
0x0900000012678130
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0x1130
0x0900000010ADABB8 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x38B8
0x0900000010962164
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x444
0x0900000017CBEAAC
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x20C
0x09000000108FD704
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x284
0x09000000108FBFB0
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb +
0x290
0x09000000108901D4 sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb +
0x6D4
0x0900000010892B10
sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x1D0
0x090000001089A418
sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5B8
0x090000001089C8EC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0x2EC
0x090000000C785D1C RunEDU__8sqeAgentFv + 0x47C
0x090000000C742DF8 EDUDriver__9sqzEDUObjFv + 0x238
0x090000000C74315C sqlzRunEDU__FPcUi + 0x3C
0x090000000C4D6E98 sqloEDUEntry + 0x778
</StackTrace> |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to the latest fix pack *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
The problem is first fixed in V11.1 mode pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.01.2018
15.03.2018
15.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
