SAP Knowledge Base Article - Preview

2214259 - Crash at st_server.cxx:1442 running query using "with .. as" clause - SAP IQ

Symptom

  • IQ server crashed with stacktrace when executing a query using "with .. as" clause.
  • The following stacktrace reported in iqmsg file and stacktrace file.

    **  IQ Version:  Sybase IQ/15.4.0/140226/P/ESD 4   
    **  OS info:  IQ built on: RS6000MP/AIX 6.1.0,  Executed on: AIX/indigo6/1/6/00F6220A4C00   
    **  Command status when error occured:  CURSOR ACTIVE   
    **  Command text:
    WITH DECLARATION AS
    (
      SELECT CONVERT(DATE,'2015-08-15') AS DATEFROM,
      CONVERT(DATE,'2015-08-25') AS DATETHRU
    )...
    Dump all thread stacks at st_server.cxx:1442 for PID: 19923022
    ***************** This is the STACKTRACE ***************
    ===== Thread Number  8225  (IQ connID: 0000002702) =====
    pc: 0x900000034056568 .pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8()
    pc: 0x900000034055e58 .ucstkgentrace(int,int)+0xb8()
    pc: 0x9000000340545e4 .DumpAllThreads(const char*,unsigned int,int)+0x184()
    pc: 0x9000000337f80f8 .hos_ABORT(const char*,unsigned int,const char*,char*,char*)+0x1d8()
    pc: 0x90000003405bf54 .SigHndlr+0x54()
    pc: 0x900000034241c30 .dfpEvaluate(void*)+0x90()
    pc: 0x9000000346d5e1c .s_dpByteFetch::DFPMatchDistincts(void*,void*,int(*)(void*))+0x15c()
    pc: 0x9000000342c91fc .hs_dp::DFPMatchDistincts(void*,void*,int(*)(void*))+0x9c()
    pc: 0x90000003423762c .dfp::EstimateSelectivityViaDFP(double&,int)+0x2ac()
    pc: 0x9000000342386dc .dfp::EstimateCompareSelectivity(dfe_Column*,int)+0x9dc()
    pc: 0x90000003423c1fc .dfp::EstimateLocalSelectivity(int)+0xd5c()
    pc: 0x90000003423c340 .dfp::EstimateLocalSelectivity(int)+0xea0()
    pc: 0x90000003423c340 .dfp::EstimateLocalSelectivity(int)+0xea0()
    pc: 0x90000003423c3d0 .dfp::EstimateLocalSelectivity(int)+0xf30()
    pc: 0x90000003423d89c .dfp::OrderConjuncts(df_Heap*)+0x11c()
    pc: 0x9000000348a4360 .opt_QueryNode::GenerateFiltersOverThisDFO(hos_vector_noerror&)+0x740()
    pc: 0x9000000348b1c40 .opt_JoinNode::GenerateDFOs()+0x17c0()
    pc: 0x9000000348e6bdc .opt_QueryTree::GenerateDFOTree(opt_QueryNode*)+0xbc()
    pc: 0x9000000348e422c .opt_QueryTree::ProcessQueryTree()+0x20c()
    pc: 0x9000000349302bc .opt_Select::GenerateDFOs(df_Heap*,opt_QueryExp*)+0x1fc()
    pc: 0x900000034878004 .opt_Driver::GenerateTree(QueryNode*,st_cursor*)+0x1264()
    pc: 0x90000003485dc0c .st_cursorIQtoSA::Parse()+0xec()
    pc: 0x900000034e50ba4 .df_OpenCursor::Parse()+0x1e4()
    pc: 0x900000033882fbc .st_command::DoCmdThroughResourceGate()+0x2bc()
    pc: 0x900000034e4a0d4 .st_iqdml::OpenCursor(a_statement*,UIConnection*,UICursor*,a_cursor_spec*,a_cursor_orientation)+0x54()
    pc: 0x900000034dc17cc .UIQDML_OpenCursor+0x4c()
    pc: 0x900000033890120 .st_SAIQInterfaceInfo::callFunction()+0x40()
    pc: 0x900000034ed7a50 .st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x170()
    pc: 0x900000033891020 .st_SAIQInterface::Execute(int,void*,unsigned int(*)(void*,void*),void*,unsigned int)+0x600()
    pc: 0x900000034e8ebc4 .saint_iqthresholddml::OpenCursor(a_statement*,IConnection*,ICursor*,a_cursor_spec*,a_cursor_orientation)+0xe4()
    pc: 0x90000002504583c .df_OmniRowScan::Restart(a_cursor_orientation)+0x25c()
    pc: 0x9000000249cd13c .dfo_Scan::DoFetch(a_cursor_orientation)+0x7c()
    pc: 0x9000000249cce58 .dfo_Scan::DoFirstFetch(a_cursor_orientation)+0x138()
    pc: 0x9000000242c587c .dfo_Base::Fetch(a_cursor_orientation)+0x27c()
    pc: 0x9000000242b7378 .dfo_Root::DoFetch(a_cursor_orientation)+0x278()
    pc: 0x9000000242b685c .dfo_Root::DoFirstFetch(a_cursor_orientation)+0x3c()
    pc: 0x9000000242c587c .dfo_Base::Fetch(a_cursor_orientation)+0x27c()
    pc: 0x9000000242bd93c .dfo_Root::DoFetchRelative(int,int*)+0x1bc()
    pc: 0x9000000242bd724 .dfo_Root::FetchRelative(int,int*)+0x144()
    pc: 0x9000000249bfcf4 .DB_Search_fetch(a_db_cursor*,unsigned int,int,int*)+0xd4()
    pc: 0x90000002448797c .do_move_cursor(a_db_cursor*,int,unsigned int,unsigned int,unsigned int)+0x7c()
    pc: 0x900000024486954 .move_cursor(a_db_cursor*,int,unsigned int,unsigned int,unsigned int,unsigned int)+0x94()
    pc: 0x900000024486800 .dbi_fetch(a_db_cursor*,int,unsigned short,unsigned int,unsigned int,unsigned int,unsigned int,unsigned int)+0x360()
    pc: 0x9000000244765d4 .db__fetch(Connection*,an_sqlpres_receive*)+0x1b4()
    pc: 0x9000000242e3cb8 .RequestProcedure::call()+0xc78()
    pc: 0x900000024451d38 .Context::call(Procedure*,Context**)+0x78()
    pc: 0x900000024453788 .Worker::call_on_stack(Procedure*)+0x48()
    pc: 0x9000000242e5564 .TopProcedure::call()+0x44()
    pc: 0x900000024453098 .Worker::spawn(Procedure*)+0x98()
    pc: 0x9000000242e5764 .EngStream::handle_ind(unsigned char,unsigned int)+0xc4()
    pc: 0x9000000242e6134 .EngStream::execute()+0x4f4()
    pc: 0x9000000242e7ac8 .RQBaseItem::do_work(Worker*)+0x48()
    pc: 0x900000024240424 .RequestQueue::worker_body()+0xc4()
    pc: 0x9000000242e7988 .request_task(void*)+0x88()
    pc: 0x90000002444aa08 .run_task_body+0x48()
    pc: 0x900000024447894 .UnixTask::pre_body(void*)+0x134()
    pc: 0x900000000a8ad54 ()


Read more...

Environment

SAP IQ 15 ESD#4.

Product

SAP Sybase IQ 15.4

Keywords

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 for Me (Login required).

Search for additional results

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