SAP Knowledge Base Article - Preview

2128691 - DELETE or UPDATE statements stack trace at s_dpNBit::Delete - SAP IQ

Symptom

DELETE or UPDATE  statements abort with the following error and stack

Dump all thread stacks at stcxtlib/st_server.cxx:1709 for PID: 2757
    ***************** This is the STACKTRACE ***************
 
===== Thread Number  99  (IQ connID: 0000011980) =====
pc: 0x0 (0x1, 0x0)
pc: 0xfffffd7b96b71187 void DumpAllThreads(const char*,unsigned,int)+0x29f(0x100000000, 0xfffffd7b991efe70)
pc: 0xfffffd7b96856cca void hos_ABORT(const char*,unsigned,const char*,char*,char*)+0x1a2(0x7320746867756163,
                             0x3131206c616e6769)
pc: 0xfffffd7b9782f10d SigHndlr+0x41(0xfffffd7b9c4b5c40, 0xfffffd7ffd7025e2)
pc: 0xfffffd7ffd70dd16 _fini+0x64bf9026(0xfffffd7b9c4b5ff8, 0xb7b925030)
pc: 0xfffffd7ffd7025e2 _fini+0x64bed8f2(0x0, 0x9)
pc: 0xfffffd7ffd70280e _fini+0x64bedb1e(0xb, 0xfffffd7b9c4b5ff8)
pc: 0xffffffffffffffff _fini+0x1284c6f(0x0, 0xfffffd7b9c4b64c0)
pc: 0xfffffd7b977c7263 void s_dpNBit::Delete(const unsigned long long*,unsigned,int)+0xbf(0x0, 0x0)
pc: 0xfffffd7b96e3423c int hs_dp::DeleteNBit(const s_bm*,int)+0x284(0x1bd4a030, 0x7ffd000000004)
pc: 0xfffffd7b96e3546c void hs_dp::DeleteInternal(const s_bm*,unsigned long long,int,int,s_CKInfo*,
                             const hos_ValueRange*,int,hs_btcursor*,hs_btcursor*,hs_btcursor*)
                             +0x1018(0x97b9fdc30, 0x0)
pc: 0xfffffd7b96e539fe void hs_dp::Delete(const s_bm*,unsigned long long,int,int,s_CKInfo*,
                             const hos_ValueRange*)+0x3a(0x97b9fdc30, 0x0)
pc: 0xfffffd7b9798d20b void hdb_delete_indices::Unit_of_Work(int)+0x257(0xfffffd7b99186870, 0x1000000001)
pc: 0xfffffd7b9798d51a int hdb_delete_indices::hdb_delete_index_iter::ExecWork(int&,unsigned)+0x156(0x0, 0xffffffff)
pc: 0xfffffd7b96b3dc8e void workAllocator::DoWork(unsigned)+0x21a(0xfffffd7b98d35cf0, 0xfffffd7b98d35d20)
pc: 0xfffffd7b96b6eeed void hos_team::StartWork(void(*)(void*,void*),void*)+0x1f1(0x2, 0xfffffd7b9c4ba910)
pc: 0xfffffd7b96b41225 void hos_team::Exec(hos_workIter&)+0x159(0x0, 0x97b9a2880)
pc: 0xfffffd7b9798bc65 void hdb_hdelete::Delete(const char*)+0x561(0x97b9a2880, 0x97b9a1f68)
pc: 0xfffffd7b964ef95d void dfo_DeleteRoot::Complete()+0x2b1(0xfffffd7b9c4bb090, 0xfffffd7b9642ec34)
pc: 0xfffffd7b977e0bb2 void st_cursorIQtoSA::Complete()+0x812(0xfffffd7b993b4410, 0xfffffd7b9c4bbdf0)
pc: 0xfffffd7b9627fabd void df_Delete::Complete()+0x2d(0x1a, 0x0)
pc: 0xfffffd7b977d27ea void st_command::DoCmdThroughResourceGate()+0x1ce(0xfffffd7b9c4bbc80, 0x0)
pc: 0xfffffd7b978278b5 unsigned st_iqdml::Delete(a_statement*,UIConnection*,UICursor*)+0x65(0x0, 0xfffffd7b9c4bd2e0)
pc: 0xfffffd7b962008d5 UIQDML_Delete+0x21(0xfffffd7b9c4bc0b8, 0xfffffd7b9c4bd2e0)
pc: 0xfffffd7b9782f97c void st_SAIQInterfaceInfo::callFunction()+0x1c(0xfffffd7c5b6edd10, 0xfffffd305b6edb30)
pc: 0xfffffd7b978b424d void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x28d(0xfffffd7b9c4bd2f0,
                             0xfffffd7ffe2020ac)
