SAP Knowledge Base Article - Preview

2363874 - query using a sort merge pushdown join crashes the server - SAP IQ 15.2


The IQ server fails when a query is using a sort merge pushdown join on a heavily loaded server.

Excerpt of IQMSG:

pc: 0x000000001EE0BDBC:  void __cdecl pcpstack(unsigned long,unsigned long,class db_log * __ptr64,class hos_fd * __ptr64,int) 00000001804bbca0 f hos_stacktrace.o +0x11c
pc: 0x000000001EE0DB09:  void __cdecl DumpAllThreads(char const * __ptr64,unsigned int,int,unsigned long,unsigned long) 00000001804bd990 f hos_stacktrace.o +0x179
pc: 0x000000001EBE75B8:  void __cdecl hos_ABORT(char const * __ptr64,unsigned int,char const * __ptr64,char * __ptr64,char * __ptr64) 0000000180297400 f hos_abrt.o +0x1b8
pc: 0x000000001F3593AA:  long __cdecl ExcpFilter(struct _EXCEPTION_POINTERS * __ptr64) 0000000180a09370 f st_server.o +0x3a
pc: 0x000000007786B30F:  UnhandledExceptionFilter + 351
pc: 0x0000000077A1EBF0:  RtlGetUserInfoHeap + 448
pc: 0x00000000779EECAD:  _C_specific_handler + 1621
pc: 0x00000000779EE13D:  RtlSetCriticalSectionSpinCount + 125
pc: 0x00000000779EEA57:  _C_specific_handler + 1023
pc: 0x00000000779F59F8:  KiUserExceptionDispatcher + 46
pc: 0x000000001EE99B60:  public: void __cdecl s_bloom::InitForNextWorkunit(int,class hos_datum * __ptr64) __ptr64 0000000180549b50 f s_bloom.o +0x10
pc: 0x000000001EAA11C3:  public: virtual int __cdecl dfo_FillSemiJoinFilter::PrepareForNextWorkUnit(void) __ptr64 0000000180151190 f dfo_FillSemiJoinFilter.o +0x33
pc: 0x000000001EAF5951:  public: virtual int __cdecl dfo_cOrderByParaIn::ExecWork(int & __ptr64,unsigned int) __ptr64 00000001801a5520 f dfo_cOrderBy.o +0x431
pc: 0x000000001EDF464E:  public: virtual void __cdecl workAllocator::DoWork(unsigned int) __ptr64 00000001804a4530 f hos_team.o +0x11e
pc: 0x000000001EE12742:  private: void __cdecl hos_team::StartWork(void (__cdecl*)(void * __ptr64,void * __ptr64),void * __ptr64) __ptr64 00000001804c2650 f hos_teamn.o +0xf2
pc: 0x000000001EDF4B90:  public: virtual void __cdecl hos_team::Exec(class hos_workIter & __ptr64) __ptr64 00000001804a4b50 f hos_team.o +0x40
pc: 0x000000001EAF687B:  public: virtual void __cdecl dfo_cOrderByParaIn::PrefetchAndSort(void) __ptr64 00000001801a61c0 f dfo_cOrderBy.o +0x6bb
pc: 0x000000001EAEF29F:  public: virtual void __cdecl dfo_cOrderBy::SourcePreFetch(void) __ptr64 000000018019f260 f dfo_cOrderBy.o +0x3f
pc: 0x000000001EA6773E:  protected: void __cdecl dfjo_MergeBase::T2_PreFetch(void) __ptr64 0000000180117570 f dfjo_Merge.o +0x1ce
pc: 0x000000001EA67A68:  protected: virtual void __cdecl dfjo_MergeBase::SourcePreFetch(void) __ptr64 0000000180117920 f dfjo_Merge.o +0x148
pc: 0x000000001EAB3103:  protected: virtual void __cdecl dfo_Join::SourcePreFetch(void) __ptr64 00000001801630c0 f dfo_Join.o +0x43
pc: 0x000000001EA99630:  protected: virtual int __cdecl dfo_Combiner::FetchOpus(void) __ptr64 0000000180149540 f dfo_Combiner.o +0xf0
pc: 0x000000001EA630A8:  public: int __cdecl dfo::Fetch(void) __ptr64 0000000180113050 f i dfjo_Hash.o +0x58
pc: 0x000000001EACED4D:  private: virtual int __cdecl dfo_Cursor::FetchOpus(void) __ptr64 000000018017ed00 f dfo_Cursor.o +0x4d
pc: 0x000000001EA630A8:  public: int __cdecl dfo::Fetch(void) __ptr64 0000000180113050 f i dfjo_Hash.o +0x58
pc: 0x000000001EA630A8:  public: int __cdecl dfo::Fetch(void) __ptr64 0000000180113050 f i dfjo_Hash.o +0x58
pc: 0x000000001F327CF6:  private: void __cdecl st_cursorIQtoSA::FetchRows(unsigned int) __ptr64 00000001809d7c70 f st_cursor.o +0x86
pc: 0x000000001F32A70C:  public: virtual void __cdecl st_cursorIQtoSA::Execute(void) __ptr64 00000001809da300 f st_cursor.o +0x40c
pc: 0x000000001E999909:  private: virtual void __cdecl df_OpenCursor::Execute(void) __ptr64 00000001800498d0 f df_dmlcommands.o +0x39
pc: 0x000000001F324667:  public: void __cdecl st_command::DoCmdThroughResourceGate(void) __ptr64 00000001809d4580 f st_command.o +0xe7





SAP Sybase IQ 15.2



SAP Sybase IQ 15.2


CR638597, 638597, CR#638597, stacktrace, stktrc , 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.