|
Problem IC78653
|
Status: Geschlossen |
DB2 CAN CRASH REMOVING DUPLICATE PREDICATES FROM THE OPTIMIZERS REWRITTEN QUERY |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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: |
|
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 6. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC78682 IC78683
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.09.2011
11.06.2012
11.06.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
