Symptom
- Executing a sequence of lock and DDL operations on a table and its view causes server crash with assertion failure and stacktrace.
- In pre - 16.1 SP04 PL13 and SP05 PL03 versions, the same sequence statements causes a silent crash.
- Only message logged is bellow logged in std error file (similar to KBA 3149471 /CR 826178):
"pure virtual method called
terminate called without an active exception" - In IQ 16.1 SP04 PL13 , error and stacktrace below are logged:
*** ERROR *** Assertion failed: 109801 (16.1.40.2015)
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at stcxtlib/st_iqctl.cxx:1344 on thread 140730386585344 (TID 4)
** *** ERROR *** Assertion failed: 109801 (16.1.40.2015)
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 1 SA connID: 30 IQ connID: xxxx User: xxxx
** Time of error: 2022-07-18 09:43:04
** IQ Version: SAP IQ/16.1.040/17090/P/SP04.13
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/lonl34411371a/3.10.0-693.17.1.el7.x86_64/#1 SMP Sun Jan 14 10:36:03 EST 2018/x86_64
** Command status when error occurred: NO COMMAND OR CURSOR ACTIVE
** Parser command text:
===== Thread Number 140730386585344 (IQ connID: xxxx) (IQSaintForbid: 1) =====
pc: 0x7ffdac1ec3d4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x34
pc: 0x7ffdac1ecb71 ucstkgentrace(int, int)+0x191
pc: 0x7ffdac1edab9 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x299
pc: 0x7ffdaba37ed0 UIQCtl_LogAssertionInfoToIQMsg+0x10
pc: 0x7ffdace929bb st_SAIQInterfaceInfo::callFunction()+0x1b
pc: 0x7ffdacefa472 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x222
pc: 0x7ffdace92e7b st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x36b
pc: 0x7ffdac1f7ffa saint_iqthresholdctl::LogAssertionInfoToIQMsg(char const*)+0x5a
pc: 0x7ffff6a94d51 DB_Assert(unsigned int, unsigned int, unsigned int, char const*, ...)+0x2c1
pc: 0x7ffff6a0a3ae EngTerminate()+0x8e
pc: 0x7ffff60c0746 <unknown>
pc: 0x7ffff60c0773 <unknown>
pc: 0x7ffff60c12df <unknown>
pc: 0x7ffff6a275ad TableDefCache::find(unsigned int)+0x6d
pc: 0x7ffff7210f40 Database::FindTableInCache(unsigned int)+0x10
pc: 0x7ffff72162f7 DB_AccessTable(an_errmap_index*, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int*, char*)+0x227
pc: 0x7ffff72167d4 DB_FindTable(unsigned int*, char const*, unsigned int, unsigned int, an_errmap_index*)+0x384
pc: 0x7ffff6cbe279 dbi_find_table_def(a_table*, unsigned int, an_errmap_index*, TableLookupOptions const&, a_priv_op_type, unsigned int)+0x59
pc: 0x7ffff6a2e052 Database::FindTableByName(char const*, char const*, char const*, char const*, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, a_priv_op_type)+0xc2
pc: 0x7ffff72bb060 UseTable(a_ptree_info*, a_table*, unsigned int, unsigned int)+0x5e0
pc: 0x7ffff72bbc3f AddTableExpr(a_ptree_info*, QueryNode*)+0x28f
pc: 0x7ffff72bc0ed BuildQueryExpr(a_ptree_info*, an_expr_op, QueryNode*)+0x1bd
pc: 0x7ffff72bbfbc BuildQueryExpr(a_ptree_info*, an_expr_op, QueryNode*)+0x8c
pc: 0x7ffff72d485b AnnotateSelect(a_ptree_info*, a_statement_option*, QueryNode*)+0x5b
pc: 0x7ffff72d7c4c ParseSupport::Annotate(IDBHeap*, IDBHeap*, Connection*, SACursor*, a_parse_parms*, a_parse_goal, a_statement*, void*, a_tabdef_set**)+0x4fc
pc: 0x7ffff6d4850f AnnotateCtrl::AnnotateParseTree()+0x27f
pc: 0x7ffff6d48faf AnnotateStatement(a_db_cursor*, a_statement*, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, IDBHeap*)+0x8f
pc: 0x7ffff70f29c1 MakeVolcanoOptimizerCursor(IDBHeap*, a_statement*, an_isolation_level, a_cursor_spec*, unsigned int, unsigned int, PlanInfo*, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, df_InternalCursor*, dfv_HostVars**, a_set_of_row_descriptors**, a_query_diagnostics*)+0x221
pc: 0x7ffff6bf7495 MakeCursorForView(IDBHeap*, a_view*, unsigned int, unsigned int, unsigned int)+0x225
pc: 0x7ffff6c830e1 RecompileView(TableDef*, unsigned int)+0x241
pc: 0x7ffff6c84786 dbi_alterview(a_statement*)+0x1026
pc: 0x7ffff6d68797 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+0x15f7
pc: 0x7ffff6d69aa5 DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int)+0xc75
pc: 0x7ffff6d6b0ba db__execute(Connection*, an_sqlpres_receive*)+0x11a
pc: 0x7ffff6d81576 RequestProcedure::call()+0xf06
pc: 0x7ffff6b29711 Worker::spawn(Procedure*)+0x31
pc: 0x7ffff6d853e6 EngStream::handle_ind(unsigned char, unsigned int)+0x156
pc: 0x7ffff6d86f3f EngStream::execute()+0x81f
pc: 0x7ffff6d870bd RQConnItem::do_request()+0xd
pc: 0x7ffff6d7ee6e RQBaseItem::do_work(Worker*)+0x1e
pc: 0x7ffff6dc2a87 RequestQueue::worker_body()+0x77
pc: 0x7ffff6d80229 request_task(void*)+0x89
pc: 0x7ffff7209ace run_task_body+0x1e
pc: 0x7ffff6dc46d1 UnixTask::pre_body(void*)+0x71
pc: 0x7ffff6370ea5 <unknown>
pc: 0x7ffff588c9fd <unknown>
**
** End of stack trace from Non-Fatal IQ Internal Error stcxtlib/st_iqctl.cxx:1344
**
********************************************************
**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:2455
*** PID: 158653
*** Message: caught signal 8, program abort
*** Thread: 140730386585344 (TID: 4)
************************************************** - Messages below are seen
Srvlog : EngineTerminated() called at
Stderr : pure virtual method called
Read more...
Environment
SAP IQ 16.1
Product
SAP IQ 16.1
Keywords
CR 826877, CR#826877 , CR826877 , 826877 , EngineTerminated, 'pure virtual method called' , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement
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