|
Problem IC89221
|
Status: Closed |
DB2 ABEND WITH SIGSEV WHEN EXECUTING "REVOKE EXECUTE ON FUNCTION" COMMAND |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
db2 abends with signal 11 when executing the following revoke
command:
revoke execute on function sysproc.* from role <role_name>
restrict
The stack trace looks as follows:
</Siginfo_t>
Signal #11 (SIGSEGV): si_addr is 0x0E000001C0DC3F80, si_code is
0x00000032 (SEGV_MAPERR:Address not mapped to object.)
0x000000000000F590 ?unknown + 0x0
0x0900000013F1A4D4
sqlrlRevokePrivFromRole__FP8sqlrr_cbP15sqlrl_authparmsP12sqlrl_a
uthidUlb + 0x1B4
0x0900000014AC9394 sqlrlrev__FP8sqlrr_cbP15sqlrl_authparmsb +
0x566C
0x0900000012A96698
sqlnq_auth_stmt_end__FP9sqlnq_qtbP3loc10actiontype + 0x48
0x090000001364C378
sqlnq_auth_stmt__FPP8stknode_i10actiontypePUcP3loc + 0x35C
0x0900000010FBC09C sqlnp_smactn__FP8sqlnp_cbi + 0x34
0x0900000010FBC77C sqlnp_parser__FP8sqlnp_cb + 0x174
0x0900000010F7AE2C
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xC0
0x0900000010F52368
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_enviT7PP9sqlnq_qur + 0x29C
0x0900000011000CE8
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sq
lrr_cmpl_env + 0x2C
0x0900000010CB4F1C
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_
LOCK_INFOP16sqlra_cached_varPiPUl + 0x8C4
0x0900000010CB7EF8
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUi
T4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14
SQLP_LOCK_INFOPP16sqlra_cached_varT12_PUlb + 0x57C
0x0900000010CB9E00 sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0x6C4
0x0900000010CC0FB0 sqlri_ddl_get_section__FP8sqlrr_cb + 0x64
0x0900000010CC0D54 sqlri_ddl_common__FP8sqlrr_cb + 0x51C
0x0900000010CC07E0 sqlriddl__FP8sqlrr_cb + 0x30
0x0900000010EBE6CC sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm +
0x61C
0x0900000010CBFB70 sqlrr_execute_immediate__FP8sqlrr_cbi + 0x5B4
0x0900000010CBF49C
sqlrr_execimmd__FP14db2UCinterfaceP16db2UCprepareInfo + 0x18C
0x0900000010CBF218
sqljs_ddm_excsqlimm__FP14db2UCinterfaceP13sqljDDMObject + 0x968
Not much info is dumped into db2diag.log |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Users on DB2 V97 Fp7 and lower *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97 FP8 *
**************************************************************** |
| Local Fix: |
No Local Fix |
| available fix packs: |
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 |
First Fixed in DB2 V97 FP8 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC98958
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.12.2012
02.04.2013
02.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
