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

Search for additional results

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