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.