|
Problem IC73969
|
Status: Closed |
DB2 ENGINE TRAPS WHILE COMPILING A PL/SQL PACKAGE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
The instance has the following set:
db2set DB2_COMPATIBILITY_VECTOR=ORA
db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code is
0x00000033 (SEGV_ACCERR:Invalid permissions for mapped object.)
-------Frame------ ------Function + Offset------
0x09000000056455F0 sqloCrashOnCriticalMemoryValidationFailure +
0x34
0x0900000005650F7C
sqloCrashOnCriticalMemoryValidationFailure@glue6DB + 0x78
0x090000000897BA68 sqlofmblkEx + 0x7C
0x09000000089F25BC sqlofmblkEx@glue7C4 + 0x78
0x09000000050AD7E8
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x4C
0x09000000050A7C34
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur
+ 0x22B8
0x0900000008A347E8
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env
+ 0x40
0x0900000008C7933C
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiPUl
+ 0x778
0x0900000008C77200
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb
+ 0x52C
0x0900000008C73F80 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x6BC
0x0900000008C01008 sqlri_ddl_get_section__FP8sqlrr_cb + 0xAC
0x0900000008C00D64 sqlri_ddl_common__FP8sqlrr_cb + 0x4CC
0x0900000008C00840 sqlriddl__FP8sqlrr_cb + 0x3C
0x0900000008AD7908 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x34
0x0900000007B1A610
sqlra_internal_sql__FP8sqlrr_cbPUciT3UlPiT3P10sqlz_valueP21sqlra
_internal_sql_cb
+ 0x3A8
0x0900000006FC7798
sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpdbP17
sqlrl_table_parmsPbN211_
+ 0x204
0x0900000006FC6B08
sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpdbP17
sqlrl_table_parmsPbN211_@glue107C
+ 0xAC
0x09000000067A40A0
@107@sqlnq_findFn__FP12sqlnq_stringN21iPsP15sqlra_func_pathPUcPP
9sqlnq_funPiT4P9sqlnq_pidP17sqlnn_dat_TYPTYPEP3locbsN314_
+ 0xA2C
0x09000000089AE31C
sqlnq_resolveFn__FP9sqlnq_pidP12sqlnq_stringPUcPiP3locisT6 +
0x148
0x09000000089F0B60
sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3loci
T6
+ 0x250 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Using Oracle Compatibility Mode and compiling PL/SQL *
****************************************************************
* PROBLEM DESCRIPTION: *
* The instance has the following set: *
* *
* *
* *
* db2set DB2_COMPATIBILITY_VECTOR=ORA *
* *
* db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES *
* *
* *
* *
* Signal #11 (SIGSEGV): si_addr is 0x0000000000000000, si_code *
* is *
* 0x00000033 (SEGV_ACCERR:Invalid permissions for mapped *
* object.) *
* *
* *
* -------Frame------ ------Function + Offset------ *
* *
* 0x09000000056455F0 *
* sqloCrashOnCriticalMemoryValidationFailure + *
* 0x34 *
* *
* 0x0900000005650F7C *
* *
* sqloCrashOnCriticalMemoryValidationFailure@glue6DB + 0x78 *
* *
* 0x090000000897BA68 sqlofmblkEx + 0x7C *
* *
* 0x09000000089F25BC sqlofmblkEx@glue7C4 + 0x78 *
* *
* 0x09000000050AD7E8 *
* *
* sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0x4C *
* *
* 0x09000000050A7C34 *
* *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P *
* 14sq *
* lrr_cmpl_enviT7PP9sqlnq_qur *
* *
* + 0x22B8 *
* *
* 0x0900000008A347E8 *
* *
* sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P *
* 14sq *
* lrr_cmpl_env *
* *
* + 0x40 *
* *
* 0x0900000008C7933C *
* *
* sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14S *
* QLP_ *
* LOCK_INFOP16sqlra_cached_varPiPUl *
* *
* + 0x778 *
* *
* 0x0900000008C77200 *
* *
* sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_ *
* idUi *
* T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12 *
* _P14 *
* SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb *
* *
* + 0x52C *
* *
* 0x0900000008C73F80 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + *
* 0x6BC *
* 0x0900000008C01008 sqlri_ddl_get_section__FP8sqlrr_cb + 0xAC *
* *
* 0x0900000008C00D64 sqlri_ddl_common__FP8sqlrr_cb + 0x4CC *
* *
* 0x0900000008C00840 sqlriddl__FP8sqlrr_cb + 0x3C *
* *
* 0x0900000008AD7908 *
* sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + *
* 0x34 *
* *
* 0x0900000007B1A610 *
* *
* sqlra_internal_sql__FP8sqlrr_cbPUciT3UlPiT3P10sqlz_valueP21s *
* qlra *
* _internal_sql_cb *
* *
* + 0x3A8 *
* *
* 0x0900000006FC7798 *
* *
* sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpd *
* bP17 *
* sqlrl_table_parmsPbN211_ *
* *
* + 0x204 *
* *
* 0x0900000006FC6B08 *
* *
* sqlnn_regen_function__FP8sqlrr_cbPUcUsT2UlT2T3P11sqlrg_rtnpd *
* bP17 *
* sqlrl_table_parmsPbN211_@glue107C *
* *
* + 0xAC *
* *
* 0x09000000067A40A0 *
* *
* @107@sqlnq_findFn__FP12sqlnq_stringN21iPsP15sqlra_func_pathP *
* UcPP *
* 9sqlnq_funPiT4P9sqlnq_pidP17sqlnn_dat_TYPTYPEP3locbsN314_ *
* *
* + 0xA2C *
* *
* 0x09000000089AE31C *
* *
* sqlnq_resolveFn__FP9sqlnq_pidP12sqlnq_stringPUcPiP3locisT6 + *
* *
* 0x148 *
* *
* 0x09000000089F0B60 *
* *
* sqlnq_fun_tres__FP9sqlnq_pidP12sqlnq_stringPUcPP9sqlnq_pidP3 *
* loci *
* T6 *
* *
* + 0x250 *
****************************************************************
* RECOMMENDATION: *
* Apply this fix. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 |
Fixed. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