pc: 0xfffffd7b9782ff91 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)
                             +0x259(0xfffffd7c5b6d7630, 0xfffffd7c396b4060)
pc: 0xfffffd7b96b841f1 void saint_iqthresholddml::Delete(a_statement*,IConnection*,ICursor*)
                             +0x59(0x0, 0xfffffd7bc50bf480)
pc: 0xfffffd7ffe03c4ea void dbi_delete(Connection*,a_statement*,a_stmt*,a_stmt_identifier*,unsigned)
                             +0x72(0x6caa9, 0x6c65642020203b27)
pc: 0xfffffd7ffe190cb5 a_cursor*DoExecuteBodyLocal(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,bool,
                             unsigned,unsigned short)+0x16e9(0x0, 0x15b6edd10)
pc: 0xfffffd7ffe192640 void DoExecuteStmt(Connection*,a_stmt*,a_statement*,a_stmt_identifier*,
                             unsigned short,unsigned)+0xb5c(0xc91120, 0x100029c27)
pc: 0xfffffd7ffe0f64f4 unsigned exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)
                             +0x2ccc(0x3a5b6a1000, 0xf00000000)
pc: 0xfffffd7ffe0f87e0 unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)
                             +0xbcc(0xfffffd7c5b45e060, 0x0)
pc: 0xfffffd7ffe0f9f70 unsigned dbi_resume_procedure(a_context_ref*,unsigned)+0xc8(0x0, 0x0)
pc: 0xfffffd7ffe19ba6b void do_cursor_execute(Connection*,a_stmt*)+0x667(0xfffffd7b9c4bea10, 0xfffffd7c3884c650)
pc: 0xfffffd7ffe19c483 void db__execute_any_imm(Connection*,an_sqlpres_receive*)+0x19b(0x0, 0x1ffe202418)
pc: 0xfffffd7ffe1abd69 void RequestProcedure::call()+0x799(0x80009c4b005c, 0x48f7b8)
pc: 0xfffffd7ffdf493f1 void Context::call(Procedure*,Context**)+0xc5(0xfffffd7c5b6851a0, 0xfffffd7fff1f99b0)
pc: 0xfffffd7ffdf4a195 void Worker::call_on_stack(Procedure*)+0x49(0xfffffd7fff22e680, 0xfffffd7b9c4bed4c)
pc: 0xfffffd7ffe1aca53 void TopProcedure::call()+0x43(0xfffffd7b9c4bed50, 0x48f3e0)
pc: 0xfffffd7ffdf4a0a3 int Worker::spawn(Procedure*)+0xc3(0x48f, 0xfffffd01fe905f9c)
pc: 0xfffffd7ffe1acd21 void EngStream::handle_ind(unsigned char,unsigned)+0x189(0x0, 0x48f378)
pc: 0xfffffd7ffe1ae1d2 void EngStream::execute()+0x52a(0xfffffd7fff365e98, 0x48f3e0)
pc: 0xfffffd7ffe1aee82 unsigned RQBaseItem::do_work(Worker*)+0x22(0x5c00000000, 0xfffffd7fff20e980)
pc: 0xfffffd7ffe202b37 void RequestQueue::worker_body()+0x1cf(0x0, 0x0)
pc: 0xfffffd7ffe1aedd5 void request_task(void*)+0x85(0xfffffd7b9c4befc0, 0x48f2d0)
pc: 0xfffffd7ffe2050b5 void*UnixTask::pre_body(void*)+0x119(0x0, 0x0)
pc: 0xfffffd7ffd70d9db _fini+0x64bf8ceb(0x0, 0x0)


Read more...

Environment

SAP IQ 16 which has been upgraded from IQ 15.x

Product

SAP IQ 16.0

Keywords

crash, abort, nbit, Sybase, corruption , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.