2431666 - Servers crashes with stcxtlib/st_server.cxx:1926 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2431666 - Servers crashes with stcxtlib/st_server.cxx:1926

Symptom

In  multiplex environment on IQ 16.0 SP11 PL05 with DQP enabled with shared temp.
Server is crashing with 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: 0000058615  User: bosecuqryappl
      **  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/svlipcyb/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, dfe_BaseColumn::FindBestIndexForMetaData, dfe_BaseColumn::EnsureMetaDataWasGathered, dfe_BaseColumn::GetNullCount , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.