Symptom
- Insert #temp_table select columns from base_table , may crash in stcxtlib/st_server.cxx:1919 with following message in .iqmsg file.
----
0000103851 ************************************************** 0000103851 *** SAP IQ Abort: 0000103851 *** From: stcxtlib/st_server.cxx:1919 0000103851 *** PID: 3914 0000103851 *** Message: caught signal 11, program abort 0000103851 *** Thread: 47171548539200 (TID: 713) 0000103851 **************************************************
----
- The problem thread in stack trace file may look similar to this.
----
Thread 539 (Thread 0x2ae6fb64e940 (LWP 4641)):
#0 0x00002ae688a89e0f in waitpid () from /lib64/libc.so.6 #1 0x00002ae688a2c4a1 in do_system () from /lib64/libc.so.6 #2 0x00002ae688a2c7f7 in system () from /lib64/libc.so.6 #3 0x00002ae6e94f623a in ucstkgentraceClose(int, int, int, int) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #4 0x00002ae6e94f71b6 in DumpAllThreads(char const*, unsigned int, int) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #5 0x00002ae6e9278e5e in hos_ABORT(char const*, unsigned int, char const*, char*, char*) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #6 0x00002ae6e9feeaaf in SigHndlr () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #7 <signal handler called> #8 0x00002ae688a6b36e in memcpy () from /lib64/libc.so.6 #9 0x00002ae6e9d82d44 in hs_ohcGroup<s_btdiskblock, s_btitem>::GetUnconditionedKey(void*, int, void*, int*) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #10 0x00002ae6e9d88242 in hs_ohcGroup<s_btdiskblock, s_btitem>::FetchOrdered(int&, void*, int*, int, unsigned long long&) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #11 0x00002ae6ea22683f in s_fetchOrdered::Fetch() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #12 0x00002ae6ea21fd64 in vp_Cursor::Fetch() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #13 0x00002ae6e90495bb in dfo_VerticalLeafCursor::FetchOpus() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #14 0x00002ae6e8f6e9e9 in dfjo_NestedLoop::Fetch_T2_IntoStore() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #15 0x00002ae6e8f66c05 in dfjo_NestedLoop::SourcePreFetch() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #16 0x00002ae6e8fd4c70 in dfo_Join::SourcePreFetch() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #17 0x00002ae6e8f3d8d1 in dfjo_Hash::ExecWork(int&, unsigned int) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #18 0x00002ae6e94cdc6a in workAllocator::DoWork(unsigned int) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #19 0x00002ae6e94f4594 in hos_thread::Main() () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #20 0x00002ae6e945d9c8 in hos_lwtask::Start(hos_lwtask*) () from /sybase/IQ-16_0/bin64/../lib64/libiq16.so #21 0x00002ae686f881fd in IQWorkerStarter(void*) () from /sybase/IQ-16_0/lib64/libiqserv16_r.so #22 0x00002ae68768dc2d in run_task_body () from /sybase/IQ-16_0/lib64/libiqserv16_r.so #23 0x00002ae6871c0967 in UnixTask::pre_body(void*) () from /sybase/IQ-16_0/lib64/libiqserv16_r.so #24 0x00002ae68835283d in start_thread () from /lib64/libpthread.so.0 #25 0x00002ae688ac4fcd in clone () from /lib64/libc.so.6
----
Read more...
Environment
SAP IQ 16 SP10+
Product
SAP IQ 16.0
Keywords
hs_ohcGroup::GetUnconditionedKey ; hs_ohcGroup<s_btdiskblock, s_btitem>::GetUnconditionedKey ; stack trace ; stack ; stktrc ; stcxtlib/st_server.cxx:1919, 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.