|
Problem IC89714
|
Status: Closed |
POSSIBLE ABEND DUE TO DOUBLE FREE IN STMTHEAP MEMORY WHEN COMPILING A COMPLEX QUERY WITH MULTIPLE GROUP-BY SUBQUERIES |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.01.2013
17.10.2013
17.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
