DB2 - Problembeschreibung
Problem IC98958 | Status: Geschlossen |
DB2 ABEND WITH SIGSEV WHEN EXECUTING "REVOKE EXECUTE ON FUNCTION" COMMAND | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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 | |
Lösung | |
First Fixed in DB2 V97 FP8 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 23.01.2014 10.03.2014 10.03.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP8 | |
Problem behoben lt. FixList in der Version |