Symptom
Server is crashing with the following error during the executing of a simple SELECT statement.
**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_server.cxx:1926
*** PID: 23653
*** Message: caught signal 11, program abort
*** Thread: 140279487178496 (TID: 55)
**************************************************
** Error from IQ connection: SA connHandle: 1745 SA connID: 65 IQ connID: XXXXXXXX User: XXXXXXl
** Time of error: 2017-02-15 16:45:57
** IQ Version: SAP IQ/16.0.110/10361/P/sp11.05
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/XXXXXXXX/2.6.32-642.el6.x86_64/#1 SMP Wed Apr 13 00:51:26 EDT 2016/x86_64
** Command status when error occured: CURSOR ACTIVE
** Command text:
. 02/15 16:45:57. 0000058615 Dump all thread stacks at stcxtlib/st_server.cxx:1926 for PID: 23653
***************** This is the STACKTRACE ***************
===== Thread Number 140279487178496 (IQ connID: 0000058615) =====
pc: 0x7f955494ae42 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
pc: 0x7f955494b4b1 ucstkgentrace(int, int)+0x121
pc: 0x7f955494c889 DumpAllThreads(char const*, unsigned int, int)+0x259
pc: 0x7f95546c8c5a hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x26a
pc: 0x7f955546ec9f SigHndlr+0x4f
pc: 0x7f9b82cc97e0 _fini+0x2c4a8f98
pc: 0x7f9555030881 s_index::NullCount()+0x21
pc: 0x7f955425e68e dfe_BaseColumn::SetIndexForMetaData(s_index*)+0x16e
pc: 0x7f955425e765 dfe_BaseColumn::FindBestIndexForMetaData()+0x95
pc: 0x7f955425a405 dfe_BaseColumn::GatherMetaData()+0x175
pc: 0x7f955425b477 dfe_BaseColumn::EnsureMetaDataWasGathered()+0x27
pc: 0x7f955425e891 dfe_BaseColumn::GetNullCount()+0x11
pc: 0x7f955466b907 opt_QueryTree::GenerateInferredPredicates(opt_QueryNode*)+0xa17
pc: 0x7f955466ca95 opt_QueryTree::ProcessPredicates()+0xb5
pc: 0x7f955466ef41 opt_Select::ProcessPredicates(df_Heap*, opt_QueryExp*)+0xf1
pc: 0x7f95545de499 opt_Driver::OptimizeQueryExp(st_cursor*, opt_QueryExp*)+0x2b9
pc: 0x7f95545e1e7f opt_Driver::GenerateTree(QueryNode*, st_cursor*, a_statement const*, UITable*, UIIndex*, s_bm*, unsigned int*, db_RebuildIndexInfo**, int, a_table*, hos_vector_noerror*, hs_store*, int, db_IQParallelIndexInfo*, rv_MergeCmdState*)+0x35f
pc: 0x7f955542916d st_cursorIQtoSA::Parse()+0x12d
pc: 0x7f9554242fe6 df_OpenCursor::Parse()+0x76
pc: 0x7f955541aa43 st_command::DoCmdThroughResourceGate()+0x43
pc: 0x7f955546bf78 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x78
pc: 0x7f95541dc2e5 UIQDML_OpenCursor+0x25
pc: 0x7f95554734f6 st_SAIQInterfaceInfo::callFunction()+0x26
pc: 0x7f95554dedae st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1ac
pc: 0x7f9555473e6a st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x20a
pc: 0x7f955495e2a1 saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x91
pc: 0x7f9b836faf5b df_OmniRowScan::Restart(a_cursor_orientation)+0x2cb
pc: 0x7f9b836d59c1 dfo_Scan::DoFetch(a_cursor_orientation)+0xd1
pc: 0x7f9b836d4242 dfo_Scan::DoFirstFetch(a_cursor_orientation)+0xd2
pc: 0x7f9b836b92d7 dfo_Base::Fetch(a_cursor_orientation)+0x107
pc: 0x7f9b836bffc3 dfo_Root::DoFetch(a_cursor_orientation)+0x53
pc: 0x7f9b836bbaf2 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x42
pc: 0x7f9b836b92d7 dfo_Base::Fetch(a_cursor_orientation)+0x107
pc: 0x7f9b836bb8c2 dfo_Root::DoFetchRelative(int, int*)+0xc2
pc: 0x7f9b836bc8e2 dfo_Root::FetchRelative(int, int*)+0xf2
pc: 0x7f9b83322a8d DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x7d
pc: 0x7f9b8346d792 do_move_cursor(a_db_cursor*, int, unsigned int, unsigned int, unsigned int)+0x92
pc: 0x7f9b8346ffda dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0x2ea
pc: 0x7f9b83590e84 db__fetch(Connection*, an_sqlpres_receive*)+0x1c4
pc: 0x7f9b835ae844 RequestProcedure::call()+0xcd4
pc: 0x7f9b833e581e Context::call(Procedure*, Context**)+0x4e
pc: 0x7f9b833e5906 Worker::call_on_stack(Procedure*)+0x56
pc: 0x7f9b835a973d TopProcedure::call()+0x3d
pc: 0x7f9b833ea739 Worker::spawn(Procedure*)+0x49
pc: 0x7f9b835a9c4c EngStream::handle_ind(unsigned char, unsigned int)+0x13c
pc: 0x7f9b835acd35 EngStream::execute()+0xd65
pc: 0x7f9b835a8b05 RQBaseItem::do_work(Worker*)+0x25
pc: 0x7f9b835f1e66 RequestQueue::worker_body()+0x66
pc: 0x7f9b835a9995 request_task(void*)+0x65
pc: 0x7f9b83ad4edd run_task_body+0x2d
Read more...
Environment
SAP IQ 16 SP11.x
Product
Keywords
CR805776, CR#805776, 805776, in-memory, FP index, reference, count , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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