SAP Knowledge Base Article - Preview

2051964 - SAP IQ - Server crashed when a user ran query in Interactive SQL with queryplan view enable

Symptom

  • IQ server crashed and generated a standard IQ stack trace file. Example: stktrc-20140805-154440_1.iq
  • In the stacktrace file, the following error and stack can be seen:
  • **  Error from IQ connection:  NONE    **  Time of error:  2014-08-05 15:44:40    **  IQ Version:  Sybase IQ/12.7.0/111031/P/ESD 5.12    **  OS info
    :  IQ built on: Sun_svr4/OS 5.9,  Executed on: SunOS/sppmd571/5.10/Generic_142909-17/sun4u    **  Command status when error occured:  NO COMMAND OR CURS
    OR ACTIVEDump all thread stacks at st_server.cxx:1201 for PID: 5174
    ***************** This is the STACKTRACE **************
     waitid
     waitpid
     system
     void DumpAllThreads
     void hos_ABORT
     SigHndlr
     __sighndlr
     call_user_handler
     sigacthandler
     void DFPlanVisitor::OutputShortPlan(a_dfo_root*)
     unsigned query_message_expr(a_db_cursor*,PlanInfo*,UTOStream&)
     void dbi_access_plan(an_expr*,int)
     an_expr*an_ExprBuilder::DB_Find_expr(an_expr*,unsigned)
     an_expr*an_ExprBuilder::DB_Find_op(an_op_def*,an_expr*,a_domain_def*,unsigned,unsigned,unsigned)
     an_expr*an_ExprBuilder::DB_Func(an_expr**,unsigned,an_op_type*,unsigned,unsigned,unsigned,unsigned)
     an_expr*an_ExprBuilder::initStandardFunction(a_builtin_node*,const char*,unsigned)
     an_expr*an_ExprBuilder::init_func(a_builtin_node*)
     an_expr*an_ExprBuilder::DE_BuildExpr(an_expr_node*)
     unsigned DB_Build_simple_cursor(a_db_cursor*,a_statement*)
     a_db_cursor*MakeVolcanoOptimizerCursor(void*,a_statement*,int,a_cursor_spec*,unsigned,unsigned,PlanInfo*,unsigned,unsigned,unsigned)
     a_db_cursor*MakeCursor(void*,a_statement*,int,a_cursor_spec*,unsigned,unsigned,PlanInfo*,unsigned,unsigned)
     a_db_cursor*dbi_partialopen(void*,a_statement*,unsigned,a_cursor_spec*,PlanInfo*,unsigned)
     a_db_cursor*a_plan_cache::OpenPartial(a_stmt*,a_statement*,unsigned,a_cursor_spec*,PlanInfo*)
     void dbi_describe_statement(a_stmt*,unsigned short,unsigned short,a_cursor_spec*,unsigned*)
     void db__describe_output(Connection*,an_sqlpres_receive*)
     void RequestProcedure::call()
     void Context::call(Procedure*,Context**)
     void Worker::call_on_stack(Procedure*)
     void TopProcedure::call()
     int Worker::spawn(Procedure*)
     void Stream::handle_ind(unsigned char,unsigned)
     void Stream::execute()
     unsigned RQBaseItem::do_work(Worker*)
     void DeferredCall::worker_body()
     void request_task()
     void OldTaskStart(void*)
     run_task_body
     void*Task::pre_body(void*)
     _lwp_start 

Read more...

Environment

SAP IQ 12.7 ESD3 
SAP IQ 12.7 ESD4
SAP IQ 12.7 ESD5

Product

Sybase IQ 12.7

Keywords

stack trace file, stacktrace , shutdown,  crash , , 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.