|
Problem IC89714
|
Status: Geschlossen |
POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
When compiling a complex statement with multiple
group-by sub queries, it is possible that the DB2 Query Compiler
will free the same internal memory structure twice.
When this happens, the problem goes undetected until the memory
is reused, during the same query compilation.
This may lead to a crash with possibly several signature call
stacks, a few that have been observed :
1.
sqlnr_pullup_rejoin_qun
sqlnr_pullup_compensations
sqlnr_subsume_derived_match
sqlnr_subsume_match
form_matches
2.
sqlnr_qncdereqc
sqlnr_optprep
sqlnr_optprep
sqlnr_comp
3.
sqlnq_qtb::insert_between
sqlnq_qun::insert_selbox
sqlnr_insert_selbox
sqlnr_optprep
sqlnr_optprep_action |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.01.2013
17.10.2013
17.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
