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.