SAP Knowledge Base Article - Preview

2757120 - Write node crashes when a table is being loaded

Symptom

In a IQ Multiplex environment, one writer node crashes when a table is being loaded. The following stack trace prints to stktrc file of that writer node:

** Error from IQ connection: SA connHandle: 117740 SA connID: 7 IQ connID: 0000211592 User: dba ** Time of error: 2019-01-22 22:33:44 ** IQ Version: SAP IQ/16.0.110/10940/P/sp11.19 ** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/ZDC2/2.6.32-754.6.3.el6.x86_64/#1 SMP Tue Sep 18 10:29:08 EDT 2018/x86_64 ** Command status when error occured: CURSOR ACTIVE ** Command text:

load into table "owner_name"."table_name"
( "col_name1" '#',"col_name2" '#',"col_name3" '#',"col_name4" '#',"col_name5" '#',"col_name6" '#',"col_name7" '#',"col_name8" '#',"col_name9" '#',"col_name10" '#',"col_name11" '#',"col_name12" '#',"col_name13" '#',"col_name14" '#',"col_name15" '#',"col_name16" '#',"col_name17" '#',"col_name18" '#',"col_name19" '#',"col_name20" '#',"col_name21" '#',"col_name22" '#',"col_name23 '#',"col_name24" '#',"col_name25" '#',"col_name26" '#',"col_name27" '#',"col_name28" '#',"col_name29" '#',"col_name30" '#',"col_name31" '#',"col_name32" '#',"col_name33" '#',"col_name34" '#',"col_name35" '#',"col_name36" '#',"col_name37" '#',"col_name38" '#',"col_name39" '#',"col_name40" '#',"col_name41" '#',"col_name42" '#',"col_name43" '#',"col_name44" '#',"col_name45" '#',"col_name46" '#',"col_name47" '#',"col_name48" '#',"col_name49" '#',"col_name50" '#',"col_name51" '#',"col_name52" '#',"col_name53" '#',"col_name54" '#',"col_name55" '#',"col_name56" '#',"col_name57" '#',"col_name58" '#',"col_name59" '#',"col_name60" '#',"col_name61" '#',"col_name62" '#',"col_name63" '#',"col_name64" '#',"col_name65" '#',"col_name66" '#',"col_name67" '#',"col_name68" '#',"col_name69" '#',"col_name70" '#',"col_name71" '#',"col_name72" '#',"col_name73 '#',"col_name74" '#',"col_name75" '#',"col_name76" '#',"col_name77" '#',"col_name78" '#',"col_name79" '#',"col_name80" '#',"col_name81" '#',"col_name82" '#',"col_name83" '#',"col_name84" '#',"col_name85" '#',"col_name86" '#',"col_name87" '#',"col_name88" '#',"col_name89" '#',"col_name90" '#',"col_name91" '#',"col_name92" '#',"col_name93" '#',"col_name94" '#',"col_name95" '#',"col_name96" '#',"col_name97" '#',"col_name98" '#',"col_name99" '#',"col_name100" '#',"col_name101" '#',"col_name102" '#',"col_name103" '#',"col_name104" '#',"col_name105" '#',"col_name106" '#',"col_name107" '#',"col_name108" '#',"col_name109" '#',"col_name110" '#',"col_name111" '#',"col_name112" '#',"col_name113" '#',"col_name114" '#',"col_name115" '#',"col_name116" '#',"col_name117" '#',"col_name118" '#',"col_name119" '#',"col_name120" '#',"col_name121" '#',"col_name122" '#',"col_name123" '#',"col_name124" '#',"col_name125" '#',"col_name126" '#',"col_name127" '#',"col_name128" '#',"col_name129" '#',"col_name130" '#',"col_name131" '#',"col_name132" '#',"col_name133" '#',"col_name134" '#',"col_name135" '#',"col_name136" '#',"col_name137" '#',"col_name138" '#',"col_name139" '#',"col_name140" '#',"col_name141" '#',"col_name142" '#',"col_name143" '#',"col_name144" '#',"col_name145" '#',"col_name146" '#',"col_name147" '#',"col_name148" '#',"col_name149" '#',"col_name150" '#',"col_name151" '#',"col_name152" '#',"col_name153" '#',"col_name154" '#',"col_name155" '#',"col_name156" '#',"col_name157" '#',"col_name158" '#',"col_name159" '#',"col_name160" '#',"col_name161" '#',"col_name162" '#',"col_name163" '#',"col_name164" '#',"col_name165" '#',"col_name166" '#',"col_name167" '#',"col_name168" '#',"col_name169" '#',"col_name170" '#',"col_name171" '#',"col_name172" '#',"col_name173" '#',"col_name174" '#',"col_name175" '#',"col_name176" '#',"col_name177" '#',"col_name178" '#',"col_name179" '#',"col_name180" '#',"col_name181" '#',"col_name182" '#',"col_name183" '#',"col_name184" '#',"col_name185" '#',"col_name186" '#',"col_name187" '#',"col_name188" '#',"col_name189" '#',"col_name190" '#',"col_name191" '#',"col_name192" '#',"col_name193" '#',"col_name194" '#',"col_name195" '#',"col_name196" '#',"col_name197" '#',"col_name198" '#',"col_name199" '#',"col_name200" '#',"col_name201" '#',"col_name202" '#',"col_name203" '#',"col_name204" '#',"col_name205" '#',"col_name206" '#',"col_name207" '#',"col_name208" '#',"col_name209" '#',"col_name210" '#',"col_name211" '#',"col_name212" '#',"col_name213" '#',"col_name214" '#',"col_name215" '#',"col_name216" '#',"col_name217" '#',"col_name218" '#',"col_name219" '#',"col_name220" '#',"col_name221" '#',"col_name222" '#',"col_name223" '#',"col_name224" '#',"col_name225" '#',"col_name226" '#',"col_name227" '#',"col_name228" '#',"col_name229" '#',"col_name230" '#',"col_name231" '#',"col_name232" '#',"col_name233" '#',"col_name234" '#',"col_name235" '#',"col_name236" '#',"col_name237" '#',"col_name238" '#'...

Dump all thread stacks at stcxtlib/st_server.cxx:1949 for PID: 40041

***************** This is the STACKTRACE ***************

===== Thread Number  140053353875200  (IQ connID: 0000211592) =====
pcstkwalk
ucstkgentrace
DumpAllThreads
hos_ABORT
SigHndlr+0x4f

ConvertColumn_hos_dtint64
dfo_FileSource::FetchOpus
dfo_CheckConstraintFilter::FetchOpus
dfo_ColumnVectorBase::FetchOpus
dfo_RowID::FetchOpus
dfo_IndexInsert::FetchOpus
df_CombinerFetchContext::Fetch
hc_dfrun::FillRun
hc_dmfrun::InitNextWorkUnit
hc_dmfrun::ExecWork
workAllocator::DoWork
hos_thread::Main
hos_lwtask::Start
IQWorkerStarter
run_task_body
UnixTask::pre_body


Read more...

Environment

  • SAP IQ 16.0. SP11

Product

SAP IQ 16.0

Keywords

SAP IQ, dfo_CheckConstraintFilter, dfo_ColumnVectorBase, df_CombinerFetchContext, InitNextWorkUnit, load table, CR 818391 , 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.