|
Problem IC78653
|
Status: Closed |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 may trap with SIGSEGV (Signal #11) in the
nav_assign_max_levels
function or if the optimizers rewritten query has duplicate
predicates. When removing these duplicate predicates, we may
reference an already dereferenced piece of memory to cause the
segmentation fault.
The trap file produced will have the below stack:
nav_assign_max_levels
nav_init
form_matches
sqlnr_form_common_subexprs
sqlnr_optprep
sqlnr_optprep_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe
sqlnr_exe
sqlnn_cmpl
sqlnn_cmpl
sqlra_compile_var
or
is_RIDC_qnc
UDT_colequiv_exp
sqlnr_coleq_class_cond
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_endqtb_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_start_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe
sqlnn_cmpl |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 may trap with SIGSEGV (Signal #11) in the *
* nav_assign_max_levels *
* function or if the optimizers rewritten query has duplicate *
* *
* predicates. When removing these duplicate predicates, we *
* may *
* reference an already dereferenced piece of memory to cause *
* the *
* segmentation fault. *
* *
* The trap file produced will have the below stack: *
* nav_assign_max_levels *
* nav_init *
* form_matches *
* sqlnr_form_common_subexprs *
* sqlnr_optprep *
* sqlnr_optprep_action *
* sqlnr_comp *
* sqlnr_seq *
* sqlnr_rcc *
* sqlnr_exe *
* sqlnr_exe *
* sqlnn_cmpl *
* sqlnn_cmpl *
* sqlra_compile_var *
* *
* or *
* *
* is_RIDC_qnc *
* UDT_colequiv_exp *
* sqlnr_coleq_class_cond *
* sqlnr_comp *
* sqlnr_seq *
* sqlnr_rcc *
* sqlnr_endqtb_action *
* sqlnr_comp *
* sqlnr_seq *
* sqlnr_rcc *
* sqlnr_start_action *
* sqlnr_comp *
* sqlnr_seq *
* sqlnr_rcc *
* sqlnr_exe *
* sqlnn_cmpl *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB version 9.7 fixpack 6. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 6. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC78682 IC78683
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 14.09.2011
11.06.2012
11.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
