DB2 - Problem description
Problem IC65680 | Status: Closed |
DB2 INSTANCE MAY CRASH IN ADD_AGNT_STMT_COUNTS. | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
DB2 instance may crash in add_agnt_stmt_counts due to NULL pointer being referenced. Stack looks like : <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000041DDE24 add_agnt_stmt_counts__11sqlmon_stmtFRC18sqlmon_stmt_countsPC11sq lmon_tqcbCUi + 0x418 0x090000000324762C agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N25N21CiP8sqlrr_cb + 0xB10 0x09000000048371CC sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i + 0x218 0x0900000003B171A8 sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i@glue636 + 0x88 0x09000000037AB770 sqlricls_dbmon_start__FP8sqlrr_cbP9sqlr_apdrP25sqlra_sql_context _siblingP11sqlmon_stmtP11sqlmon_conni + 0x24 0x09000000037C003C sqlricls_complex__FP8sqlrr_cbilN23 + 0x20 0x09000000033DB874 @65@5@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibli ngiN63 + 0xB8 0x09000000033DAD40 sqlracal_finalcmt_rb__FP8sqlrr_cb + 0x3B0 0x09000000033DB224 sqlracal__FP8sqlrr_cbUiT2 + 0x70 0x09000000033DB0FC sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x1A8 0x090000000351EB3C sqlrrbck__FP8sqlrr_cbiN32P13sqlxaCallInfo + 0x354 0x0900000003654DA4 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l + 0x498 0x0900000002AE06C0 sqlrr_prepare__FP14db2UCinterfaceP13UCprepareInfo + 0x2CC 0x0900000002B1E5DC sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0x9D4 0x090000000364FF4C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2U Cinterface + 0x198 0x09000000036687DC sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x28C 0x090000000366753C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x94 0x090000000340379C @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4 0x09000000034035F4 @48@sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xD4 0x0900000003403398 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x9C 0x09000000034043C4 sqleRunAgent__FPcUi + 0x368 0x090000000340272C sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 0x0900000003401CCC sqloSpawnEDU + 0x234 0x0900000003401798 sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb + 0x314 0x090000000350DEE8 sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16 sqlkdRqstRplyFmtP17sqle_connect_info + 0x82C 0x09000000037FC2D0 sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16sqlkdRqs tRplyFmtT1 + 0x44C 0x090000000357F0E0 sqlcctcpconnmgr_child__FPcUi + 0x11E0 0x090000000340272C sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 0x0900000003401CCC sqloSpawnEDU + 0x234 0x090000000420C120 sqlcctcpconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfdUs + 0x58C 0x090000000420A0D4 sqlcctcp_start_listen + 0x44 0x0900000004209FDC sqlcctcp_start_listen@glue44D + 0x74 0x0900000003824134 sqlccstrts__FP9sqlf_kcfdP15SQLCC_CONNMGR_TRUs + 0x2C4 0x0000000100004C10 sqleInitSysCtlr__FPi + 0xE8C 0x00000001000031D4 sqleSysCtlr__Fv + 0x320 0x0900000002ED968C @49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x524 0x09000000037F85F4 sqloRunInstance + 0xAC 0x00000001000029F8 DB2main + 0x930 0x0000000100003D50 main + 0x10 </StackTrace> | |
Problem Summary: | |
DB2 INSTANCE MAY CRASH IN ADD_AGNT_STMT_COUNTS. DB2 instance may crash in add_agnt_stmt_counts due to NULL pointer being referenced. Stack looks like : <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000041DDE24 add_agnt_stmt_counts__11sqlmon_stmtFRC18sqlmon_stmt_countsPC11sq lmon_tqcbCUi + 0x418 0x090000000324762C agent_stmt_start__10sqlmon_acbFCUiPCUcN22CUsT1N25N21CiP8sqlrr_cb + 0xB10 0x09000000048371CC sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i + 0x218 0x0900000003B171A8 sqlra_agent_stmt_start__FP8sqlrr_cbCUiUsN33i@glue636 + 0x88 0x09000000037AB770 sqlricls_dbmon_start__FP8sqlrr_cbP9sqlr_apdrP25sqlra_sql_context _siblingP11sqlmon_stmtP11sqlmon_conni + 0x24 0x09000000037C003C sqlricls_complex__FP8sqlrr_cbilN23 + 0x20 0x09000000033DB874 @65@5@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibli ngiN63 + 0xB8 0x09000000033DAD40 sqlracal_finalcmt_rb__FP8sqlrr_cb + 0x3B0 0x09000000033DB224 sqlracal__FP8sqlrr_cbUiT2 + 0x70 0x09000000033DB0FC sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x1A8 0x090000000351EB3C sqlrrbck__FP8sqlrr_cbiN32P13sqlxaCallInfo + 0x354 0x0900000003654DA4 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l + 0x498 0x0900000002AE06C0 sqlrr_prepare__FP14db2UCinterfaceP13UCprepareInfo + 0x2CC 0x0900000002B1E5DC sqljs_ddm_prpsqlstt__FP14db2UCinterfaceP14sqljsDDMObject + 0x9D4 0x090000000364FF4C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP14sqljsDDMObjectP14db2U Cinterface + 0x198 0x09000000036687DC sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x28C 0x090000000366753C @48@sqljsSqlam__FP14db2UCinterfaceP13sqle_agent_cbb + 0x94 0x090000000340379C @48@sqljsDriveRequests__FP13sqle_agent_cbP11UCconHandle + 0xA4 0x09000000034035F4 @48@sqljsDrdaAsInnerDriver__FP17sqlcc_init_structb + 0xD4 0x0900000003403398 sqljsDrdaAsDriver__FP17sqlcc_init_struct + 0x9C 0x09000000034043C4 sqleRunAgent__FPcUi + 0x368 0x090000000340272C sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 0x0900000003401CCC sqloSpawnEDU + 0x234 0x0900000003401798 sqleCreateNewAgent__FiP8sqlekrcbP17sqlcc_init_structP16sqlkdRqst RplyFmtP18sqle_master_app_cbT1P20agentPoolLatchVectorP16SQLO_EDU WAITPOSTP17sqle_connect_infoPP13sqle_agent_cb + 0x314 0x090000000350DEE8 sqleGetAgentFromPool__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16 sqlkdRqstRplyFmtP17sqle_connect_info + 0x82C 0x09000000037FC2D0 sqleGetAgent__FiP17sqlcc_init_structT1P12sqlz_app_hdlP16sqlkdRqs tRplyFmtT1 + 0x44C 0x090000000357F0E0 sqlcctcpconnmgr_child__FPcUi + 0x11E0 0x090000000340272C sqloCreateEDU__FPFPcUi_vPcUlP13SQLO_EDU_INFOPi + 0x270 0x0900000003401CCC sqloSpawnEDU + 0x234 0x090000000420C120 sqlcctcpconnmgr__FP15SQLCC_CONNMGR_TP9sqlf_kcfdUs + 0x58C 0x090000000420A0D4 sqlcctcp_start_listen + 0x44 0x0900000004209FDC sqlcctcp_start_listen@glue44D + 0x74 0x0900000003824134 sqlccstrts__FP9sqlf_kcfdP15SQLCC_CONNMGR_TRUs + 0x2C4 0x0000000100004C10 sqleInitSysCtlr__FPi + 0xE8C 0x00000001000031D4 sqleSysCtlr__Fv + 0x320 0x0900000002ED968C @49@sqloSystemControllerMain__FCUiPFv_iPFi_vPPvCPi + 0x524 0x09000000037F85F4 sqloRunInstance + 0xAC 0x00000001000029F8 DB2main + 0x930 0x0000000100003D50 main + 0x10 </StackTrace> | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Solution | |
First fixed in db2 v9.5 fixpack 6. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 20.01.2010 13.09.2010 13.09.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP6 | |
Problem solved according to the fixlist(s) of the following version(s) |