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.