Symptom
Database crashed with signal 11 in the post phase of installing fixpack.
db2 "SELECT * FROM SYSIBM.SYSINVALIDOBJECTS"; wait;'; wait; <
SQL1224N The database manager is not able to accept new requests, has
terminated all requests in progress, or has terminated the specified request
because of an error or a forced interrupt. SQLSTATE=55032
MESSAGE: Error creating system routine : SYSPROC.ADMIN_GET_SYSIBM_FUNCTIONS
MESSAGE: Rolling back work due to sqlcode: -1224 on line 2314.
MESSAGE: rollback with sqlcode: -1032.
db2updv115 processing failed for database 'ABC.
A FODC_Trap* folder is generated, and the stack trace looks like the followings:
--------------------------------------------------------------------------------------
instance name: db2abc.000
EDU name : db2pkgrb (abc) 0 [-]
EDU ID : 12345
Signal #11
Signal #11 (SIGSEGV): si_addr is 0x0A0002004297564E, si_code is 0x00000032 (SEGV_MAPERR:Address not mapped to object.)
<StackTrace>
------Function + Offset------
ftb_privatize__9sqlnq_ftbFP3locP13SQLO_MEM_POOL + 0x50C
sqlnq_check_referenced_qtb__FPP9sqlnq_qtbP9sqlnq_qunP3loc21sqlnq_hierarchy_usage + 0x17AC
sqlnq_check_referenced_qtb__FP9sqlnq_qunP3loc21sqlnq_hierarchy_usage + 0x8C
sqlnq_handle_from_table_ref__FP20sqlnq_multipart_namePUciPP9sqlnq_qunP9sqlnq_qtbP3locP9sqlnq_opr21sqlnq_hierarchy_usagePP8stknode_ + 0x300
sqlnq_sem__FPP8stknode_i10actiontypePUcP3loc + 0x15D4
sqlnp_smactn__FP8sqlnp_cbi + 0x4CC
sqlnp_parser__FP8sqlnp_cb + 0x380
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xFBC
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_enviT7PP9sqlnq_qurP12sqlrr_modifyP12sqlrr_sqlopt + 0xAA3C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_envP12sqlrr_modifyP12sqlrr_sqlopt + 0x30
sqlra_compile_var__FP8sqlrr_cbP14sqlra_cmpl_envPUciUsN54P14SQLP_LOCK_INFOP16sqlra_cached_varPiT11_Pb + 0xC88
sqlra_find_var__FP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idUiT4PUcT4UsUcP14sqlra_cmpl_env15sqlra_fill_modePiiT12_N313_T12_P14SQLP_LOCK_INFOPP16sqlra_cached_varT12_bT19_Pb + 0xBA0
sqlra_get_var__FP8sqlrr_cbiT2bPbT5 + 0xC78
sqlri_ddl_get_section__FP8sqlrr_cb + 0x90
sqlri_ddl_common__FP8sqlrr_cb + 0xFBC
sqlriddl__FP8sqlrr_cb + 0x34
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x698
sqlra_internal_sql__FP8sqlrr_cbPUciT3UlPiT3P10sqlz_valueP21sqlra_internal_sql_cbT5 + 0x5E48
sqlnn_regen_procedure_inner__FP8sqlrr_cbPUcUsiT2sbT7P11sqlrg_rtnpdPb + 0x20B0
sqlnn_regen_procedure__FP8sqlrr_cbPUcUsiT2sP11sqlrg_rtnpdPbb + 0x158
sqlrlFindProcedure__FP8sqlrr_cbPUcUsT2T3T2T3T2T3T2N23iP15sqlra_func_pathT2P22sqlrg_resolved_rt_listT13_P13SQLO_MEM_POOLbT3P16sqlnq_stringlistPP18sqlra_routine_infoT22_T2RUsT2T25_RP11sqlrg_rtnpdPUi + 0x780
sqlnq_resolve_procedure__FP9sqlnq_pidP12sqlnq_stringPUcP22sqlrg_resolved_rt_listiP3loc + 0x26B4
sqlnq_procedure_tresolve__FP9sqlnq_qtbP9sqlnq_pidP12sqlnq_stringPUcP22sqlrg_resolved_rt_listiP3loc + 0x12C
sqlnq_call_stmt__FPP8stknode_i10actiontypePUcP3loc + 0x3D4
sqlnp_smactn__FP8sqlnp_cbi + 0x4CC
sqlnp_parser__FP8sqlnp_cb + 0x9E0
sqlnp_main__FP12sqlnq_stringbP3locPP9sqlnq_qur + 0xFBC
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_enviT7PP9sqlnq_qurP12sqlrr_modifyP12sqlrr_sqlopt + 0xAA3C
sqlnn_cmpl__FP8sqeAgentP11sqlrrstrings17sqlnn_compileModeT3P14sqlrr_cmpl_envP12sqlrr_modifyP12sqlrr_sqlopt + 0x30
sqlrr_cmpl__FP8sqlrr_cbP11sqlrrstrings17sqlnn_compileModeUcP5sqldaPiPUiPP9sqlri_shdP11compileInfo + 0x704
sqlra_recreate_pkg__FP8sqlrr_cbiT2cP15sqlra_func_pathUc + 0x653C
sqlra_rebind_pkg__FP8sqlrr_cbPUcsT2T3T2iT7cP15sqlra_func_pathb + 0xA94
sqlraFindInvalidPackagesAndRebindThemFunc__FPv + 0x9A4
sqlrlExecuteFuncAgainstAllTenants__FP8sqlrr_cbPFPv_iPvUiUlPUiT5 + 0x27DC
IPRA.$sqlraFindInvalidPackagesAndRebindThem__FP8sqlrr_cb + 0x58
sqlraPackageRebinderDaemonInnerMain__FP8sqeAgent + 0x3E4
sqlraPackageRebinderDaemonOuterMain__FP8sqeAgent + 0x31C
sqleIndCoordProcessRequest__FP8sqeAgent + 0x2E04
RunEDU__8sqeAgentFv + 0xC0C
EDUDriver__9sqzEDUObjFv + 0x300
sqloEDUEntry + 0x364
--------------------------------------------------------------------------------------
Read more...
Environment
- SAP on IBM Db2 for Linux, Unix and Windows
- Db2 LUW version 11.5
Keywords
crash, signal 11, sqlnq_check_referenced_qtb, db2updv115 , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview