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

Search for additional results

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