SAP Knowledge Base Article - Preview

2299121 - Query causes server crash. SAP IQ16 SP08

Symptom

Simple query causes server crash with stacktrace

I. 03/29 21:25:21. 0000000018 **************************************************
I. 03/29 21:25:21. 0000000018 ***   SAP IQ Abort:
I. 03/29 21:25:21. 0000000018 ***      From:  stcxtlib\st_server.cxx:846
I. 03/29 21:25:21. 0000000018 ***      PID: 3788
I. 03/29 21:25:21. 0000000018 ***      Message: Program Abort
I. 03/29 21:25:21. 0000000018 ***      Thread: 3480  (TID: 13)
I. 03/29 21:25:21. 0000000018 **************************************************
I. 03/29 21:25:21. 0000000018 
I. 03/29 21:25:21. 0000000018     **  Error from IQ connection:  SA connHandle: 2  SA connID: 23  IQ connID: 0000000018  User: DWA
I. 03/29 21:25:21. 0000000018     **  Time of error:  2016-03-29 21:25:21
I. 03/29 21:25:21. 0000000018     **  IQ Version:  SAP IQ/16.0.0/150721/P/sp08.35
I. 03/29 21:25:21. 0000000018     **  OS info:  IQ built on: MS/Windows 2003,  Executed on: Windows/PBLT5V-PMISDB01/WinNT/6.1/Build 7601/Service Pack 1/x86 Family/level 6/Model 63/Stepping 2/3 CPU(s)
I. 03/29 21:25:21. 0000000018     **  Command status when error occured:  CURSOR ACTIVE
I. 03/29 21:25:21. 0000000018     **  Command text: 

