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

Search for additional results

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