DB2 - Problembeschreibung
Problem IT08967 | Status: Geschlossen |
DB2 MAY CRASH ON VIEW GENERATION AUTH CHECK. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In the trap file, a similar stack trace will be generated: <StackTrace> -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00002AAAB045718F ossDumpStackTraceEx + 0x01ef 0x00002AAAB0451F4E _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00002AAAAD39E21F sqlo_trce + 0x03fb 0x00002AAAAD3E73DF sqloEDUCodeTrapHandler + 0x02db 0x0000003F05A0ECA0 address: 0x0000003F05A0ECA0 ; dladdress: 0x0000003F05A00000 ; offset in lib: 0x000000000000ECA0 ; 0x00002AAAADA0D896 _Z35sqlrlBuildTableOrViewAuthsRPCBufferP8sqlrr_cbPhsS1_sshiPsitb b11sqlr_aainfoP13SQLO_MEM_POOLPjPS1_b + 0x00ee 0x00002AAAADA0EB5D _Z8sqlrlguaP8sqlrr_cbPhsS1_sshi11sqlr_aainfoP13SQLO_MEM_POOLP10s qlr_rolesbPsitbbPP9sqlrg_tadPib + 0x0935 0x00002AAAACBA9E92 _Z16sqlnn_auth_checkccP13SQLNQ_UPD_FCSPPjS1_PsPiS4_Pmi + 0x1154 0x00002AAAACFE04B2 _Z21sqlnq_view_finish_qgmP9sqlnq_qunbPmRP9sqlrg_tadRiS5_PjPS6_ + 0x0838 0x00002AAAACFE5262 _Z25sqlnq_ddl_create_view_endP9sqlnq_qtbPm + 0x0170 0x00002AAAACBB36B4 _Z16sqlnn_regen_viewPhsS_sS_sS_sbP17sqlrl_table_parmsPbS2_S2_b + 0x13aa 0x00002AAAADA5DE24 _Z16sqlrl_regen_viewP8sqlrr_cbPhsS1_sS1_sS1_ssbP17sqlrl_table_pa rmsPbS4_b + 0x058e 0x00002AAAABCE8796 _Z26sqlnq_check_referenced_qtbPP9sqlnq_qtbP9sqlnq_qunP3loc21sqln q_hierarchy_usage + 0x0c24 0x00002AAAABCE7806 _Z27sqlnq_handle_from_table_refP20sqlnq_multipart_namePhiPP9sqln q_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8stknod e_ + 0x00ee 0x00002AAAAE14F7BF _Z9sqlnq_semPP8stknode_i10actiontypePhP3loc + 0x120c1 0x00002AAAAE132228 _Z12sqlnp_smactnP8sqlnp_cbi + 0x094c 0x00002AAAABBABBF2 _Z12sqlnp_parserP8sqlnp_cb + 0x092e 0x00002AAAABBAD3FE _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x02ba 0x00002AAAABB227D1 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_enviiPP9sqlnq_qur + 0x0c27 0x00002AAAABB21BA5 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sq lrr_cmpl_env + 0x0021 0x00002AAAABE9A311 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP _LOCK_INFOP16sqlra_cached_varPiPm + 0x0771 0x00002AAAABEA6BEB _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idj jPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOCK _INFOPP16sqlra_cached_varS8_Pmb + 0x05df 0x00002AAAABED01A8 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x0860 0x00002AAAAD5B1EDD _Z13sqlrr_prepareP14db2UCinterfaceP16db2UCprepareInfo + 0x036d 0x00002AAD5558EB56 sqlacall + 0x5af2 0x00002AAD0B1CF7A1 address: 0x00002AAD0B1CF7A1 ; dladdress: 0x00002AAD0B157000 ; offset in lib: 0x00000000000787A1 ; 0x00002AAD0B1CC223 admin_revalidate_db_objects + 0x0b97 0x00002AAAABD87E80 sqloInvokeFnArgs + 0x0040 0x00002AAAABF4C862 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x065e 0x00002AAAABF46056 _Z9sqlricallP8sqlrr_cb + 0x0eee 0x00002AAAAE18716E _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x013e 0x00002AAAABE58C0D _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x07bf 0x00002AAAABE50F19 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x060f 0x00002AAAAC4D18F9 _ZN10pvmPackage14executeSectionEP5sqlcajb + 0x073b 0x00002AAAAC4D3657 _ZN3PVM12executeQueryEjb + 0x0049 0x00002AAAAC4D91E0 _ZN3PVM3runEv + 0x0828 0x00002AAAAC4DD706 pvm_entry + 0x01d6 0x00002AAAABD87E80 sqloInvokeFnArgs + 0x0040 0x00002AAAABF4E801 _Z19sqlriInvokerTrustedP10sqlri_ufobP21sqlriRoutineErrorIntfb + 0x25fd 0x00002AAAABF46056 _Z9sqlricallP8sqlrr_cb + 0x0eee 0x00002AAAAE18716E _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x013e 0x00002AAAABE58C0D _Z29sqlrr_process_execute_requestP8sqlrr_cbib + 0x07bf 0x00002AAAABE50F19 _Z13sqlrr_executeP14db2UCinterfaceP9UCstpInfo + 0x060f 0x00002AAAABA5A975 _Z19sqljs_ddm_excsqlsttP14db2UCinterfaceP13sqljDDMObject + 0x04e7 0x00002AAAAE11E0E3 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface + 0x007d 0x00002AAAABA4369F _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x035b 0x00002AAAABA37A6B address: 0x00002AAAABA37A6B ; dladdress: 0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7AA6B ; 0x00002AAAABA3CF35 address: 0x00002AAAABA3CF35 ; dladdress: 0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7FF35 ; 0x00002AAAABA3A83C address: 0x00002AAAABA3A83C ; dladdress: 0x00002AAAAAABD000 ; offset in lib: 0x0000000000F7D83C ; 0x00002AAAABA3A5AA _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x0102 0x00002AAAAB96A7C6 _ZN8sqeAgent6RunEDUEv + 0x0a74 0x00002AAAAC067CE4 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 0x00002AAAAC067C3B _Z10sqlzRunEDUPcj + 0x0009 0x00002AAAABDC6424 sqloEDUEntry + 0x02f4 0x0000003F05A0683D address: 0x0000003F05A0683D ; dladdress: 0x0000003F05A00000 ; offset in lib: 0x000000000000683D ; 0x0000003F052D500D clone + 0x006d </StackTrace> In db2diag.log, messages similar to these regarding a view generation and a consequent trap sustainability: 2015-04-24-14.04.50.157914-240 I33565956E656 LEVEL: Error PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80 MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view DATA #1 : Hexdump, 29 bytes 0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000 USER_SCHEMA.VIE 0x00002AAD157E4708 : 0000 0000 0000 0000 0000 0000 59 W_TESTE 2015-04-24-14.04.50.196149-240 I33566613E726 LEVEL: Error PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80 MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view DATA #1 : Hexdump, 34 bytes 0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000 USER_SCHEMA.VIEW 0x00002AAD157E4708 : 0000 0000 0000 0000 0000 0000 0000 0000 _TESTXXXXXXXXXXX 0x00002AAD157E4718 : 0000 XX . . . 2015-04-24-14.04.51.079292-240 I33577252E650 LEVEL: Error PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, catalog services, sqlrl_regen_view, probe:80 MESSAGE : SQLRL_REGEN_VIEW: Failure in regenerating view DATA #1 : Hexdump, 23 bytes 0x00002AAD157E46F8 : 0000 0000 0000 0000 0000 0000 0000 0000 USER_SCHEMA.VIEW 0x00002AAD157E4708 : 0000 0000 0000 00 _TESTXX 2015-04-24-14.04.51.396021-240 I33577903E573 LEVEL: Severe PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, RAS/PD component, pdResilienceIsSafeToSustain, probe:800 DATA #1 : String, 37 bytes Trap Sustainability Criteria Checking DATA #2 : Hex integer, 8 bytes 0x0000000400071401 DATA #3 : Boolean, 1 bytes false . . . 2015-04-24-14.04.51.399769-240 I33579628E574 LEVEL: Error PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:3 MESSAGE : Error in agent servicing application with CLIENT PID: DATA #1 : Hexdump, 4 bytes 0x00002AAD1500F460 : 3736 3638 7668 2015-04-24-14.04.51.399834-240 I33580203E678 LEVEL: Error PID : 28713 TID : 46922878413120PROC : db2sysc 1 INSTANCE: db2inst1 NODE : 001 DB : DB_TST1 APPHDL : 1-24371 APPID: 10.37.81.44.58678.150424150944 AUTHID : db2user EDUID : 42584 EDUNAME: db2agent (DB_TST1) 1 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:4 MESSAGE : Error in agent servicing application with INBOUND APPLICATION ID: DATA #1 : Hexdump, 30 bytes 0x000000020D406830 : 3130 2E33 372E 3831 2E34 342E 3538 3637 10.37.81.44.5867 0x000000020D406840 : 382E 3135 3034 3234 3135 3039 3434 8.150424150944 This APAR will prevent the consequent crash in the database. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 v9.7 FP11 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Upgrade to DB2 v9.7 FP11 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 18.05.2015 03.11.2015 03.11.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP11 | |
Problem behoben lt. FixList in der Version | |
9.7.0.11 |