I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB4A53F7:  void __cdecl pcpstack(unsigned long,unsigned long,class db_log * __ptr64,class hos_fd * __ptr64,int) 00000001805e52e0 f hos_stacktrace.obj +0x117
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB4A70D7:  void __cdecl DumpAllThreads(char const * __ptr64,unsigned int,int,unsigned long,unsigned long) 00000001805e6ec0 f hos_stacktrace.obj +0x217
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB271B21:  void __cdecl hos_ABORT(char const * __ptr64,unsigned int,char const * __ptr64,char * __ptr64,char * __ptr64) 00000001803b1960 f hos_abrt.obj +0x1c1
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBAF0BBA:  long __cdecl ExcpFilter(struct _EXCEPTION_POINTERS * __ptr64) 0000000180c30b80 f st_server.obj +0x3a
I. 03/29 21:25:22. 0000000018 pc: 0x0000000077249490:  UnhandledExceptionFilter + 352
I. 03/29 21:25:22. 0000000018 pc: 0x00000000774643B8:  MD5Final + 7656
I. 03/29 21:25:22. 0000000018 pc: 0x00000000773E85A8:  _C_specific_handler + 156
I. 03/29 21:25:22. 0000000018 pc: 0x00000000773F9D0D:  RtlDecodePointer + 189
I. 03/29 21:25:22. 0000000018 pc: 0x00000000773E91AF:  RtlUnwindEx + 3007
I. 03/29 21:25:22. 0000000018 pc: 0x0000000077421278:  KiUserExceptionDispatcher + 46
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB8B8317:  public: int __cdecl hs_ohc::ForceInsertProbeAll(unsigned __int64 * __ptr64)const __ptr64 00000001809f82c0 f s_ohcidx.obj +0x57
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB8D6F87:  private: void __cdecl hs_ohc::DoPushDown(void) __ptr64 0000000180a16f60 f s_ohcidx.obj +0x27
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB8D7675:  private: virtual void __cdecl hs_ohc::CheckTierThreshold(void) __ptr64 0000000180a173c0 f s_ohcidx.obj +0x2b5
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB8D733A:  public: void __cdecl hs_ohc::DoMerge(void) __ptr64 0000000180a172a0 f s_ohcidx.obj +0x9a
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB93B296:  public: virtual void __cdecl hs_ohcUpdate::Complete(void) __ptr64 0000000180a7aa50 f s_ohcupd.obj +0x846
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBC56D9F:  private: void __cdecl db_UpdateCompleteIterator::CompleteIndex(class s_indexUpdate * __ptr64) __ptr64 0000000180d96d40 f db_insrtn.obj +0x5f
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBC18C0C:  public: virtual int __cdecl db_UpdateCompleteIterator::ExecWork(int & __ptr64,unsigned int) __ptr64 0000000180d58b10 f db_update.obj +0xfc
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB4899E6:  public: virtual void __cdecl workAllocator::DoWork(unsigned int) __ptr64 00000001805c98d0 f hos_team.obj +0x116
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB4A38F6:  private: void __cdecl hos_team::StartWork(void (__cdecl*)(void * __ptr64,void * __ptr64),void * __ptr64) __ptr64 00000001805e37d0 f hos_teamn.obj +0x126
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB489F20:  public: virtual void __cdecl hos_team::Exec(class hos_workIter & __ptr64) __ptr64 00000001805c9ee0 f hos_team.obj +0x40
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBC19999:  private: virtual void __cdecl db_sqlinsert::UpdateComplete(void) __ptr64 0000000180d59780 f db_update.obj +0x219
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBC1D15B:  private: virtual void __cdecl db_sqlinsert::UpdateExecute(void) __ptr64 0000000180d5ccb0 f db_update.obj +0x4ab
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBC0FD09:  private: virtual void __cdecl db_sqlinsert::Execute(void) __ptr64 0000000180d4fbb0 f db_sqlins.obj +0x159
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBAB7927:  public: void __cdecl st_command::DoCmdThroughResourceGate(void) __ptr64 0000000180bf7840 f st_command.obj +0xe7
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBAEE22B:  public: virtual unsigned int __cdecl st_iqdml::Update(struct a_statement * __ptr64,class UIConnection * __ptr64,class UICursor * __ptr64) __ptr64 0000000180c2dfc0 f st_iqdml.obj +0x26b
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EAEC58FA:  UIQDML_Update 00000001800058e0 f iqdml_iq.obj +0x1a
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBAF3E04:  public: void __cdecl st_SAIQInterfaceInfo::callFunction(void) __ptr64 0000000180c33df0 f st_SAIQInterface.obj +0x14
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBB3AED0:  public: void __cdecl st_SAIQInterface::RunIQFunc(class st_SAIQInterfaceInfo * __ptr64) __ptr64 0000000180c7ad40 f st_SAIQInterfacen.obj +0x190
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EBAF4379:  public: void __cdecl st_SAIQInterface::Execute(int,void * __ptr64,unsigned int (__cdecl*)(void * __ptr64,void * __ptr64),void * __ptr64,unsigned int) __ptr64 0000000180c33f60 f st_SAIQInterface.obj +0x419
I. 03/29 21:25:22. 0000000018 pc: 0x00000000EB4B6431:  public: virtual void __cdecl saint_iqthresholddml::Update(struct a_statement * __ptr64,class IConnection * __ptr64,class ICursor * __ptr64) __ptr64 00000001805f63d0 f saint_iqthresholddml.obj +0x61
I. 03/29 21:25:22. 0000000018 pc: 0x0000000071009FED:  void __cdecl dbi_update(class Connection * __ptr64,struct a_statement * __ptr64,class a_stmt * __ptr64,union a_stmt_identifier * __ptr64,unsigned int) 0000000020159f70 f riinter.obj +0x7d
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710DD36E:  class a_cursor * __ptr64 __cdecl DoExecuteBodyLocal(class Connection * __ptr64,class a_stmt * __ptr64,struct a_statement * __ptr64,union a_stmt_identifier * __ptr64,bool,unsigned int,unsigned short) 000000002022d030 f rnsql.obj +0x33e
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710DE497:  class a_cursor * __ptr64 __cdecl DoExecuteBody(class Connection * __ptr64,class a_stmt * __ptr64,struct a_statement * __ptr64,union a_stmt_identifier * __ptr64,bool,unsigned int,unsigned short) 000000002022e430 f rnsql.obj +0x67
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710E250E:  void __cdecl DoExecuteStmt(class Connection * __ptr64,class a_stmt * __ptr64,struct a_statement * __ptr64,union a_stmt_identifier * __ptr64,unsigned short,unsigned int) 00000000202320e0 f rnsql.obj +0x42e
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710E340E:  void __cdecl db__execute(class Connection * __ptr64,struct an_sqlpres_receive * __ptr64) 0000000020233270 f rnsql.obj +0x19e
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710EF942:  public: virtual void __cdecl RequestProcedure::call(void) __ptr64 000000002023f2a0 f rnstream.obj +0x6a2
I. 03/29 21:25:22. 0000000018 pc: 0x0000000070F7E209:  public: void __cdecl Context::call(class Procedure * __ptr64,class Context * __ptr64 * __ptr64) __ptr64 00000000200ce1a0 f worker.obj +0x69
I. 03/29 21:25:22. 0000000018 pc: 0x0000000070F7E4D0:  public: void __cdecl Worker::call_on_stack(class Procedure * __ptr64) __ptr64 00000000200ce470 f worker.obj +0x60
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710EA247:  public: virtual void __cdecl TopProcedure::call(void) __ptr64 000000002023a210 f rnstream.obj +0x37
I. 03/29 21:25:22. 0000000018 pc: 0x0000000070F804B2:  public: int __cdecl Worker::spawn(class Procedure * __ptr64) __ptr64 00000000200d03c0 f worker.obj +0xf2
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710EC17E:  public: void __cdecl EngStream::handle_ind(unsigned char,unsigned int) __ptr64 000000002023c090 f rnstream.obj +0xee
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710ED21B:  public: void __cdecl EngStream::execute(void) __ptr64 000000002023cee0 f rnstream.obj +0x33b
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710EA5B0:  public: virtual unsigned int __cdecl RQBaseItem::do_work(class Worker * __ptr64) __ptr64 000000002023a580 f rnstream.obj +0x30
I. 03/29 21:25:22. 0000000018 pc: 0x0000000071119F1D:  public: static void __cdecl RequestQueue::worker_body(void) 0000000020269eb0 f kernel.obj +0x6d
I. 03/29 21:25:22. 0000000018 pc: 0x00000000710EA56B:  void __cdecl request_task(void * __ptr64) 000000002023a4f0 f rnstream.obj +0x7b
I. 03/29 21:25:22. 0000000018 pc: 0x000000007147589C:  private: static void __cdecl W32Task::pre_body(void * __ptr64) 00000000205c5800 f ntkernel.obj +0x9c
I. 03/29 21:25:22. 0000000018 pc: 0x00000000771C652D:  BaseThreadInitThunk + 13
I. 03/29 21:25:22. 0000000018 pc: 0x00000000773FC521:  RtlUserThreadStart + 33
I. 03/29 21:25:22. 0000000018 pid = 3788 tEntry.th32OwnerProcessID 3788 tEntry.th32ThreadID 2612 ctid 3480
I. 03/29 21:25:22. 0000000018


Read more...

Environment

IQ Version:  SAP IQ/16.0.0/150721/P/sp08.35

Product

SAP IQ 16.0

Keywords

stcxtlib\st_server.cxx ,  int __cdecl db_UpdateCompleteIterator, ExecWork, long __cdecl ExcpFilter(struct _EXCEPTION_POINTERS * __ptr64) , 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.