1990950 - Server crashes for query while generating graphical plan - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1990950 - Server crashes for query while generating graphical plan - SAP IQ

Symptom

  • IQ server crashes at st_server.cxx:1409 while generating graphical plan with statistics level 3 for DML statements like SELECT .. INTO, UPDATE in IQ 15.2 ESD 2:

**************************************************
*** Sybase IQ Abort:
*** From: st_server.cxx:1409
*** PID: 18995
*** Message: caught signal 11, program abort
*** Thread: 3483351312 (TID: 1)
**************************************************
** Error from IQ connection: SA connHandle: 1 SA connID: 9 IQ connID: 0000000006 User: DBA
** IQ Version: Sybase IQ/15.2.0/101123/P/ESD 2
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.9-67.0.4.ELsmp, Executed on: Linux/jmartin2-linux/2.6.31.14-0.4-desktop/#1 SMP PREEMPT
** Command status when error occured: NO COMMAND OR CURSOR ACTIVE
** Parser command text: select graphical_plan( 'SELECT * into #tmp FROM iq_repro ORDER BY 1 ASC',3,'ASENSITIVE','READ-ONLY')
Dump all thread stacks at st_server.cxx:1409 for PID: 18995

  • The iqmsg contains no stack trace or error. The stack trace file generated contains the following functions:

waitpid () from /lib64/libc.so.6
do_system () from /lib64/libc.so.6
system () from /lib64/libc.so.6
DF_Execute_query ()
PlanInfo::BuildPlan ()
dbi_access_plan ()
dfm_CallInfo::Invoke ()
dfm_MachineState::DoInvoke ()
dfm_MachineState::InvokeFunctionStackArgs ()
#Run ()
dfm_ByteMachine::Invoke ()
dfo_Root::EvaluateSelect ()
dfo_Root::DoFetch ()
dfo_Root::DoFirstFetch ()
dfo_Base::Fetch ()
dfo_Root::DoFetchRelative ()
dfo_Root::FetchRelative ()
DB_Search_fetch ()
do_move_cursor ()
dbi_fetch ()


Read more...

Environment

SAP IQ 15.1 and higher.

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

CR657332, 657332 , 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 ONE Support launchpad (Login required).

Search for additional results

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