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

Search for additional results

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