SAP Knowledge Base Article - Preview

2431666 - Server crashes with stcxtlib/st_server.cxx:1926 - SAP IQ

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

SAP IQ 16.0

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.