2458357 - results from sp_iqcontext may cause stack trace with saint_iqthresholdddl::IQUtility - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2458357 - results from sp_iqcontext may cause stack trace with saint_iqthresholdddl::IQUtility - SAP IQ

Symptom

In SAP IQ15.4 ESD#3 when running a lot of sp_iqcontext server crashes with the following stack trace:

**  Error from IQ connection:  SA connHandle: 4  SA connID: 30  IQ connID: 0000000020 
**  Time of error:  2017-04-13 10:21:47   
**  IQ Version:  Sybase IQ/15.4.0/130221/P/ESD 3   
**  OS info:  IQ built on: Sun_x64/OS 5.10, 
**  Command status when error occured:  COMMAND ACTIVE   
**  Command text: 
sp_iqcontext
Dump all thread stacks at hos_throw.cxx:313 for PID: 18239

    ***************** This is the STACKTRACE ***************

 ===== Thread Number  103  (IQ connID: 0000000020) =====
pc: 0x0 (0x0, 0xfffffd7f00000000)
pc: 0xfffffd7f7eb5272f void DumpAllThreads(const char*,unsigned,int)+0x29f(0xfffffd7f7faefd70, 0x0)
pc: 0xfffffd7f7e897695 void hos_ABORT(const char*,unsigned,const hos_exception&,char*,char*)+0x4ed(0x0, 0x493a80)
pc: 0xfffffd7f7eb7c142 void Throw(const hos_exception&)+0x2ba(0xfffffd7f7fbf63b0, 0xfffffd7f00000000)
pc: 0xfffffd7f7eb0d391 void hos_memmgr::FreeHosMem(void*)+0x2ed(0xfffffd7f7ebc20bc, 0xfffffd7ff3d8b830)
pc: 0xfffffd7f7e424c89 __SLIP.DELETER__UB+0x31(0xfffffd7f7ebc20bc, 0xfffffd7ff3d8d610)
pc: 0xfffffd7f7e407401 db_iqutilityCloseCursor::~db_iqutilityCloseCursor()+0x31(0xfffffd7f7f9c6c60, 0xa00000002)
pc: 0xfffffd7f7e3fec1a unsigned db_iqddl::IQUtilityCloseCursor(UIConnection*,void**)+0x32(0xfffffd7ff3d8b9f0, 0xfffffd7ff3d8cc10)
pc: 0xfffffd7f7ebc10ef UIQDDL_IQUtilityCloseCursor+0x1f(0xfffffd7ff3d8b9e8, 0xfffffd7ff3d8cc10)
pc: 0xfffffd7f7f5b3ee4 void st_SAIQInterfaceInfo::callFunction()+0x1c(0xfffffd7f00000000, 0x0)
pc: 0xfffffd7f7f5b5bc5 void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x279(0xfffffd7ff3d8cbe0, 0xfffffd7ffe64ddab)
pc: 0xfffffd7f7f5b44d5 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)+0x25d(0xc4dc40, 0x182d823c8)
pc: 0xfffffd7f7f58ce21 void saint_iqthresholdddl::IQUtility(const a_statement*,IConnection*,ITable*)+0x273d(0x1, 0xfffffd7f83aac930)
pc: 0xfffffd7ffe760571 void dbi_iq_utilities(a_statement*)+0x89(0x0, 0x0)
pc: 0xfffffd7ffe831ac8 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,unsigned,unsigned short)+0x31c(0x0, 0xfffffd7f83a841b0)
pc: 0xfffffd7ffe834436 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,unsigned short,unsigned)+0xa6e(0x0, 0x0)
pc: 0xfffffd7ffe7b3b6c void process_exec_immediate(Connection*,a_context_ref*,a_statement*)+0x400(0xfffffd7f831fd9a0, 0xfffffd7f830558e0)
pc: 0xfffffd7ffe7b570e unsigned exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)+0x962(0xfffffd7f831cb750, 0x0)
pc: 0xfffffd7ffe7b85d7 unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)+0x363(0xfffffd7f832ae060, 0x0)
pc: 0xfffffd7ffe7ba298 unsigned dbi_resume_procedure(a_context_ref*,unsigned)+0xc8(0x0, 0x0)
pc: 0xfffffd7ffe83a5ff a_cursor*handle_open(Connection*,a_stmt*,an_isolation_level,unsigned)+0x66f(0xfffffd7ff3d8e880, 0xfffffd7fff205dbc)
pc: 0xfffffd7ffe83acef void db__open(Connection*,an_sqlpres_receive*)+0x3ef(0x21f43e2a00, 0x8000000000)
pc: 0xfffffd7ffe84a753 void RequestProcedure::call()+0x72f(0xfffffd7f831ad1a0, 0x4881b8)
pc: 0xfffffd7ffe66d215 void Context::call(Procedure*,Context**)+0xb1(0x5f3d8ec20, 0xfffffd7fff37b7c0)
pc: 0xfffffd7ffe66db49 void Worker::call_on_stack(Procedure*)+0x49(0xfffffd7fff39ecc0, 0xfffffd7ff3d8ed4c)
pc: 0xfffffd7ffe84b97b void TopProcedure::call()+0x43(0xfffffd7ff3d8ed50, 0x487e00)
pc: 0xfffffd7ffe66da57 int Worker::spawn(Procedure*)+0xc3(0x487, 0xfffffd01fee65521)
pc: 0xfffffd7ffe84bc38 void EngStream::handle_ind(unsigned char,unsigned)+0x17c(0x0, 0x487d98)
pc: 0xfffffd7ffe84d20e void EngStream::execute()+0x73e(0xfffffd7fff388d20, 0x487e00)
pc: 0xfffffd7ffe84da5a unsigned RQBaseItem::do_work(Worker*)+0x22(0x6000000000, 0xfffffd7fff4aefd0)
pc: 0xfffffd7ffe882ee7 void RequestQueue::worker_body()+0x1bb(0x0, 0x0)
pc: 0xfffffd7ffe84d9ab void request_task(void*)+0x4f(0xfffffd7ff3d8efc0, 0x487cf0)
pc: 0xfffffd7ffe885509 void*UnixTask::pre_body(void*)+0x119(0x0, 0x0)
pc: 0xfffffd7ffdfddaeb _fini+0x7e7313cb(0x0, 0x0)

 


Read more...

Environment

SAP IQ15.4 ESD#3

Product

SAP Sybase IQ 15.4

Keywords

dbi_iq_utilities, sp_iqcontext, saint_iqthresholdddl , 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.