|
Problem IC70161
|
Status: Closed |
DB2 MAY ABEND WHILE TRYING TO COMPILE A QUERY WITH 1 = 0 PREDICATE. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
DB2 might abend while compiling a query containing a 1 = 0
predicate. The query might
also be referencing a union all view with 12 or more branches.
The stack trace looks similar to:
<StackTrace>
-------Frame------ ------Function + Offset------
0x0900000001DB16BC validateOnGetBlock__7SMdPoolCFv + 0x0
0x0900000000C60474 sqlofmblkEx + 0xEC
0x0900000001F8DD48 sqlng_pop__FP9sqlng_blkPPUcP13SQLNG_ELEMENT +
0x20
0x0900000001B1E808
sqlng_build_PSR__FP9sqlng_blkUliPcP9sqlnq_funP17sqlnn_dat_TYPTYP
EN23P10sqlri_ufobP9sqlnq_pid + 0x218
0x0900000001B1BF5C
sqlng_build_UFOB_obj__FP9sqlng_blkP9sqlnq_pidPP10sqlri_ufob +
0x14A0
0x0900000001B1A818
sqlng_build_U_X_op__FP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid +
0x78
0x09000000036F3F54
sqlng_process_parse_tree_node__FP9sqlng_blkP9sqlnq_pid + 0x580
0x0900000003B35514
sqlng_process_BF_node__FP9sqlng_blkP9sqlnq_pid + 0x134
0x0900000003B34234 sqlng_walk_HXP_chain__FP9sqlng_blk + 0x318
0x0900000003B3151C
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x72C
0x0900000003B57EB8
sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb +
0x1FC0
0x0900000003B73C94
sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator +
0xB94
0x0900000003B30F48
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158
0x0900000003B685B8
sqlng_process_nljn_op__FP9sqlng_blkP19sqlno_plan_operator +
0x14B4
0x0900000003725064
sqlng_process_unique_op__FP9sqlng_blkP19sqlno_plan_operator +
0x404
0x0900000003B7B1B4
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
0x490
0x0900000003B825C0
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
0x36C
0x090000000372A724
sqlng_process_groupby_op__FP9sqlng_blkP19sqlno_plan_operator +
0x3A8
0x0900000003B7B1B4
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
0x490
0x0900000003B825C0
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
0x36C
0x0900000003B7B1B4
sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator +
0x490
0x0900000003B825C0
sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator +
0x36C
0x0900000003B83068
sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator +
0x868
0x0900000003B30F48
sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158
0x09000000036E47B8 sqlng_main__FP9sqlnq_qur + 0x2D40
0x090000000370CAD4 sqlng_main__FP9sqlnq_qur@glue1229 + 0x70
0x0900000001F2EAF8
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x1DB8
0x0900000000FA5210
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x24
***********0x0900000000FA723C
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sqlra
_cached_varPiPUl + 0x60C
0x0900000000FF9F6C
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_INF
OPP16sqlra_cached_varT12_PUlb + 0x400
0x0900000000FFD128 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x440
0x09000000028EFA6C
sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x138
0x09000000021A244C
sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0xAE4
0x090000000115F038
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x14C
0x0900000000EDD760
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124
0x0900000000EDF260 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb
+ 0x218
0x0900000000FD4804
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98
0x0900000000FD465C
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0
0x0900000000FD43E4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T +
0xD8
0x0900000000DA0BC4 RunEDU__8sqeAgentFv + 0x11C
0x0900000000DA0940 EDUDriver__9sqzEDUObjFv + 0x94
0x0900000000D9A8B8 sqloEDUEntry + 0x57C
</StackTrace>
Classification: Defect info: wsdbu00775699
Fix In Product: DB2 v9.5 fixpak 7 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 MAY ABEND WHILE TRYING TO COMPILE A QUERY WITH 1 = 0 *
* PREDICATE. *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2 might abend while compiling a query containing a 1 = 0 *
* *
* predicate. The query might *
* *
* also be referencing a union all view with 12 or more *
* branches. *
* *
* *
* The stack trace looks similar to: *
* *
* <StackTrace> *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x0900000001DB16BC validateOnGetBlock__7SMdPoolCFv + 0x0 *
* *
* 0x0900000000C60474 sqlofmblkEx + 0xEC *
* *
* 0x0900000001F8DD48 *
* sqlng_pop__FP9sqlng_blkPPUcP13SQLNG_ELEMENT + *
* 0x20 *
* *
* 0x0900000001B1E808 *
* *
* sqlng_build_PSR__FP9sqlng_blkUliPcP9sqlnq_funP17sqlnn_dat_TYPT
* EN23P10sqlri_ufobP9sqlnq_pid + 0x218 *
* *
* 0x0900000001B1BF5C *
* *
* sqlng_build_UFOB_obj__FP9sqlng_blkP9sqlnq_pidPP10sqlri_ufob *
* + *
* 0x14A0 *
* *
* 0x0900000001B1A818 *
* *
* sqlng_build_U_X_op__FP9sqlng_blkPP12sqlri_opparmP9sqlnq_pid *
* + *
* 0x78 *
* *
* 0x09000000036F3F54 *
* *
* sqlng_process_parse_tree_node__FP9sqlng_blkP9sqlnq_pid + *
* 0x580 *
* 0x0900000003B35514 *
* *
* sqlng_process_BF_node__FP9sqlng_blkP9sqlnq_pid + 0x134 *
* *
* 0x0900000003B34234 sqlng_walk_HXP_chain__FP9sqlng_blk + *
* 0x318 *
* 0x0900000003B3151C *
* *
* sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x72C *
* *
* 0x0900000003B57EB8 *
* *
* sqlng_build_TA_op__FP9sqlng_blkP14sqlng_scan_blkP9sqlno_qtb *
* + *
* 0x1FC0 *
* *
* 0x0900000003B73C94 *
* *
* sqlng_process_scan_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0xB94 *
* *
* 0x0900000003B30F48 *
* *
* sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158 *
* *
* 0x0900000003B685B8 *
* *
* sqlng_process_nljn_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x14B4 *
* *
* 0x0900000003725064 *
* *
* sqlng_process_unique_op__FP9sqlng_blkP19sqlno_plan_operator *
* + *
* 0x404 *
* *
* 0x0900000003B7B1B4 *
* *
* sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x490 *
* *
* 0x0900000003B825C0 *
* *
* sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x36C *
* *
* 0x090000000372A724 *
* *
* sqlng_process_groupby_op__FP9sqlng_blkP19sqlno_plan_operator *
* + *
* 0x3A8 *
* *
* 0x0900000003B7B1B4 *
* *
* sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x490 *
* *
* 0x0900000003B825C0 *
* *
* sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x36C *
* *
* 0x0900000003B7B1B4 *
* *
* sqlng_process_mate_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x490 *
* *
* 0x0900000003B825C0 *
* *
* sqlng_process_pipe_op__FP9sqlng_blkP19sqlno_plan_operator + *
* *
* 0x36C *
* *
* 0x0900000003B83068 *
* *
* sqlng_process_return_op__FP9sqlng_blkP19sqlno_plan_operator *
* + *
* 0x868 *
* *
* 0x0900000003B30F48 *
* *
* sqlng_build_thread__FP9sqlng_blkP14sqlng_thd_ctrl + 0x158 *
* *
* 0x09000000036E47B8 sqlng_main__FP9sqlnq_qur + 0x2D40 *
* *
* 0x090000000370CAD4 sqlng_main__FP9sqlnq_qur@glue1229 + 0x70 *
* *
* 0x0900000001F2EAF8 *
* *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14
* lrr_cmpl_enviT7PP9sqlnq_qur + 0x1DB8 *
* *
* 0x0900000000FA5210 *
* *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14
* lrr_cmpl_env + 0x24 *
* *
* ***********0x0900000000FA723C *
* *
* sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P16sql
* _cached_varPiPUl + 0x60C *
* *
* 0x0900000000FF9F6C *
* *
* sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_id
* T4PUcT4UsUcP14sqlra_cmpl_enviPiT11_T12_N311_T12_P14SQLP_LOCK_I
* OPP16sqlra_cached_varT12_PUlb + 0x400 *
* *
* 0x0900000000FFD128 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + *
* 0x440 *
* 0x09000000028EFA6C *
* *
* sqlrr_prepare__FP14db2UCinterfaceP16db2UCprepareInfo + 0x138 *
* *
* 0x09000000021A244C *
* *
* sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP13sqljDDMObject + *
* 0xAE4 *
* 0x090000000115F038 *
* *
* sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2
* interface + 0x14C *
* *
* 0x0900000000EDD760 *
* *
* sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 *
* *
* 0x0900000000EDF260 *
* @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb *
* + 0x218 *
* *
* 0x0900000000FD4804 *
* *
* @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 *
* *
* 0x0900000000FD465C *
* *
* @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 *
* *
* 0x0900000000FD43E4 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T *
* + *
* 0xD8 *
* *
* 0x0900000000DA0BC4 RunEDU__8sqeAgentFv + 0x11C *
* *
* 0x0900000000DA0940 EDUDriver__9sqzEDUObjFv + 0x94 *
* *
* 0x0900000000D9A8B8 sqloEDUEntry + 0x57C *
* *
* </StackTrace> *
****************************************************************
* RECOMMENDATION: *
* As a work around customers can use opt level 3 *
**************************************************************** |
| Local Fix: |
As a work around customers can use opt level 3 |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 26.07.2010
12.05.2011
12.05.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
