SAP Knowledge Base Article - Preview

2282370 - IQ Freezes or slows down to the point a where a reboot is done.

Symptom

IQ is running just fine and all the sudden all processes stop running. 

When pstacks are take on the spid - you will find:

Threads (1): 766
unsigned short UnixTask::wait(unsigned short)
void RWLatch::get_exclusive(int)
load_proc_definition(df_SysCursor*)
DB_Load_procedure(unsigned*,char*,unsigned,an_errmap_index*)
lookup_procedure_ex2(an_expr_node*,an_errmap_index*)
dbi_call_result(a_statement*,a_call*,IDBHeap*)
DefineImplicitResultSet(a_statement*,a_statement_heap_ref*)
parse(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*,unsigned,unsigned,unsigned*,SQLFlagger*)
PrepareStringUsingHeap(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*,unsigned,unsigned,SQLFlagger*)
PrepareStringAgain(a_statement_heap_ref*,const dfv_Value&,a_parse_goal,unsigned*)
add_procedure_statments(a_proc_def*,const dfv_Value&,unsigned)
load_proc_statements(a_proc_def*)
DB_Load_procedure(unsigned*,char*,unsigned,an_errmap_index*)
dbi_find_procedure_ex2(an_expr_node*)
process_call(Connection*,a_context_ref*,a_statement*)
exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)
unsigned run_procedure(a_context_ref*,dfm_CallInfo*,unsigned,Connection*,unsigned)
unsigned dbi_resume_procedure(a_context_ref*,unsigned)
a_cursor*handle_open(Connection*,a_stmt*,an_isolation_level,unsigned)
db__open(Connection*,an_sqlpres_receive*)
RequestProcedure::call()
Context::call(Procedure*,Context**)
Worker::call_on_stack(Procedure*)
TopProcedure::call()
Worker::spawn(Procedure*)
EngStream::execute()
RQBaseItem::do_work(Worker*)
DeferredCall::worker_body()
request_task(void*)
UnixTask::pre_body(void*)

 

This causes a deadlock with another spid:

Threads (1): 848
unsigned short UnixTask::wait(unsigned short)
Mutex::wait_for_mutex(Task*,int)
Mutex::get(Task*,int)
Worker::get_all_forbid_mutexes()
Worker::forbid(unsigned,unsigned,unsigned,unsigned)
DB_Commit_Chgs(Connection*)
 ri_commit(Connection*)
Connection::commit_work()
DbCleaner::clean()
DbCleaner::do_request()
Worker::spawn(Procedure*)
RQInternalBaseItem::do_work(Worker*)
DeferredCall::worker_body()
request_task(void*)
UnixTask::pre_body(void*)

 


Read more...

Environment

SAP IQ 15.3x

Product

Sybase IQ 12.7

Keywords

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.