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

Search for additional results

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