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 for Me (Login required).

Search for additional results

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